Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi there, 

I have a workflow that takes metadata from tasks in clickup and adds this to a Google Sheet, this work perfectly except for one thing and that is the custom fields. In the Sheet there is a header called “Type” which is where it should display what type of work has been done (Webdev, Advertising, Report, etc..) this is chosen in ClickUp with a custom field(labels) where whoever creates the task selects the appropriate type. 

The issue is that I would of course like it to only insert the type that has been selected in the ClickUp task, i.e. Type: Webdev

However right now instead of pulling only the “active/chosen” type it simply outputs all of them, i.e, 
Type: Webdev, Advertisin, Report. This is even though it is only Webdev that is chosen in the ClickUp task. 

Is there a way to ensure that only the actively chosen label gets pulled?

Hi @AproposBureau 

Can you please share screenshots of how the data is returned in your trigger step? 

Is there any indication for which “Type” was selected? 

Hi @GetUWired 

Yes of course, there does not seem to be any indication of which “Type” was selected, merely the option to get information on what the different options are. Unless i am not seeing something: 

 

Data IN
Data Out
Options within Zap. 



 

@AproposBureau 

You need to look for a field that has “value” in the title. Please see below, you will notice the value returned is the id of the option selected from your field so you may need to implement a lookup table in Zapier or a formula in Google Sheet. https://zapier.com/help/create/format/create-lookup-tables-in-zaps 


*ADVANCED*
If you decide to go the Google Sheets formula way instead of the look up table you can use a switch statement similar to below where you dynamically place the value and then provide options to match against. As you can see, Google will output the result that matches (in my case option 2). https://support.google.com/docs/answer/7013690?hl=en 

 

@GetUWired 

That works perfectly thank you! :D

Terms & Conditions