I need to cross reference entries between tables using Ref data type, as it allows me to relate the records between the tables and group them.
What I need to do, but unable, is filter which records are to be presented. I have the following scenario, and two questions:
I have a booking form [StartDateTime, EndDateTime, User, Resource]. The user field cross-references a user list [ User table with id (key), First Name, Last Name, Nickname, isActive] via a dropdown selection and x-ref using ‘ref’ data type
the user list has some non-active members [isActive = N]. How do I filter the available options in the dropdown menu to only active members [isActive = Y]?
When I view the user ‘card’ I have a list of all bookings in the system under each name, appended to that user. How do I filter them to only show future bookings [StartDateTime] > NOW().
I looked at some examples on here but it isn’t clear to me, such as:
Ref List Filter (appsheet.com)
any advice greatly appreciated. thanks