Unsure of the best approach so I would love some suggestions on this;
Background & current process;
We book training sessions for clients. We currently create one Airtable record for each session to set different dates for them. Each session (record) immediately receives a confirmation email (triggered through Zapier) once we change the status to 'Confirmed'. Sessions are linked to a Company.
One issue with this is that clients often book multiple sessions at once, so upon confirming them in Airtable they will receive multiple confirmation emails that are almost identical (only the date/time changes). This spam-like approach isn't the customer experience we want to deliver.
Desired outcome;
For clients that book multiple sessions at once, I'd like to be able to send a single email that shows all the sessions as dot points so it's easy to understand and doesn't seem like spam.
I'm not sure of the best way to set this up with Airtable. We still want to keep the sessions as individual records as we have further automation (via Zapier) that sends a reminder email one week prior, and also one that generates an invoice per session.
How can I identify in Airtable how many, and which sessions should be noted in the confirmation email? Could I create a 'Booking Code' that is identical for each session, and tell Zapier that when that Booking Code has more than one record assigned to it, then send an email with each session noted as dot points? (Also unsure how to add as dot points in Zapier if the number of sessions is always changing). Can I group the records somehow (without creating a new table for linked records) so I can identify in Zapier that they should all be noted in the one email and not sent separately?
Any suggestions or ideas would be much appreciated!