3/28/2024 0 Comments Airtable jira zapier(with a pipe separator) and in Todoist it looks like this: So, in my prototype, when I create the task in Todoist, I’m mapping the person’s name and the AT record ID to the task name - something like this: However, the principle should be the same, you just set it up on different fields. Hi - I managed to get this to work, albeit in a slightly different way to you as I don’t have a paid Todoist account and so don’t have access to task “notes”. I’m struggling to figure out how I can create a zap that finds the correct record so it can update the appropriate field I’ve tried passing the recordID to Todoist via the first zap (it’s currently stored in the Notes field in Todoist), but can’t figure out how to use that to query Airtable for the second zap.Īpologies if this isn’t clear - I’m new to both Airtable and Zapier and am trying to dive in. When the task is completed in Todoist, I want Zapier to update the ‘last contacted’ field for the correct record in Airtable to today’s date. If it is, the record is marked ‘Overdue’ there’s a view of all people in the base that filters to show only those records marked ‘overdue’.Įvery time a new record hits the ‘overdue’ view, Zapier creates a new task in Todoist to contact that person, along with their contact info. A formula calculates whether today is >= last contacted date + frequency days (+90, +180, +365). Here’s the general idea:Īirtable base: each record has a contact frequency (quarterly, semi-annually, annually, or none) and a ‘last contacted’ date. Hi - I’ve successfully created a Zap tied to a CRM base in Airtable.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |