Mapping

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.


Terminology:

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
  • 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
    1. Predefined
    2. 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