Guide Building workflows

Calculated Fields

Add a form field whose value is computed from other fields with a formula — so totals, names, and references fill themselves in instead of being typed.

Updated

Admin
Open ApproveThis

Calculated Fields are form fields whose value is computed from other fields instead of typed in by the person filling out the form. You write a formula that references other fields using {{field_slug}} syntax, with support for arithmetic, string concatenation (~), comparisons, and ternary conditionals. This guide is for Administrators building a form, and it covers writing and saving the formula itself. You'll need a flow with a calculated field already added to its form.

Who this is for: admin.

Write the formula for the calculated field

Totals, full names, and reference codes that are derived from other answers should not depend on a requester typing them correctly. Writing the formula once means the field fills itself in every time the form is submitted, on all tiers.

  1. Sign in as the Administrator.

  2. Click Click to edit formula... on the calculated field to open the formula editor.

    Step 2
    Step 2
  3. Click Available Fields to see the field slugs you can reference in the formula.

    Step 3
    Step 3
  4. Enter the formula in Type your formula here..., referencing other fields with {{field_slug}} syntax and combining them with arithmetic, concatenation (~), comparisons, or a ternary conditional — the example uses {{first_name}} ~ {{last_name}} to join two name fields.

    Step 4
    Step 4
  5. Click Save Formula.

    Step 5
    Step 5

The formula is stored when the confirmation Formula saved successfully appears.