Hi Folx! Here is my scenario:
I have an online event business and about ~100 contractors that are assigned events in custom software. All of the events are synced to table 1, and all the contractors are synced to table 2. The contractors are associated with their event(s) via a linked record field. All of this is done automatically and works like a charm.
I would like to send a summary each week of the list of events the contractor has worked. I need help writing an automation that will:
- look up records from view for the previous week
- create a list of the records associated with each unique email address
- send the list of records to only that email address
Where I am running into trouble is trying to have airtable send only the records associated with Contractor A directly to Contractor A. It seems like I could create a list of all records and send them to all contractors but that is not the desired outcome.
Thanks in advance for any help!