Hey AT peeps!
So the image shown is the multi select our attendees are going to select one or many. These represent real data in another “Training Calendar” base and table:
So the question is, how can I, possibly an automation, “attach” the actual event from this second pic/table, based on their entry/selection? since the field is a multi select, I’d need to be able to have multiple “events” attached.
I assume you’re using a multi-select field instead of a Link field for styling purposes? Could you just let attendees select from the Calendar records directly?
An Automation would be possible, but since the Select options don’t match the names of the Training Calendar records and users can select more than one option, the setup will be trickier than it otherwise could be.
If you edit your select options slightly to include their number (1, 2, 3…) and if your table of events had an Event Number field, you could use an Automation Find Records step that matches based on the Event number. This may be a formula field that extracts just the number part.
Trigger when new form responses. Find Records in the Training Calendar table where Event Number = Event Number from form submission.