Hi, I’m new to Appsheet.
I’m creating an app that tracks employees’ attendance.
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.