How To Setup Advanced Calculations For A Form

A few terms first...

For text fields, there is a field name and a label.

Screen_shot_2011-02-03_at_12.56.55_PM.png

Here's the difference: 

The label is displayed next to the field as, well, a label for the field. This is what lets the user know what to enter.

The field name is used as reference when viewing and exporting the data. Any data entered in this field will show up in a column named for the field name.

For things like checkboxes, radio buttons and jumpdown menus besides the above field name and label each item similarly has a label and value.

Screen_shot_2011-02-03_at_12.57.15_PM.png

NOTE: When working with numbers, be sure to set the "Data Format Test" on each field in the calculation to "Number" to prevent errors.

 

The value acts in the same way as the field name. Your value will need to be one word. They may looks like "name" "adult" "child" "tshirtsmall" "tshirtmed" in the settings for an element.

A value or field name will need to be a number for an advanced calculation to work. (So make sure you don't put special characers such a $ for the value or field name.)

To make an advanced calculation for a form:

For these steps we're assuming you want to setup something like a total amount text field.

  1. Setup a text field.
  2. Expand the "Advanced Settings" section in the settings.
  3. Check "Make this field read-only," "Include browser-side Javascript to perform calculations live" and "Perform calculations on the server for security."
  4. Add your calculation in the "Calculation" field and click "save."

The calculation will look something like the following...

Screen_shot_2011-02-03_at_12.56.11_PM.png

Example Calculation:

({adult}*40)+({child}*30)+({tshirtsmall}*10)+({tshirtmed}*10)

Make sure to place the field names that you wish to be included in the calculation inside brackets as shown: {field name} 

You can use parentheses to create an order of operations and you can use the following operators: + - * /

 This field will now become dynamic and calculate a total based on what is inputed in other fields.

Have more questions? Submit a request

0 Comments

Article is closed for comments.