![]() ![]() Since the first conditional action group is already configured we can quickly duplicate it and adjust the values in order to update each of the last four status date fields. To timestamp each of the status date fields, we'll need to have one unique conditional group per status date field.Finally, click the cogwheel so that the value can be filled dynamically with whatever the current value of the "Last modified time" field is showing. 3 Next, under Fields you'll click the + Choose field option and select the "Planned" date field. Click the blue plus sign button to insert that value from the token picker. 1 Next, choose the same table from the trigger step, which in our use case is called "Content production." 2 Then, you'll want to set the Record ID to be the same record from the trigger step. First, choose the Update record option from the list of actions. Now, we want to set up the action so that the record will be automatically timestamped with the current value from the "Last modified time" field we set up earlier.This first group will be set up to only run the action we set next when the "Status" field is set to the "Planned" status option. This will open up a menu to configure the first conditional group.First, skip the Actions section and click the plus sign next to Conditional Actions.Follow the steps below to create the entire automation. We'll create a single automation with five conditional groups that will map to each of the status date fields we created in the last section. Now that the required fields have been configured we can start building an automation. In most cases, this formula can be hidden in the view as its purpose is only to be referenced by the automation. Remember that the time-based formula you are creating here will update over time. In this case, you'd set it to only trigger the timestamp to be made when the status is changed to "Live." One major difference is that you'll likely want to use the "When record matches conditions" trigger in the automation. You'll still need to create an automation that is similar to the steps in the next section. ![]() So we can build out a formula field that only returns the date when the Status field is set as "Live". If you are looking to just track updates in certain fields for certain values, then building out a formula using the LAST_MODIFIED_TIME() function (or TODAY() or NOW()) alongside conditional IF() statements will likely be a better choice than using a Last modified time field.įor example, you might want to be notified whenever content goes live. It's a good idea to duplicate the original base and practice building in the copy to make sure everything looks correct before applying the concepts to the original base. You might need to modify the base that you are working in.Remember, you might use different values in later sections on formulas and automations. In the base that you are looking to apply these concepts, you'll likely use different names.Focusing on new blog content, each new article can move through five different stages: The end result is valuable data that can provide insights into their internal processes. We'll use a scenario where a content marketing team wants to track how long blog articles in their development queue spend in each stage of their process. C onditional automations - Conditional automations help us to simplify the number of automations needed to accomplish the workflow outlined in this article.Update record action - More information on the main automation action being used in this article.When record matches conditions trigger - For further reading on this type of automation trigger.Calculating the difference between dates - Read this if you get stuck building out formulas working with datetime differences.Owners/ Creators - Because the steps below involve creating new fields and automations, Creator permissions are required in order to perform these actions.This would otherwise not be possible without leveraging a custom API call or a third-party tool like Zapier. Automations are helpful in this scenario because they can be used to input a static date and time into a date field based on when the status field changes. This can be helpful for teams who need to stay on top of how long a record stays in each stage of a process. Learn how to use Airtable Automations to track the amount of time a record maintains a specific status. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |