Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 13, 2024 11:40 AM
Hello
We have 2 phases of work:
I'm looking for a way to automate the change of the sub-status field from NEW to CORRECTIONS.
My thought is to have a field called "FIRST PAGES COMPLETE?" and an automation runs to fill that field with "yes" when the conditions are met. Then, if field = "yes" change sub-status accordingly.
I'm having trouble figuring out how to track the proper conditions because I'm looking to track a change between very specific options in the "Status" field. Not just when the record is updated in general.
I need the automation to look at the "Status" field and analyze when it changes from "In Progress - Design" to either "In Progress - Marketing" or "with Client"
Best way to do that?
Aug 13, 2024 11:52 AM
To automate the change from "NEW" to "CORRECTIONS," create an automation that triggers when the "Status" field changes from "In Progress - Design" to either "In Progress - Marketing" or "With Client," updates a "First Pages Complete?" field to "yes," and then another automation that updates the "Job Sub-Status" to "CORRECTIONS" when "First Pages Complete?" equals "yes."
Aug 13, 2024 12:02 PM
Yes, that's what I'm trying to do, but can not figure out how to get the automation to check the Status field for those specific instances of "In Progress - Design" etc. Can you show me where that is in the automations?
Aug 13, 2024 01:13 PM
1: Create a New Automation: Go to the Automations tab in your Airtable base, Click on Create a new automation.
2: Set the Trigger: Trigger Event: Choose "When record matches conditions".
Table: Select the table where your "Status" field is located.
Conditions: Set the condition to check if the "Status" field "is exactly" one of the values you're looking for, e.g., "In Progress - Marketing" or "With Client".
3: Add a Condition to Check Previous Status (Optional)
To specifically check if the "Status" changed from "In Progress - Design" to one of these new statuses, you might need to create a new formula field in your table that captures the previous status using Airtable's scripting block or an additional hidden field to store the previous value.
You can then modify the condition in the trigger to check both the current and previous status.
4: Add the Action: Action Event: Select "Update record".
Table: Choose the same table.
Record ID: Use the Record ID from the trigger step.
Field to Update: Choose the "Job sub-status" field and set it to "CORRECTIONS".
5: Test and Activate: Click on Test to see if the automation works correctly.
Once confirmed, click on Turn on to activate the automation.
Aug 14, 2024 07:07 AM
Thanks for that run-down. I was starting with the wrong trigger.
Hmm... This makes me realize I need to think this through a bit further, given some other things that need to be considered.
This has been very helpful! Thank you.