I’ve got a scenario that watches tasks i ClickUp and posts a report into Slack and Googe Sheets.
Problem is 3 different fields in clickup that are either tags or dropdowns. They output ID’s instead of text (e.g.
be7a9c50-dfba-4f8d-ac8c-c3051f90d319 instead of
I’ve kind of fixed the problem by using Tools Switch to map what ID’s mean in clear text but it’s very complex and doesnt seem to work when a task has multiple tags.
This is how one of the tag looks like when mapping it in the Google Sheets export.
Is this simply because the ClickUp module is not made correctly for tags and dropdowns or is it me missing something?
Thanks in advance!
For anyone else looking:
Found this document about collections and arrays and I think the solution is there if I can just understand it
About the issue of just getting 1 of several tags I think I found the problem but not a clear solution.
There’s only two suggestions here:
- Leaving empty defaults to first element
- Putting a number e.g.
2 gets the second element
- No explanation about how to get ALL elements
You’ll need to manage the content of the tag array and check it’s length. If length is more than 1 then you’ll need to iterate over the array doing the in place switching. Break down the task into multiple modules if you want with the tools.
The iterator tool is your friend.
I tried the iterator and aggregator but couldn’t make it work right.
Ended up going with this solution:
In this example I had 3 attachments and it ended up looking like this in Google Sheets:
It solves my problem in that my partner can download all attachments from the excelsheet however I’m not super happy about the solution because of:
- Couldnt use =HYPERLINK to make them pretty links
- If 0 attachments the rows still get 4 newlines tall