Hello,
Newbie, here.
I’m working on an automation between ClickUp and Airtable. At a high level, I want to get a list of tasks from ClickUp. If the ClickUp TaskID is found in the Airtable “Clickup TaskID” column, I update the Airtable record. If not, I want to create a new Airtable record.
Sounds simple, right? I’m stuck on the 2nd part: If the ClickUp TaskID is not found in the Airtable “Clickup TaskID” column, create a new Airtable record.
My current scenario:
- ClickUp “List All Tasks” module gets all ClickUp tasks from a list.
- “Array aggregator” aggregates all tasks into an array.
- Airtable “Search Records” searches Airtable to find Airtable records based on the TaskID from the ClickUp array from Step 2. The formula I’m currently using is IF({ClickUp TaskID}=‘array.Task ID’,1,0)
- Router
- Filter 1 “If record exists”: Condition ‘array.Task ID’ = ‘Airtable.Clickup TaskID’ → Airtable “Update a Record” (Works)
- Filter 2 “If record does not exist”: Condition ‘array.Task ID’ != ‘Airtable.Clickup TaskID’ → Airtable “Create a Record” (Does not work)
I’m not sure which step is causing me issues. I’m not sure how to get the Clickup TaskIDs that are not in the Airtable (ones that should be evaluating as 0 in the search step 3)
Note: When I tried setting up the scenario w/o the “Array Aggregator,” I was able to create new Airtable records. However, it was creating multiple duplicate records as the search looped through each bundle. To solve that, I added the “Array Aggregator” which seems to be causing this issue.
Blueprint:
blueprint(2).json (135.3 KB)
