Hi all, I’m using Airtable as a PM collecting feature requests from my stakeholders - I want to assign a status to those requests (i.e parked, exploring, on roadmap, completed, out of scope) and want to trigger an email when the status of their request has changed.
The trigger is fine but I only want the trigger the email when the status is changed the second time since i have a separate trigger for the first change sending a ‘feedback’ field in the email while the status trigger is just to inform them of a change to their request.
My idea was to create a column with a formula that counts the number of modifications to a specific field (in this case status field) and set the trigger to fire when {count of modifications} > 1 so that it will fire if updated in the future everytime the status field is modified. Curious to see if this is possible. Thanks!