Enumlist Date Range Filter Validif Issue

AppSheet AppSheet Q&A
1

Can anyone help with this? I have a table of Events and a table of Attendees. The attendees can view and select events they wish to attend through an enumlist column in the attendees table (EventsList). This is used to populate a column in the Events table listing all attendees attending (AttendeesList) used for event planning.

The issue is that events are frequent and attendees will regularly update their respective EventsList column, so I want to filter that to only show upcoming events. I tried by filtering the enumlist validif expression but of course, events selected in the past caused an invalid response. Grateful for any suggestions.

2

Hi @Mason ,
I feel as the number of events increases it becomes cumbersome to manage. I prefer the user to click a button in front of the event & add an entry in the registrations table with attendee ID & event ID.
Any challenge in this approach?

3

Hi Yathesh. Thanks for the suggestion. I tested your approach and it works very well. I was concerned about the I user interface but I tried a deck view on a slice which works very well in my case, with interchangeable actions to register / unregister. Thank you for your solution.

4

I’m glad it helped. Have a great time!