I am trying to send information to a custom field on a trello card (action is when a Microsoft To Do task is created). The custom field is a drop down menu type, with three options: low, medium, and high. The information coming over from Microsoft To Do has the words “low”, “medium”, or “high” in the task as one of the pieces of data tied to the to do task, so when building the zap action, it shows that I can pipe that word into the appropriate custom field. However, when I test the zap, the custom field did not update (aka, no drop down item was selected, even though I zapped in the word that matches one of the field’s selections). Does anyone know if it’s possible to set up a zap where a specific item in a drop down custom field would be selected upon triggering of a zap?
Trello custom drop down field not updating
- Beginner
Best answer by ShannonKasperson
Actually, I figured it out. I guess each drop down item in Trello had it’s own custom number system, so that’s what I needed to program into the lookup table (see below). The red category is now taking on the code of “high”, yellow is now the “medium”, and green is now the “low” options in my trello custom field. When I piped in this transformed text it worked.
+7- Zapier Solution Partner
Hey
Can you share the screenshot of your action? I would like to see how have you configured.
- Beginner
- Answer
Actually, I figured it out. I guess each drop down item in Trello had it’s own custom number system, so that’s what I needed to program into the lookup table (see below). The red category is now taking on the code of “high”, yellow is now the “medium”, and green is now the “low” options in my trello custom field. When I piped in this transformed text it worked.
+7- Zapier Solution Partner
Understood ,and you are right every value has some id.
Thanks for updating here.
+14- Zapier Orchestrator & Solution Partner
Hi
Yes, field values often have an internal ID that needs to be used when mapping variables via the ‘CUSTOM’ option.
+14- Zapier Orchestrator & Solution Partner
Try looking at the list of dropdown values for the desired field in the Zap step configuration.
The list will show the friendly name and the internal ID (smaller gray font underneath).
I’ve had to manually scrape these values before, otherwise, you have to get the Trello API involved: https://zapier.com/help/doc/how-to-set-up-your-google-spreadsheet-to-work-with-zapier
When I attempt to find the ID, the light gray just shows me the name of the dropdown option, not the internal ID. Not this is pulling information from the “find a card” step. The trigger was “update to a google sheet row”, and then I did the “find a card by name” step, and this is the third step, the lookup step. Any ideas?
+14- Zapier Orchestrator & Solution Partner
The Trello Field IDs will need to be found from a Trello Zap step.
Well, from messing with the final step, I was able to see the IDs in light gray you were talking about. So while I wasn’t sure what zap step would have found them, I have found them now! Thanks for your super fast responses; it’s very much appreciated.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.