Use Formula Builder to create and validate expressions - New

Last updated on Nov 18, 2026
Alert

This article contains prerelease information. Release dates, features, and other information are subject to change without notice.

Build formulas with guided field and function selection, check syntax, and correct errors before saving expressions in modern authoring.

Formula Builder in Adobe Acrobat Sign helps you create expressions for calculated fields and custom formula-based validation rules. Instead of entering an entire formula from memory, you can select existing fields, browse available functions, and assemble the expression in a guided editor.

Formula Builder also checks expressions for syntax errors, helping you identify and correct problems before saving.

Before you begin

Add the form fields that your expression will reference and give them meaningful, unique names. Formula Builder uses these names when inserting field references.

You can use Formula Builder for two purposes:

  • Calculated fields: Determine a field's value automatically using other field values, constants, operators, or functions.

  • Custom formula-based validation: Define a condition that recipient input must satisfy.

Both use the same Formula Builder interface.

Open Formula Builder

You can open Formula Builder from the properties of a calculated field or a field that supports custom formula-based validation.

For a calculated field

In the modern authoring environment, select the field you want to calculate.

Open Customize field.

Set Value type to Calculated.

Select the formula icon in the field properties.

Formula Builder opens, allowing you to create or edit the calculated expression.

Calculated field properties showing Value type set to Calculated, a populated Formula field, and the fx button used to open Formula Builder.
Select the fx button in the Formula field to open Formula Builder.

For custom formula-based validation

Select the field whose input you want to validate.

Open Customize field and locate the field's validation settings.

Select the custom formula-based validation option.

Open Formula Builder from the validation formula control.

You can then define the condition that the recipient's input must satisfy.

Field properties showing Text format set to Custom - Formula, a populated Validation formula field, and the fx button for opening Formula Builder.
Select Custom - Formula from Text format, then select the fx button to open Formula Builder.

Build a formula

Formula Builder provides an expression editor and a catalog of supported fields, keywords, and functions. Each catalog entry includes a description and example to help you select the appropriate element.

Place the cursor where you want to insert an expression element.

Browse the available fields, keywords, or functions.

Select an item to insert it at the cursor position. You can also enter expressions directly in the editor.

Add the necessary operators, values, and function arguments to complete the expression.

Review the expression before checking its syntax.

Example: Calculate an investment total

Suppose an agreement contains two Number fields named Initial Investment and Investment - Second round, and you want a third field to calculate the total.

Enter the following expression in Formula Builder:

Example formula

[Initial Investment] + [Investment - Second round]

The expression adds the values entered in the two named fields. The calculated field displays the resulting value instead of requiring the recipient to calculate it.

For additional operators, functions, and field-reference syntax, see Calculated field formulas and functions.

Formula Builder showing a valid expression, syntax confirmation, operator controls, and a list of fields available for insertion.
Build expressions by inserting fields, functions, and operators, then check their syntax before saving.

Check and correct formula syntax

Use Check Syntax to verify an expression before saving it.

Select Check Syntax after completing the expression.

Review the validation result.

If an error appears, use the error message and its indicated position to identify the problem.

Correct the expression and select Check Syntax again.

When the expression passes syntax validation, select OK to save it.

Formula Builder showing an invalid expression with an error message that a referenced field cannot be found and an unavailable OK button.
If an expression is invalid, Formula Builder explains the problem and prevents you from saving it.

An expression that fails syntax validation cannot be saved. Formula Builder keeps OK unavailable until the expression is valid.

Syntax validation checks whether the expression can be interpreted correctly. It does not guarantee that the expression produces the intended value for every possible recipient input.

Reset or cancel your changes

Formula Builder provides controls for managing the editing session:

Control

Result

Check Syntax

Checks the expression and reports syntax errors.

Reset

Clears the expression in the editor.

Cancel

Closes Formula Builder without saving your changes.

OK

Saves the validated expression.

  • Use Reset when you want to rebuild an expression from the beginning.
  • Use Cancel when you want to leave the editor without applying your changes.

Review the expression before using it

Before sending an agreement or saving a reusable template, confirm that the expression references the intended fields and produces the expected result.

Test calculated expressions with representative values, particularly when using conditional logic, dates, or several dependent fields.

For custom validation expressions, test values that should pass and values that should fail the rule. A syntactically valid expression can still produce an unintended result if its logic does not match your requirements.