We take bookings online for a fortnightly gardening session, and the attendees' details are then added/ updated in an Airtable list.
Before each fortnightly session, we currently manually send the list of who is signed up to the session leader which feels inefficient! I have setup the Airtable/ bookings so that the dates people signed-up to auto-populate, currently as a list since they may sign-up to multiple dates, eg "03-05-2023, 17-05-2023," etc. I'd love to find an automation which searches for today's date in this field and sends an email to the leader with the sign-up people but I can't see a way to do this. There is an automation option to Send an email when the date field matches 'Actual trigger time' but not sure how this is formatted/ if it would work.
Hope this makes sense and would welcome any suggestions!
thanks