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

Did this answer your question?