HI Team,

I'm trying to configure conditional lookup using Zoho creator.

Example:

Form 1: Add Sponsor

Form 2: Add Products (text field) by selecting the sponsor (lookup field from Form 1)

Form 3: Add Details

                  Select Sponsor (lookup field from Form 1)

                  Select Product (lookup field from Form 2)

Here when i select Sponsor A, all products related sponsor A should be listed in Product Drop down and similarly when i select Sponsor B, all products related to sponsor B.

As per the help link  https://www.zoho.com/creator/help/fields/configuring-conditional-drop-downs.html#Create_Dynamic_Lookup

 I tried to set the filter for Product dropdown in Form 3, the filter is not getting saved.

 ID Equals input.sponsor Name.

Could anyone help me in creating the Filter so that i see only the products related to the selected Sponsor