With 123FormBuilder, you can perform calculations on your web forms & surveys. Use form calculations to add mathematical operations between your fields on your online forms.
First, you need to assign the values to your products/services. To do so, add a choice field (Single/Multiple choice or Dropdown field) and list the available choices.
Click the field to open its options in the left-side panel and select Value / Price. Next to each option type in their correspondent price.
If you need the user to type in a custom amount, add a Number field and assign the value “1”. By default, a field has no value assigned to it, meaning the input will be multiplied by zero. By assigning a value, the form will calculate input value X 1. ( e.g user types 123, the number field will calculate 123 X 1= 123 instead of 123 X 0= 0).
When you are using a Number (input) field, it also works as a quantity field. Assign the full price to the field (e.g $150). If the user types 2, the calculation will be 2 X 150 = 300$.
To create mathematical operations on your form, add a Formula field. This field will show the total value in real-time.
Add a Formula field from the Specific fields section. A calculator will appear where you can add operations between your form fields. Use the Add field button within the calculator to add your form fields. Once the field is selected, it will be automatically added to the formula. You can use your keyboard to add operators and values.
You can also add calculations between Date fields. The operation between two Date fields will return the value in the number of days.
Important Notes
Here’s how the form is calculating the examples used in this guide:
Your email address will not be published.
Here is a list of the most frequently asked questions. For more FAQs, please browse through the FAQs page.
How to make a invoice form which have data list and their prize like ms excel
Hello, after creating your order form you can export the entries to excel. More details you can find here: https://www.123formbuilder.com/docs/how-to-export-to-excel-web-form-submissions/
how do you round decimal places in formula results
Hello Paul! This isn’t possible at the moment. However, please contact us at customercare@123formbuilder.com maybe we can find a workaround. Thank you and have a great day!