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.
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |