Appsheet Valid If

AppSheet AppSheet Q&A
1

I’m developing an application for a charity helping children who need surgery in Appsheet to keep APPOINTMENTS.

I have a table for Contacts in Google Sheets which include patients, doctors, hospitals, etc with fields like, name, phones, email, etc each record with a key. I put them all in one table as I keep the same fields for all patients, doctors and hospitals.

I have another table with appointments where I record date, patient, hospital, doctor, notes etc.

How do I use the valid if in Appsheet so that in the appointment form, I can pull up enum lists for patient, hospital and doctor?

Thanks in advance for your help.

2

You could make each of those columns a Ref type (or an Enum type with a base type of Ref) and then enter a Valid if expression to return a list of names pertinent to the column–e.g.:

FILTER("Contacts", [Type] = "Patient")
2 Likes