I am trying to build a zap that will trigger a certain number of days after an even happens
In Airtable:
I change a column for a record from "Scheduled Consult" to "Evaluating proposal"
7 days after this happens IF the status is still "Evaluating Proposal" an email triggers as a follow up
I thought I had it set up correctly but its not running - any ideas?
Best answer by BlakeBailey
To do that, simply go to your Kanban view, click on the far left icon that current shows the name of your current view, then click on 'Grid' (any would work but this is the easiest for this example).
Then, in this new view, add a filter by clicking the filter icon and then say 'Where status is (or contains) Evaluating Proposal.
Now, you can leave this view alone, as it will only contain records with Evaluating Proposal set as the status. When a record changes from something different over to Evaluating Proposal, it will enter this view and then trigger your Zap.
Here's some more info on Airtable views: https://support.airtable.com/hc/en-us/articles/360021501754-Getting-started-customizing-your-first-view
+1That should work just fine! This is how that should be set-up:
In Airtable, create a 'Saved View' for records that are in 'Evaluating Proposal'.
In Zapier, the trigger will be Airtable's 'New Record in View' trigger, specifying the view you just created.
Next, include a delay by Zapier step, delaying for 7 days.
Next, do a 'Find Record' using the Airtable action, and specify the same record as a lookup.
Now include a filter that checks to see if the value for that record is 'Evaluating Proposal'. If it is, it will continue.
Finally, the last step will be to send an email using whichever service you prefer.
Hope this helps!
Thank you BlakeBailey, can you explain more about "create a new saved view" I am using Kanban view to "move" the records from one stage to the next, I developed it all in "grad view" then switched to Kanban view so the "stage" is one of the options for each record and there are different options:
Consult Scheduled
Evaluating Proposal
Invoice Sent
Invoice Paid
Etc
etc
So why would I need a new view?
+1To do that, simply go to your Kanban view, click on the far left icon that current shows the name of your current view, then click on 'Grid' (any would work but this is the easiest for this example).
Then, in this new view, add a filter by clicking the filter icon and then say 'Where status is (or contains) Evaluating Proposal.
Now, you can leave this view alone, as it will only contain records with Evaluating Proposal set as the status. When a record changes from something different over to Evaluating Proposal, it will enter this view and then trigger your Zap.
Here's some more info on Airtable views: https://support.airtable.com/hc/en-us/articles/360021501754-Getting-started-customizing-your-first-view
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
