Email me the list of ‘tasks’ for each new record added
So when I ran the 1st automation it ran flawlessly! It was #2 that boogered me all up! It sent 10 emails for each new record… each with all 10 tasks listed beautifully!
The issue I am running into is that the 1st automation is running from where the new record lives. I found that if I add the ‘send email’ option with the same trigger, it emails an empty list (I’m guessing because it is sending the email before the list is populated).
I’m sure this is an easy one, but Its been a loooong week already.
Hi DG. Without seeing your 2nd automation, it’s difficult to give accurate help. However, have you tried putting everything in one automation?
After you create your 10 tasks in the task table, add an action to “find” those tasks based on the record id of the record that kicked off the automation. I’m assuming that you have linked the tables (i.e. the 10 new tasks have a link field to the new record in the 1st table).
The next action would be to send the email and include the results from the find action in the body of the email. Does this suggestion make sense? The only downside I see is that Airtable doesn’t work the way I expect.
Hey augmented, thanks for the info! I think I see where you are going with this.
Let me try and lay out the process for you with pics:
It starts with the 1st Automation: Create New Cust Task List. This occurs when “A Record is created in ‘1. Customers’ table”.
(you can see the “REQUIRED” and “OPTIONAL” tasks being created above)
… and then goes on to 1b-Find Records (tasks) and Send Email
So to your suggestion, I began attempting to add another “conditional action”, send email, to this step. I set the “Airtable ID’s” to match “DYNAMICALLY”. But I’m getting stuck with the “Action” that I would take next.
Because, how would I know that it won’t fire before all of the ‘tasks’ have been populated?!?