Lookup - Mapping Type

What is Lookup Field?

Lookup Field allows you lookup value from external sources

for example, Google Sheets, user can lookup values from sheet data based on user entry

Following are external sources

  • Google Sheets

Lookup from Google Sheets

  • Map the App Fields with the Google Sheets Lookup value
  • Choose mapping type as Lookup
  • select external source as Google Sheet from Lookup from drop-down.
  • You can choose and view the selected Google sheet
  • Select the tab you want to lookup
  • you can refresh/reload the by clicking refresh button.
  • Select the range type
    • full - full sheet data
    • range - enter range of sheet data
  • If include header is selected it will show headers as your sheet have
  • if include header not selected it will show header as A,B,C etc

How to configure the sheet having headers

  • check/select the include header switch.
  • this will list header from your sheets
  • Add lookup condition mapping.
  • Mapping consist of Form Field, Lookup Field, Result Field and Default field.
  • Form Field is Form Fields value
  • Lookup Field is value from selected sheet lookup column.
  • If all lookup condition satisfy then Result Field value is lookup from the sheet.
  • if non of condition satisfy it will look default value. ex: NA will be return when non of the condition satisfy
  • You can test the lookup by proving sample input

How to configure the sheet not having headers

  • deselect the include header switch.
  • this will list Column header from your sheets ex: A,B,C etc
  • Add lookup condition mapping.
  • Mapping consist of Form Field, Lookup Field, Result Field and Default field.
  • Form Field is Form Fields value
  • Lookup Field is value from selected sheet lookup column.
  • If all lookup condition satisfy then Result Field value is lookup from the sheet.
  • if non of condition satisfy it will look default value. ex: NA will be return when non of the condition satisfy
  • You can test the lookup by proving sample input

Check lookup

  • Click on Check Lookup button
  • Will see selected Form Field and Lookup Field appear below
  • Enter the sample data and
  • Click on Check Now and immediately you can see the correspond result

Sample lookup test case having headers

  • In the above configuration. I have mapped two lookup fields i.e Id and Name and Address as lookup result fields
  • if any record satisfy this lookup condition it will return lookup result value.
  • Example: I have enter Lookup values Id as 101 and and Name as Mithun
  • This lookup condition is satisfied so it will return the lookup result field i.e Address is UK
  • If condition not satisfy then default value will be assigned i.e NA.

Sample lookup test case not having headers

  • In the above configuration. I have mapped two lookup fields i.e Column A and Column C and Column B as lookup result fields
  • if any record satisfy this lookup condition it will return lookup result value.
  • Example: I have enter Lookup values A as 101 and and C as Mithun
  • If this lookup condition is satisfied then it will return the lookup result field i.e D column value UK
  • If condition not satisfy then default value will be assigned.