Table Calculations in Forms

You can add simple calculation fields to custom table sections in Forms. The available calculations are designed to support workflows like quality, safety, and daily operations by letting you capture calculated data, such as totals or time differences, based on what your form fillers enter in.

In this topic, you'll find:

• Use cases for table calculations
• How to add a calculation field to a custom table in a form template
• Limitations of Table Calculations

Use Cases for Table Calculations

Table calculations in Forms are useful for a variety of scenarios, including:

• Time difference calculations: Track the duration of events, such as equipment usage or training attendance:
  • Equipment usage (Time in use = Out – In)
  • Deliveries tracking (Time on site = Out – In)
  • Training attendance (Time spent = Out – In)
• Numerical Addition: Sum values in a row, such as total hours worked including regular, overtime, and lunch hours
• Numerical Multiplication: Calculate totals based on quantity and rate, such as crew work hours or material usage.
  • Crew work log: Number of workers x hours worked per worker
  • Material tracking: Units of fence x hours

Add a Calculation Field to a Custom Table in a Form Template

1. Modify an existing template or create a new one.

2. Add or navigate to a Table section.

3. Select the column in the table where you want the calculation data to appear.

4. In the Data type field, select Calculation.

5. Select from the available data types:

   • Numerical: Supports additional and multiplication on numerical fields in the same row.
   • Time: Supports calculating the difference between two time fields in the same row.

6. Select the action you want performed:

   • Numerical: Add
   • Numerical: Multiply
   • Time: Calculate difference (Column 1-Column 2)

7. Select the fields to include in the calculation.

   Note: You can only select columns that match the data type of the calculation field. For example, if you want to calculate a difference in time, you can only select Columns where the data type is Time.

8. Click Save.

• If the result is not an integer, numerical fields are rounded to 5 decimal places.
• Time differences are calculated to the minutes.

Table Calculation Limitations

We are continuously working to improve the capabilities of table calculations in Forms. Check out our roadmap for updates on additional calculation features.

The following actions are not supported in calculation fields in custom tables in Forms:

• Subtraction between numerical fields
• Division between numerical fields
• Addition, multiplication, or division of time fields
• Cross-row calculations
• Using a Calculation field as input for another calculation
• Combining numerical and time fields in a single calculation