Calculated - Mapping Type

Calculated - Mapping Type - Introduction

  • Users can calculate App Fields from your Form Fields by using 'Calculated' mapping feature.

  • Types of Calculated fields

    1. Predefined

    2. Expression

      • Standard Expression

      • Custom Expression

Predefined Calculated Values

Some of the types of predefined values that are supported are

  • Current Date/Time

  • Form Respondent Email

  • Form Author Email

  • Form Response Timestamp

  • Unique Id

  • Auto Increment

Current Date/Time

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

  • Select the mapping type as Calculated.

  • Choose the type as Pre Defined.

  • Select Current Date/Time.

  • Choose date operation , "plus" or "minus".

  • Set the required increment/decrement options , default is "0 Minutes"

  • Select the date format required.

  • Select the required time zone.


Form Respondent Email

  • Select the mapping type as Calculated.

  • Choose the type as Pre Defined.

  • Select Form respondent Email. This will give the email of form respondent if the form is set to collect email.

Form Author Email

  • Choosing this will include the form owners email address to the mapping field after form submission

Form Response Timestamp

  • Choosing this will include the date and time of form submission to the mapping field after form submission

Unique Id

  • Choosing this will randomly generate an unique Id to the mapping field after form submission

Auto Increment

Choosing an auto increment field will keep track of your each form submission in a incremented order.

  • Open Edit Mapping

  • Choose App Field.

  • Choose Calculated Field and Type as Pre Defined.

  • Choose Auto increment from drop down list.

  • Set Prefix and digits size.

  • Save the mapping dialog.

Expression

There are two types of Expressions

  • Standard

  • Custom

Standard

This section contains some common arithmetic operations like

  • Sum

  • Difference

  • Average

  • Date Add

  • Date Deduct

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

Date Add

Add dates by using values from form fields or you can manually add values.

  • Choose Type as Date Add.

  • Select the required form field.

Select Form Field or Value. If Form Field is selected the value will be taken automatically from Form or if value is selected you need to enter the value manually.

  • Choose the required form field with value.

  • Select the required period.

Periods maybe

  1. Seconds

  2. Minutes

  3. Hours

  4. Days

  5. weeks

  6. Months

  7. Years

  • If value is selected

  • Select the required duration.

  • Selected the required period also.

Date Deduct

Deduct dates by using values from form fields or you can manually deduct values.

  • Choose Type as Date Deduct.

  • Select the required form field.

Select Form Field or Value. If Form Field is selected the value will be taken automatically from Form (or) if the value is selected you need to enter the value manually.

  • Choose the required form field with the value.

  • Select the required period.

Periods maybe

  1. Seconds

  2. Minutes

  3. Hours

  4. Days

  5. weeks

  6. Months

  7. Years

  • If value is selected

  • Select the required duration.

  • Selected the required period also.

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