![]() ![]() 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. Use the “when record meets conditions” trigger to differentiate between the two.Learn how to use Airtable Automations to track the amount of time a record maintains a specific status. The other automation would leave out the second set for the first stage, as there would be no previous stage. One automation would perform the steps outlined above. Without scripting, you would need to have two different automations. However, this is also possible to create without scripting. I usually build automations like this with scripting, so I can do different things if there are missing inputs. Update the project record’s “last status record” to the newly created record, so that it will be ready for the next status change. ![]() Get the previous linked status record from the project and set it’s “next status” linked record field to the newly created status record.Create a new status record, linking it to the project and setting the status to the project’s status.So the project table needs a new linked record field that will be managed by the automation. To manage the linked records with the automation, you need to keep track of the record for the most recent stage. Finally, use DATETIME_DIFF in a formula field to calculate the duration of the stage. Then use a lookup field to of the next stage’s start date/time as the current record’s end date/time. The new linked record field would link to the next stage (when there is one). You can add a new linked record field to the table of status changes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |