Lookup - Mapping Type

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

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

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

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

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.

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.