Hi folks, trying to complete a simple route from clickup to sheets but custom fields arent pulling up for some reason.
Here is a video: Clickup custom field not showing in google sheet output?
And attached screenshots of input/output:
Follow-up: The end goal is to create a health score sheet broken down by a client’s total tasks in various stages (see screenshot).
Im considering handling the calculations in Sheets, and keen to know how to run this in an operations-efficient way inside make (e.g: maybe to not list the same task ID multiple times under different statuses but update existing ones?)
But regardless of the design, it has to obviously not break week on week.
Still learning Make ropes as you can see, so any advice is greatly appreciated.
Hi team just wondering if any advice?
Hi @Kareem_Mostafa,
Welcome to the Make Community!
Apparently, the Clickup Custom Fields are in an Array. It means that you have to make a more complex mapping, using functions.
You need to mix map and get functions, but since the name of customer is also in an array, it could be complex to build.
So, coud you please send a sample output of the Clickup module result (the JSON document), so that I have a look?
Besides, I noticed, in your video, that there are 2 customer names, one with orderindex=1 and one with orderindex=2; which one do you want to pick?
Best regards,
Benjamin
1 Like