configure calculated fields

How do I map app field to be calculated from form fields?

Now you can calculate app fields from your form fields by using 'Calculated fields' feature

For example, you can calculate total by adding multiple input fields from the form.

Types of Calculated fields

  • Predefined
  • Expression

Predefined Calculated Values

Some of the types of predefined values that are supported are

  • Current Date and Time
  • Submitter Email Id
  • Unique Id

Current Date and Time

Choosing this will Include the current date and time with the specified format that you have selected

Active User Email

Choosing this will include the Form Submitter Email address

Unique Id

Choosing this will randomly generate an unique Id

expression

There are two types of Expressions

  • Standard
  • Custom

Standard

This section contains some common arithmetic operations like

  • Sum
  • Difference
  • Average

Sum

Add your Form responses and direct it to your app field

  • Choose Sum in the dropdown
  • Click on add button to choose which are the fields that you need to add
  • Click on save

Difference

Subtract the values from your form responses

  • Choose Difference in the dropdown
  • Click on add button to choose which are the fields that you need to subtract
  • Click on save

Average

Get Average of the values you selected from your form response

  • Choose Average in the dropdown
  • Click on add button to choose which are the fields that you need to get average
  • Click on save

Custom

Do all your custom calculations by choosing custom

Insert the form fields into expression by click on three dots on the right corner

Check your custom expression by clicking on check expression and see your result