As mentioned in Method 1 above, this will allow us to use other Airtable features to effectively track and manage projects more effectively. Now our "Projects" table and "Tasks" table are linked together, as well as our "Tasks" and "Subtasks" tables. Next, we want to daisy chain these tables together using linked records. This method begins with creating a "Projects" table, a "Tasks" table, and a "Subtasks" table. Here is a short gif showing the result when everything is set up correctly: Keep in mind that you'll want to adjust "Subtasks," the name of the subtasks field in the example from above, to be the name of your base's subtasks field. You will need to set up three different formula fields for this use case. It's essential to know how to troubleshoot formulas and use our formula field reference when attempting this setup. The formulas used in this example may or may not work with your base's design since formulas can break down for various reasons. Tracking is possible for Method 1 as well but requires a bit more of an intensive setup. Looking to track subtasks using this method's base design? In this step, we add a linked record field and add in the corresponding projects related to each task. This will allow you to employ many powerful Airtable features such as the use of lookup, rollup, and count fields as well as Automations. Now we can create a linked record field that allows up to create a connection between the tasks/subtasks table and the "Projects" table. It may also help to adjust the row height so that you are able to see all of the subtasks without having to expand the record. This will allow you to create a checkbox for each individual subtask by using brackets followed by a descriptive title for each subtask. In the newly renamed "Subtasks" field make sure that rich text formatting is enabled. This method begins with creating a "Projects" table, a "Tasks" table, and renaming the default long-text field as "Subtasks". This method is helpful when you need more granularity and the ability to easily track subtasks as well, since it allows you more reporting options by using linked records, rollups, etc.Įach of these methods requires a prerequisite understanding of linked records, but we will cover some of the basic tenets of linked records in both methods. Method 2: Subtasks in another table - Creating a "Subtasks" table that links to a "Tasks" table that links to a "Projects" table.This method is helpful when you want an easy and convenient way of seeing subtasks within the same view of the overall task record. Method 1: Subtasks in a long text field - Setting up a "Tasks" table that links to a "Projects" table and using a long text field to create a list of subtasks.Base designĭepending on your workflow's individual needs there are two different base designs that we recommended considering: In this article, we will discuss two ways in which this can be accomplished as well as a simple way to automatically track your work using a formula. It's important to think about how to set up your base to maximize Airtable's functionality. Often times you may need to create subtasks within Airtable to help keep you and your team on track for completing projects.
0 Comments
Leave a Reply. |