Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 05, 2022 03:16 PM
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?
Jul 05, 2022 04:32 PM
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.
Jul 06, 2022 06:45 AM
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
Jul 06, 2022 06:47 AM
Also noted. I thought there could be an “equal” table where:
Multi select #1 = Event Date #1
Multi select #2 = Event Date #2
Etc
Jul 06, 2022 08:43 AM
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.
Jul 06, 2022 09:32 AM
Aha! That’s sort of what I was thinking, but wasn’t sure how to approach it. I’ll definitely try that :).
Thanks!
Jul 08, 2022 02:03 PM
Solution formula to extract event auto number:
REPLACE({Which Session(s) did you attend: (Check all that apply)},0,SEARCH(“#”,{Which Session(s)})+1,“”)