Users can calculate App Fields from your Form Fields by using the 'Calculated' mapping feature.
Types of Calculated fields
Predefined
Expression
Standard Expression
Custom Expression
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
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.
Select Insert as Image if required.
Mention the required Width.
Users can select the width size as auto or even give manual width size.
Users can select the Height as auto or even give manual height.
Image Over Cells:
This option will allow users to insert images over the cells of Google Sheet.
Note: This option is only available for the Google Sheets app in Form Director.
Image in Cell:
This option will allow users to insert images into the cells of Google Sheet.
Note: This option is only available for the Google Sheets app in Form Director.
Select Format as Number option.
Select the type of number format required.
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.
Choosing this will include the form owners email address to the mapping field after form submission.
Choosing this will include the date and time of form submission to the mapping field after form submission.
Choosing this will randomly generate a unique Id to the mapping field after form submission.
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 the drop-down list.
Set Prefix and digits size.
Save the mapping dialog.
There are two types of Expressions
Standard
Custom
This section contains some common arithmetic operations like
Sum
Difference
Average
Date Add
Date Deduct
Case
Add your Form responses and direct them to your app field
Choose Sum in the dropdown.
Click on add button to choose which are the fields you need to add.
Click on save.
Subtract the values from your form responses.
Choose Difference in the dropdown.
Click on add button to choose which are the fields you need to subtract.
Click on save.
Get the 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.
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 the value is selected you need to enter the value manually.
Choose the required form field with a value.
Select the required period.
Periods maybe
Seconds
Minutes
Hours
Days
weeks
Months
Years
If the value is selected
Select the required duration.
Selected the required period also.
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
Seconds
Minutes
Hours
Days
weeks
Months
Years
If the value is selected.
Select the required duration.
Selected the required period also.
This allows users to automatically change the text type of a particular field to Upper case or Lower case or Title case.
Select the type as "Case".
Choose the required form field.
Select the required conversion type.
The available conversion types are
Upper case
Lower case
Title case
Do all your custom calculations by choosing custom