Pro, Business and Enterprise plans
Use calculations to figure out a value for something. Calculations can refer to other fields on your form. If you’re taking payments, they're the best choice for calculating how much to charge someone.
Add a calculation field to your form and give it a name, then we can go through how to use it.
Often, a calculation refers to other fields in the form and uses mathematical operators and functions to calculate a value based on those fields. You don't need to add fields to a calculation—you can just write a string of numbers, operators, and functions—but we're guessing you probably will.
Here’s a basic calculation for calculating ticket cost:
The calculation checks how many tickets the responder wants, then multiplies that number by ten, because one ticket costs $10.
To build a calculation:
If you want, use the dropdown menu to add other fields from your form. Choose Number, calculation or date field to reference one of those field types; or choose Variable to reference a dropdown, checkbox or radio button field.
If you’re adding a number, calculation or date field: Choose a section of your form, then a field within that section. Press Insert to add it to the calculation.
If you’re adding a variable: Choose a section of your form, then a field within that section. Press Create variable to assign values to each option, then press Create and insert. For help with advanced values, jump to Make advanced calculations using variables.
Type operators and functions to refine the calculation. Jump to Operators and functions to see the full list and learn more.
Click Save calculation, then save your form.
We automatically display calculation fields as currency. If you don’t want this, open the field settings by choosing the gear icon and disable Display as currency.
Want to use your calculation in a payment field? Jump to Use a calculation in a payment field.
Still confused? Check out our calculation examples to get an idea of how to use them.
Operators and functions
Use mathematical operators and functions to calculate the value you need.
+ = Add
- = Subtract
* = Multiply
/ = Divide
To use an operation, type it in-between a number or another field, like this:
In this example, the calculation will multiply the number of tickets by ten.
- max() = Find the maximum value of multiple fields. Separate each field or number with a comma.
- min() = Find the minimum value of multiple fields. Separate each field or number with a comma.
- avg() = Find the average value of multiple fields. Separate each field or number with a comma.
- abs() = Find the absolute value of a field or number
- roundup() = Round up a field or a number
- rounddown() = Round down a field or a number
When rounding up or down, you can add a number after the field to specify how many decimal points to round to.
- yearOfDate() = Find the year of a given date or date field
- monthOfDate() = Find the month of a given date or date field
- dayOfDate() = Find the day of a given date or date field
- dateDiff() = Find the difference between two given dates or date fields
When using yearOfDate(), monthOfDate(), dayOfDate(), or dateDiff(), you can add a date field, or type in a date yourself—just make sure you contain it within single quote marks. You can use any of these date formats:
yyyy-MM-dd, e.g. yearOfDate('2018-12-30')
d MMM yyyy, e.g. yearOfDate('30 Dec 2018')
d MMMM yyyy, e.g. yearOfDate('30 December 2018')
To use a function, put a field or number—or multiple fields or numbers—between the brackets like this:
In this example, the calculation will find the largest value of the two fields.
The calculation will still work fine if the last bracket of a function is on a second line.
Make advanced calculations using variables
When you add a variable to a calculation you assign values to each option. If you want a more detailed way of setting an option’s value, click Advanced to open the rule builder. The rule builder lets you choose the earlier answers that will determine the option’s value. You can add as many rules per option as you like.
To build a rule for the value, choose a section, a field, and a response to the field; then press Add. Set a value for the rule in the Value box.
In this example, if someone lives in Melbourne and their answer to When are you going to this event? is after 11 December 2018, the value will be 20.
If you need an example to help you understand the rule builder better, check out our calculation examples.
Use a calculation in a payment field
Once you’ve set up your calculation field, add a payment field to your form. Instead of typing a cost into the payment area, choose your new calculation field from the Use a calculation field value menu.
Remember to save your form when you’re done.
When to hide your calculation field: Your calculation field will be automatically shown on your published form. If you're using it in a payment field, you'll see the same number twice, which you probably don't need. Visit Show or hide fields using display logic to find out how to hide your calculation field so it isn't shown to your form responders.
That’s everything you need to know about calculations. Check out our calculation examples for a deeper understanding, or visit Take payments through your form for more information on payments.