Correcting an Invalid Data Property ValueSOLVE
Nov 15, 2017 10:29 AM - edited Nov 15, 2017 11:35 AM
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:
What Zapier sees in the field:
When the zap completes, this is what we see on the contacts record.
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.)
Solved! Go to Solution.
Nov 15, 2017 2:46 PM
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.