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 folks,

I’m troubling with the Pipedrive data. 

The field Tag value in Pipedrive is a Text formatted but when the Zapier get the data from Pipedrive, it change to Number Format

Is it a bug? And how do I change it into original format.

Thanks

Data in Zapier
Data in Pipedrive

 

Hi @Dung Ha, welcome to the Community! 👋

Ah, the number will be the ID (unique number) that Pipedrive uses to reference the tag/label. There’s a bug report open for this issue where the ID for the tag/label is returned instead of it’s name. I’ve gone ahead and added you to the list of users being affected by this. I can’t give any ETA on when it will be resolved by but we’ll be sure to email you as soon as it is!

In the meantime, if you need to send the tag’s name to a different app in your Zap you could try adding a Formatter (Utilities > Lookup Table) action to the Zap. You’d set up the lookup table with a list of the tag IDs that are received from Pipedrive and a list of the corresponding tag names. Then it would be would be able to automatically convert the IDs it receives into the relevant tag name. You can usually see the corresponding ID for each tag/label within the dropdown menu for the field (the ID appears in grey text under the name for the tag/label option).

For example:
e44311da0295ea0f32c9c3a7e5521e85.png
And if you’ve not used lookup tables in Zaps before you can find out more about them here: Create lookup tables in Zaps

Hope that helps. If you do decide to add a lookup table to your Zap and run into any issues please let us know. Always happy to help further! 🙂

Hi @Dung Ha, welcome to the Community! 👋

Ah, the number will be the ID (unique number) that Pipedrive uses to reference the tag/label. There’s a bug report open for this issue where the ID for the tag/label is returned instead of it’s name. I’ve gone ahead and added you to the list of users being affected by this. I can’t give any ETA on when it will be resolved by but we’ll be sure to email you as soon as it is!

In the meantime, if you need to send the tag’s name to a different app in your Zap you could try adding a Formatter (Utilities > Lookup Table) action to the Zap. You’d set up the lookup table with a list of the tag IDs that are received from Pipedrive and a list of the corresponding tag names. Then it would be would be able to automatically convert the IDs it receives into the relevant tag name. You can usually see the corresponding ID for each tag/label within the dropdown menu for the field (the ID appears in grey text under the name for the tag/label option).

For example:
e44311da0295ea0f32c9c3a7e5521e85.png
And if you’ve not used lookup tables in Zaps before you can find out more about them here: Create lookup tables in Zaps

Hope that helps. If you do decide to add a lookup table to your Zap and run into any issues please let us know. Always happy to help further! 🙂

Thank mate, I solved my problem. Thanks for your help

You’re most welcome @Dung Ha, glad I could help! 🤗

So pleased you’ve got it sorted now. Great work! 🙌

Terms & Conditions