Data validation and lookup

Sales_Shantikru · 11-21-2021 03:01 AM

I m creating an app for shop floor maintenance activity.

a new complaint is to be raised, by submitting form.

During form submission, I need 2 dropdown list of names 1. Complaint raised 2. Responsible person.

I Created separate table for data validation
Tried with validif function but it allots second name by default which is in the row of first name. I need two independent dropdowns

Also, after names, I have email and phone, which I want to be fetched automatically once name is chosen from dropdown. This is simply not happening with lookup().

Lookup ((complaint raiser), “validif_ref”, “complaintraiser”, “Email”)

Thank you in advance
Regards,
Sarang

shahappsheet

Some screenshots may be helpful to understand more precisely. By the way, Is “validif_ref” name of a table?

Line 5. … it allots second name by default.… Couldn’t understand this statement.

Dependent and Independent Dropdown expression is completely different. If any object is coded as a dependent, it shouldn’t be converted to independent dropdown automatically, and vice versa. So far I know. So, need to recheck the expression codes.

Sales_Shantikru

Resolved
I started with fresh Google sheet.
Probably there was something wrong with sheet only

Steve

Read the help doc.

Sales_Shantikru

Steve
I entered
Lookup((complaint raiser),"validif_ref ","Email id ",“Email Id”)
Formula is accepted
But it is fetching default 1st row values from validif_ref table irrespective of the dropdown " complaint raiser " value chosen

Steve

Read. The. Doc.