![]() If you want to try it yourself, here's the code in a copyable format: I don't intend to explain the code in detail - but it is pretty generic and will convert any comma separated list (as you get from an Airtable field of this sort) into an Array of Objects. Here's how it's done in Zapier (using Javascript): What happens when you do this is that Zapier will perform any subsequent step for each Object… In the previous Blog post I wrote about sending reminders from Airtable, we discussed how Zapier doesn't appear to be able to loop through things (like a list of Checklist Items) - but that it is possible to get Zapier to do this by using some code to turn the list into an Array of Objects. On screen, this looks as though it contains the names of the items - however in Zapier we get a list of the Checklist Items' IDs - which is much more useful. One of the fields returned by this step is going to contain a comma separated list of the Checklist Items associated with the Checklist (from the Project's field. Now let's look at how Zapier takes this and generates the tasks automatically…įirstly, the Zap is going to be triggered by a New Record in the Project table - as you can see above. ![]() If you enter a value in the Brief description field rather than the Checklist Item, then the Task field (Name field) will show the description rather than the Checklist item - the formula is: I've implemented this table so that manually entered tasks can also be input (not from checklist items. Here we see the Tasks table containing 4 tasks (which were generated by Zapier from the Checklist). 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 |