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

  • 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

    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


Mapping App Field with Conditional

  • This helps to arrive at value based on condition set.