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
Explanatory Video
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.
