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.

  • Home
  • Get Help
  • How Do I
  • How to Set a Dropdown Field Value When Trigger Data is Text (Assign ZenDesk Custom Field Dropdown to Google Sheet Cell Value)

Hello! Thanks in advance for your help.

 

I have a column in a Google Sheet that contains a text value. When a zap is triggered, I want the text value in that column to be assigned to a custom field on a ZenDesk Support ticket. The problem is that the ZD custom ticket field is a Dropdown list (and the field type cannot be changed).

Let’s say the ZD custom ticket field dropwon offers these choices:

Apples
Bananas
Cherries

My Google sheet column contains the same values.

The ZD fields can be set to have the options in different orders, so I suspect that there is an internal value of some sort.

How do I set the ZD field with my Google Sheets value?

 

Thanks!

Alan

 

Hello! Quick question to get you on your way here. 

When you go to create the value in Zendesk - Do you see the drop-down values?

Can you share a screenshot of what you do see please?

Hey, Andy. Thanks! Here is the dropdown:

 

 

FYI, I have tried passing the text and an array index number and end up with this in testing:

 

jira_status_360038706952 null

 

Thanks!

And can you show me what you see in Zapier please?

Hey, Andy. Here you go:

 

 

Thanks!

Hello! Sorry for the back and forth - I’m not explaining myself very well. 

What I would like to see is: 

  1. A screenshot of your Google sheet
  2. A screenshot of the whole zap configuration (entire card) 
  3. And please show me what is in Jira status and not the custom tab

     

Hey, Andy. Thanks for sticking with me! Your questions lead me to my answer!

When I viewed Jira Status, I saw what turns out to be the internal ZD value. I did a test and passing triage_ for Triage worked! 

So I just will endeavor to use a Formatter step to map those values to the spreadsheet values.

Thanks so much for your assistance. Have a great day!

 

 

Haha! I thought they might :wink:

Glad to be of help 

Terms & Conditions