In the modern authoring environment, select the field you want to calculate.
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
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.
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.
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.
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.
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.