Enable Calculations
At times, it may be necessary to run simple math calculations within a forms, such as addition or multiplication. To use calculations with a Number, Currency, or Option Range gadget, they will need to be enabled by selecting the toggle within the settings.
- Begin by adding either the Number, Currency, or Option Range gadgets to the form to house the total for the calculation.
- Next, enable calculations by toggling on the Enable calculations option within the settings for the total field.
- Select the type of calculation (sum, subtract, multiply, product, average, median, min, max or count).
- After you have selected the type of calculation to use, you can select the Number, Currency, or Option Rage field you wish to calculate (ie: Field 1, Field 2, etc).
- When the user enters a value into the two fields selected, the calculation will be shown in the enabled field.
Calculations for Currency
When using calculations for currency, it’s important to make sure you’re setting the current output for the total.
For example, I want to calculate the dollar amount of sandwiches multiplied by the number of sandwiches purchased (currency x amount = $ total).
- For this example, you would need to add a currency gadget for Cost of Sandwiches, a number gadget for Number of Sandwiches, and a currency widget to house Total Sandwiches.
- Once the fields are established, toggle the Enable calculations setting to turn it on.
- For determining the total, select product under Type of Calculation, and then select Cost of Sandwiches for Field 1, and Number of Sandwiches for Field 2.
- Change the toggle at the top of the form to Preview.
- Enter the appropriate values into the fields, and the Total Sandwiches Cost will automatically calculate!
The enable calculations setting is only available on the Number, Currency, and Option Range gadgets.
Enable Calculation Footer
At times, it may be necessary to run simple math calculations within a forms, such as addition or multiplication. To use calculations for number or currency gadgets within a table or repeater, the calculation footer will need to be enabled by selecting the toggle within the settings.
Once the table or repeater gadget has been add to the form:
- Toggle the Enable Calculation Footer option within the table settings.
- For each item in the table, select the type of calculation. For example, selecting sum will add the values of the column together.
- When the user enters a value into the fields selected, and the sum for each column will be calculated automatically in the footer.
The calculation footer setting will only be available for the table and repeater gadgets.
Comments
0 comments
Article is closed for comments.