Configure Calculated Field

What is calculated field?

Calculated fields are non editable fields which calculates it's value from other configured document fields.

For example :

Inside a Invoice ${Total} can be a calculated field because Total will be calculated based on number of items and prices.

How to configure Calculated Field?

You can configure the calculated fields by selecting "Calculated" as field type and by providing valid custom expressions.

Calculated Field Types :

  • Pre-Defined
  • Expression

Pre-Defined Calculated Fields

Some of the types of predefined values that are supported are

  • Unique Id
  • Current Date and Time

Unique Id :

Each new form submission will be generated with a System Generated Unique Id.

Steps to configure Unique Id :

  • Click on "Create New Field" and select field type as "Calculated".
  • Next Select "Calculated Type" as "Pre-Defined" from a drop down option.
  • Select "Unique Id" option.
  • Save the field configuration.

Current Date/Time :

Each new form submission will be generated with a Form Submission Date And Time.

Steps to configure Current Date/Time :

  • Click on "Create New Field" and select field type as "Calculated".
  • Next Select "Calculated Type" as "Pre-Defined" from a drop down option.
  • Select "Current Date/Time" option.
  • Choose "Date/Time Format" and "Time Zone" (default local timezone).
  • Save the field configuration.

Expression Calculated Fields

Types of Expressions

  • Custom Expression

Custom Expression :

Calculates the user custom expressions and generates the document/pdf.

Follow the steps to set custom expressions

  • Click on create new field give field name and select field type as "Calculated Field".
  • Go to "Custom Expression" , select input fields(form fields) from right corner menu(3 dotted symbol).
  • Custom Expression can have any valid mathematical expression including (), +, * , / etc.
  • Configure your custom expression and click on "Check Expression".
  • Provide some test values for your fields and click on "Test Expression"
  • Test Expression will evaluate your values and provide the test results.

Web Form View

  • Save your all field configuration and click on "Open Web Form" or "Open Inline Form" and start filling the form fields.
  • Calculated field is only readable(output of your custom expression) and cannot be editable.
  • Invalid or incomplete expression will show INVALID message inside the calculated field.
  • After all form fields are filled click on "Generate Document".

Invalid Inputs :

Valid Inputs:

Generated Output File: