Good day all. I have some records where an attendee fills out a form and selects multiple events.
This form populates several things:
- Calendar Table(which also generates GCal events)
- Junction Table
- Attendee's table with all the courses(Array)
I want to have another table that is a 1-1 of data, in this case, I'm thinking, Attendee - Course
I'm sure it will have to be an automation that extracts from an array, and creates a single record PER course per Attendee:
email@example.com - Fun with ABC 051223 9am
firstname.lastname@example.org - Z is the Letter 052023 10am
etc, etc. I will then have it linked to actual records - Calendar, etc to draw data from them, as well as if needed data from this table.
However, I'm first looking at the automation to first extract the said data and add to a new table, my 1-1 table.
something like above. First field being the email of the attendee(s),etc