I use airtable for project management and have a similar setup to this blog post - https://blog.airtable.com/automation-recipe-client-requests-emails/
I have a project that goes through multiple milestones and at each milestone, I want to trigger a notification email so it works like this -
Project 1:
- Milestone 1 (in-progress) > Milestone 1 (Client review) > Send client email
- Milestone 2 (in-progress) > Milestone 2 (Client review) > Send client email
- etc etc.
Like the blog post, I have a status dropdown that contains the following values:
- In-progress
- Client review
- Done
As the blog post says,
In our case, we want the trigger to fire when we mark a project as being ready for “Client review.”
I’m able to get the trigger to work on record X the first time, but I’m not able to get the automation to run for any subsequent time that the project goes into the “Client review” stage.
Is there something I’m doing wrong?
