With all this information, we are now in a position where Airtable has all the information it needs to generate a task and assign it to a project and collaborator. The ItemID field will be used later to enable Zapier to search for this record so that we can get other information from it. This table contains a Name field, who to assign the task to (a Collaborator field), a number of days after today that the task is due and which Checklist it forms a part of. Generally I prefer to create these links in the Many (or child) side of a one to many relationship. This table simply contains a Name field and then shows which Checklist Items are linked to it and also which Projects. This is all quite straightforward - with the only unusual item being the lookup field called Checklist Items - this is a field from the Checklist table listing the items which the checklist will generate. When a new project is created we are going to enter a checklist (from a lookup table) and Zapier will then create the tasks from the entered checklist. In this example, we're going to work on the basis of a project app. In order to copy this you will need an Airtable account and a Paid Zapier account (all the features required are not available in a Free account). So, in this Article, we are going to go through the process of automatically creating task lists in Airtable - with the automation handled through Zapier. Checklists are a common requirement within many business applications - from Project Management to HR, etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |