I have a base with two tables. The first has a list of events, and the second is an RSVP form for attendees to sign up to these events. The events are constantly happening and changing, and I’d like to show the events as a multiselect in the RSVP form (which linked fields don’t let you do).
Can someone write a script that would pull the event names from a specific view in table 1, and then update the multiselect field options in table 2 to show those exact event names? The field options would be replaced completely each time it runs, which I expect to be daily.