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 in the App. 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:

  • 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

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 Form Field

  • Map the App Fields with the corresponding Form Fields.

Intelligent Mapping

  • Intelligent mapping allows users to automatically map matching Form Fields with App Fields.
  • It can be done by clicking the arrow button that is highlighted.

Additional Settings for "File Upload" type form field

1. Settings for Google Docs

You can embed image file into Google Docs from File upload option in form field.

  • Check Insert as Image checkbox if image needs to be uploaded.
  • Select the required Height and Width required.

2. Settings for Google Slide

You can embed image file into Google Slides from File upload option in form field.

  • Check Insert as Image checkbox if image needs to be uploaded.
  • Select Fit Content or Custom Size whatever required.
  • If Custom Size is selected, enter the required Height and Width required.

Note: Only image files (jpeg, gif, png etc) are supported to be inserted as image

Additional Settings for Date type form field


You can select the required date/time format and timezone in Date type form field.

  • Select the required date/time format as required.
  • Select the required timezone.

(Note: Timezone field is an auto complete feature, you can select the timezone as required)

  • Save the mapping and submit the form.


Mapping for Multi Choice Grid & Check Box Grid

Multiple Choice Grid and Checkbox Grids are supported in Form Director mapping. This section explains the details on how to do that mapping.


  • Configure a multiple choice & check box grid inside the form.



  • Configure a document template with form Grid fields in following format.
  • ${Favourite fruits [Arun]}
  • Note that the Field Name is of format ${Grid field name[Name of the row]}


Tip: Try creating template of Google Docs/ Slides using Form Director from your form having Grid. The template will be automatically created with the fields in correct format for the Grid.



  • Map app fields to the corresponding form Fields.
  • Save the mapping and submit the form.


Note: Intelligent mapping identifies the fields and map them automatically if you follow the format of ${Grid field name[Name of the row]}

Mapping App Field with Templated Field

  • Templated Field allows you to have multiple Questions of a Google Form consolidated to a single Application field, In other words an App Field can have responses of multiple questions in that form.

Learn more about Templated Field

Mapping App Field With Calculated Field

  • Now you can calculate app fields from your form fields by using 'Calculated fields' feature.
  • Types of Calculated fields
  1. Predefined
  2. Expression


Learn more about Calculated Fields

Mapping App Field with Service Result

  • Service Chaining allows you to send the previous service result to the next service.


Learn more about Service Result