Valid_If for Drop Down based on previous Drop Down

[Orion]

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.

[Koichi_Tsuji]

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]

help.appsheet.com

Dependent Dropdown

How to make a dropdown with choices that depend on the value selected in another dropdown.