Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Automation to notify status changes based on previous status

755 1
cancel
Showing results for 
Search instead for 
Did you mean: 
airballer86
7 - App Architect
7 - App Architect

I want to know when an approved campaign goes back in to revisions so that I can review it again. I have multiple other reasons to want to know when a campaign status changes and what the previous status was; e.g., trigger subtasks for team members, notify leadership etc.

I use the following statuses: planning, assigned, in progress, completed, approved, scheduled and launched.
and two nonsequential values (revisions, missing inputs) that can be used at any point in the process.

What I currently set up:
The status field is a single-select
An automation that captures every change in campaign status and populates another table
That status tracker table is linked to the campaigns table
The status tracker table has a 'status field' last modified date field

What I want is a way to compare the previous status field to the current status field so I can trigger actions based off of the new status. What I cannot figure out is how to connect the most previous status to the current status. 

Any help would be appreciated!

1 Reply 1
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hmm, I'm assuming your status logging table is set up something like this:

Screenshot 2024-06-26 at 9.56.07 AM.png

And this is how you'd like for it to work:
Screen Recording 2024-06-26 at 9.54.41 AM.gif

If so, try setting up your automation like this:

Screenshot 2024-06-26 at 9.56.30 AM.png

The "Find Record" action attempts to look for a status log linked to the triggering task that has an empty "End Status" field (i.e. a record we need to put an "End Status" value in)

The conditionals are:
1. If a record is found linked to this task that has an empty "End Status", and the current status value is "Done", update the "End Status" field
2. If a record is found linked to this task that has an empty "End Status", and the current status value is not "Done", update the "End Status" field and create a new record in "Status Logging" with the current status value as the "Start Status"
3. If no record is found, create a new record in "Status Logging" with the current status value as the "Start Status"

Link to base