Possible way of setting up:linked records DRAWING info from multi select field

[Sean_Lake1]

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.
Ideas?

[Kamille_Parks]

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.

[Sean_Lake1]

I guess I could have that option being fed from the events, but the naming isn’t as pretty as the data is stored in a specific way, however it could be an option.

The form was setup for quickness without any linked data.

Thanks.

Sean

[Sean_Lake1]

Also noted. I thought there could be an “equal” table where:
Multi select #1 = Event Date #1
Multi select #2 = Event Date #2
Etc

[Kamille_Parks]

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.

[Sean_Lake1]

Aha! That’s sort of what I was thinking, but wasn’t sure how to approach it. I’ll definitely try that :).
Thanks!

[Sean_Lake1]

Solution formula to extract event auto number:
REPLACE({Which Session(s) did you attend: (Check all that apply)},0,SEARCH(“#”,{Which Session(s)})+1,“”)