Correcting an Invalid Data Property Value

Smart CRM & Sales Hub CRM
1

We ask t-shirt size on several different forms. We have started automating the process for automatically updating that information from our different forms into HubSpot. However, it appears that Zapier sees the data in the dropdown in Hubspot one way, but it does NOT appear that way when you look at that field’s properties in Hubspot.

What we see HubSpot:

Screen Shot 2017-11-15 at 9.22.35 AM.png
Screen Shot 2017-11-15 at 9.22.35 AM.png718×561 43.6 KB

What Zapier sees in the field:

Screen Shot 2017-11-15 at 9.17.45 AM.png
Screen Shot 2017-11-15 at 9.17.45 AM.png371×309 21.5 KB

(additional information)

When the zap completes, this is what we see on the contacts record.

Screen Shot 2017-11-15 at 10.31.54 AM.png
Screen Shot 2017-11-15 at 10.31.54 AM.png417×111 8.09 KB

I tried reformatting the field coming from the form to match the data as it appears in the Zapier dropdown, but received an error saying that was not a valid option in the Hubspot dropdown.

Why is this field show as invalid when clearly it is not? (I did check the data for extra white space.)

2

I’m thinking it’s the single quote in the contact property’s internal value that is causing the problem. I would suggest modifying the internal values in Hubspot and remove the quote and spaces and replace with underscore.

So for example Women’s Small would become womens_small.

See if that fixes the issue.

3

Thank you so much for the clear explanation! I updated the internal values and added a step to my zap to transform the data to match. It appears to be updating properly now.