Mapping
Empower yourself to use the form responses as you wish.
"6 different mapping types combined with automatic mapping - the real booster for connecting whatever we wish to connect from responses to apps"
What is Mapping?
Mapping is a configuration in Form Director that defines how to arrive at the value of the dynamic fields in ${fieldname} format for the selected Application (App Field). This is a powerful feature that helps users to configure what they want as value for the App fields.
For example, a text value submitted in the form for question "What is your Name?" can be mapped to "First Name" in the Contact App.
Terminologies:
It is important to understand the terminology as it is referred through-out in Form Director documentations.
Form Field - The questions or fields from the Google Form
App Field - fields of the chosen App. Example - fields in ${fieldname} format in Google Docs/ Slides. First Name in Contact App
System Field - the system info that Form Director can extract/ generate from the Google Form. e.g. Form Name, Response Timestamp etc.
Types of Mapping
Mapping can be done by one of the following way
Mapping App Field with Form Field
Mapping App Field with Templated Field
Mapping App Field With Calculated Field
Mapping App Field with Service Result
Mapping App Field with Lookup
Mapping App Field with Conditional
Every mapping of App Field need to choose mapping type
Default mapping type is "Form Field"
Mapping App Field with Form Field
Map the App Fields with the corresponding Form Fields.
This is most popular and simplest way of doing mapping.
The value for the App Field will be taken from the value of the Form Field (Question) submitted by the user
Mapping App Field with Templated Values
Template is a free flowing text with dynamic fields that will be replaced at the runtime of the service.
Template allows you to have multiple Form Fields from Google Form to be used to a single Application field.Â
In Templated message, users can use a Field Picker to insert Form Field, System Field, App Field etc.Â
It may also be used to set constant values for App Field
Mapping App Field With Calculated Values
Users can calculate App Fields from your Form Fields by using 'Calculated' mapping feature.
Types of Calculated fields
Predefined
Expression
Standard Expression
Custom Expression
Mapping App Field with Service Result
Service Chaining allows you to send the previous service result to the next service.
Mapping App Field with Lookup
Lookup service allow you to lookup values from external data sources.
This helps to arrive at value for the App Field by looking up one or more Form Fields into external data sources and get the result