When creating your paper or digital form, you can add formula fields for math calculations.
Field ID’s
Script fields are represented with field ID’s. Our formulas are similar to excel but since we do not have cell numbers (A1 + A2) our fields are represented with field ID’s which is a strand of letters and numbers unique to that field.
(= c0d888a0-00bf-4ded-a1d7-641c1cf4279a + d0d888a0-00bf-4ded-a1d7-641c1cf4279a)
Null or Empty Values
Script treats empty values as blank cells. Calculating empty fields will result in a formula error.
- Pro Tip: Set the default values of the field to 0 if involved in a calculation so that your field is not considered empty
Digital Form Builder Formulas
Once you have Created a Digital Form, you can add formulas by clicking the formula tool on the left hand side of the screen.
From here, the formula box will be added at the bottom of the digital form.
Give the formula a Label and Helper Text
To create the formula, click ‘Insert Field’
Select the field you wish to calculate and press ‘Insert Field’
Link the field ID’s with the formulas you would like. Common formulas are:
- Addition: +
- Subtraction: -
- Division: /
- Multiplication: *
- SUM
- SUMIF
- SUMIFS
- AVERAGE
- COUNTIF
Format your field to either:
- General format includes letters and numbers
- Currency format includes a $
- Number format limits to only numeric characters
Mark the field hidden if you would like to hide the value from the end-user of the form. The data will be saved for reporting purposes and can be used in downloading data, notifications, and conditional branches.
Paper Form Builder Formulas
Once you have Created a Paper Form, you can add formulas by dragging and dropping the formula field onto the pdf.
To create a formula, you must copy the Field ID from another field by clicking on the Field ID.
Note: Field IDs are created on a paper form by pressing Save>Back>Edit Form. This creates a data point to pull data from.
Under the formula field, link the field ID’s with the formulas you would like. Common formulas are:
- Addition: +
- Subtraction: -
- Division: /
- Multiplication: *
- SUM
- SUMIF
- SUMIFS
- AVERAGE
- COUNTIF
Pro Tip: If you are doing lengthy calculations, paste the field ID’s into a spreadsheet to create your formula then paste the completed formula into the Formula Field