Valid_If for Drop Down based on previous Drop Down

Hi, I’m new to Appsheet.

I’m creating an app that tracks employees’ attendance.

Fields are
Location:
Employee:
Infraction:

There are multiple Locations and I want the Employee drop down list to be dependent on the Location drop down. The issue is that employees can be moved from one location to another. If I use a Valid_If for a Location column in a table with another Valid_If for an Employee column, then it will return only infractions from that specific Location.

I want to return Infractions from all locations for the Employee selected.

I hope I’m making sense.

Thanks in advance.

0 2 246
2 REPLIES 2

Do you have another table for location data? Then you set up ref connection between location field in attendance table, then it will generate the dropdown.

Steve
Participant V
Top Labels in this Space