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.

Question

Map variable list of values from single text field to multiple fields in CRM

  • September 21, 2021
  • 2 replies
  • 932 views
Z

We have a set of data in our source that is only present if it is chosen and is a list of values in a text string.

As an example, the customer can choose Add-Ons (Add On 1, Add On 2, Add On 3, etc.). 

If the user chooses Add on 2, Add On 3), what is shown in the API is the field Id values for those 2 fields in one field (i.e. 4127, 4136). Any values not chosen are not listed.

We are trying to map this to our CRM, so if the field is present, mark it TRUE in CRM. So when we see 4127 we know this is Add On 2 and therefore in CRM mark Add On 2 as True.

Seems this is probably a multi-step process, but not quite clear on how to do it.

Any direction is appreciated.

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.

2 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Troy TessaloneZapier Expert
  • Zapier Expert
  • 31281 replies
  • September 21, 2021

Hi @ZinZap 

How many Add-On possibilities are there?

If only a few, you could possibly have separate Zaps with Filters or 1 Zap with Paths to handle the conditions.

Filter: https://zapier.com/apps/filter/help

Paths: https://zapier.com/apps/paths/integrations

 

You could use a Code step to determine if the Add-Ons are present then set True/False for each and map those output T/F to the CRM fields.

NOTE: This is an advanced approach.

Code: https://zapier.com/apps/code/help

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
jayeshkumarbhatia
Forum|alt.badge.img+6

Hi @ZinZap ,

 

I have a solution for this, but you have to be good at coding. You can easily solve your problem by writing a Javascript code.

Terms & Conditions