Skip to main content
Best answer

How to Set a Dropdown Field Value When Trigger Data is Text (Assign ZenDesk Custom Field Dropdown to Google Sheet Cell Value)

  • November 21, 2020
  • 8 replies
  • 1041 views

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

 

Best answer by AlanAdlerBest answer by AlanAdler

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!

 

 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

8 replies

andywingrave
Forum|alt.badge.img+9
  • Zapier Expert
  • 854 replies
  • November 22, 2020

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?


  • Author
  • Beginner
  • 4 replies
  • November 22, 2020

Hey, Andy. Thanks! Here is the dropdown:

 

 


  • Author
  • Beginner
  • 4 replies
  • November 22, 2020

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

 

jira_status_360038706952 null

 

Thanks!


andywingrave
Forum|alt.badge.img+9
  • Zapier Expert
  • 854 replies
  • November 22, 2020

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


  • Author
  • Beginner
  • 4 replies
  • November 22, 2020

Hey, Andy. Here you go:

 

 

Thanks!


andywingrave
Forum|alt.badge.img+9
  • Zapier Expert
  • 854 replies
  • November 22, 2020

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

     


  • Author
  • Beginner
  • 4 replies
  • Answer
  • November 22, 2020

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!

 

 


andywingrave
Forum|alt.badge.img+9
  • Zapier Expert
  • 854 replies
  • November 22, 2020

Haha! I thought they might :wink:

Glad to be of help