Automatic Mapping

What is Automatic Mapping?

Automatic Mapping is feature of Form Builder which identifies the data from input automatically and maps with appropriate fields like question, description, type, etc.

  • Automatic mapping is applicable only for Google Sheets data.
  • Automatic mapping is applied by checking whether the sheet data have meaning full headers/keywords. If so, Form Builder automatically populates the column in configuration.

How Automatic Mapping works?

Form Builder looks for keywords in header. Example: description, if the sheet data headers have description keyword, Form Builder will automatically detect and select the description column from configuration.

Note: This feature is only applicable for Google Sheets data with headers.

To use Automatic Mapping follow the below steps .

  • Select the Range Include header, this will automatically map matched header to column configuration.
  • You can also click the following icon whenever you want automatic mapping when you change your sheet data.

Please check out the keywords that Form Builder looks for the below.

  • keywords are case insensitive - so it will match with any case
  • keywords can be there in any part of the field

So if you have these keywords in your header, the corresponding property from the table below is identified automatically.

Properties

Keywords

Question

  • question
  • field
  • item

Description

  • desc
  • description
  • detail

Required

  • required

Type

  • type

Answer Start

  • answer start
  • option start

Answer End

  • answer end
  • option end

Other

  • other

Points

  • point
  • mark
  • score

Correct Answer

  • correct answer
  • right answer

Correct Feedback

  • correct feedback
  • correct answer feedback
  • correct feedback
  • correct answer feedback

Incorrect Feedback

  • incorrect feedback
  • incorrect answer feedback
  • wrong feedback
  • wrong answer feedback

Correct URL

  • correct url
  • right url

Incorrect URL

  • incorrect url
  • wrong url

Sample Sheet data