Make calculations in your forms such as additions, subtractions, multiplications, and divisions!
No MoreApp account yet? Sign up here.
1. Add a Subform
In this example, we will use hours worked times the hourly wage. Select the form and click Edit Form. Double click on the Subform-widget to insert it in your form.
Now, you can add the Lookup-widget along with the Number-widget in the Subform-widget. Click on the pencil of the Lookup-widget, to edit the widget, and add the days of the week to the options field. Lastly, edit the Number-widget and name it as Hours.
2. Configure the Calculation-widget
Go to the main form. Under the Widgets tab, you will see the Pro tab. Double-click on the Calculation-widget to add it to your form.
Give the widget a name, under Label, and configure the Operator according to your needs. You can use different widgets of the form as Calculation Terms.
Also, if the value you want to calculate is a price, you can check the box “The calculated value is a price“.
By checking the box “No value on invalid term“, the calculation will not show any value if one of the terms is not valid (for example, if it is not a number).
When checking the box “Ignore hidden widgets“, the widgets that are not visible in the form will not be calculated when performing calculations.
2.1. Summing up
In this example, we will sum up the hours of the week. You can edit the widget by clicking on the pencil and choose summing up (+) for the Operator field. As a Calculation Term, you can select Hours.
Click on Save when you're finished editing the widget.
To multiply the hours worked by the hourly wage, add the Price-widget to your form. Insert another Calculation-widget and select Multiply (*) as the Operator. Lastly, as the Calculation term, select Hours and the Cost per hour.
After that, click Save & Publish.
2.3. Calculating with fields from the Search-widget
It's also possible to calculate with fields from the Search-widget.
You can also calculate with Catalogue-widget!
2.4. Minimum and Maximum
With the Minimum and Maximum operator, you can find the lowest number and the highest number between several Number-widgets.
As the Operator, choose min or max depending on the result you want to obtain. Add all the Number-widgets as Calculation Terms.
You have successfully installed and configured the Calculation-widget! Now you can divide, subtract, add, and multiply in seconds!
Want to stay up to date with our latest tutorials? Go to YouTube and hit the Subscribe button!