Commas Replaced With Semicolons

hmm. this is an interesting glitch that’s definitely being caused by my plugin.

When sending data to HubSpot, arrays of “enumeration” data need to be semi-colon delimited, and not comma-delimited… so I do that conversion… which definitely includes your commas for your values…

A short term solution for that would be to have your values be like slugs… no special characters (A-Z, 0-9, -, _ only), because the “values” vs Labels… if you ever wanted to change the Label, you’d also end up having to change the value too, which would throw out all older data that would no longer match.

That said… I want to resolve this so it doesn’t happen again moving forward (certainly an issue!)… Can you provide me a little more information about what your field is, in Gravity Forms? Basically, what field type, what other values… can you select more than one result for this field?

This will help me be able to replicate over on my end and hopefully come up with a more viable solution.

Thanks,
-Chris.

Hey Chris, thanks for the response. Its just a dropdown menu where you can select only 1 option. Options are as follows (values match these options):

-Start up / I don’t know yet
-$0 – $60,000
-$60,000 – $250,000
-$250,000 – $1,000,000
-$1,000,000 – $5,000,000
-$5,000,000+

Please let me know if you need anything else to troubleshoot. And thanks again for looking into it!
Dave

Good afternoon Dave…

This is an annoying issue that I’m going to be following up with Gravity Forms on…

As I mentioned, the issue falls when dealing with “enumeration” based fields… basically, fields with “choices”… Gravity Forms returns a list of multiple selected choices as a , separated list (why they don’t give me an array, I don’t know)… and HubSpot wants it to be a ; delimited list.

So I changed from rebuilding it on , to , … technically this means that anyone that has a value like “Please, Help” would turn into “Please;Help” … but on the plus side, it doesn’t affect money values anymore.

This is in 2.3.1 which I just released.

Hey Chris –

I am experiencing this issue now as well. Your fix protects my money values, but my comma separated values in enumerated fields are still effected.

Can you give me any more guidance on how to handle these so that semicolons don’t end up in HubSpot?

Example Radio Button Field:
Where do you shop?
() Walmart and thrift stores
() Macy’s, Chico’s, Kohl’s and Nordstrom
() Neiman Marcus and Saks 5th Avenue

Choosing the second radio button writes this to HS:
Macy’s;Chico’s;Kohl’s and Nordstrom

This is preventing my workflows from working according to HS support