Form results incorrectly converting numeric hyphen text field to a date

SOLVE
Highlighted
Visitor

We have a form that includes a radio button question where the possible answers are 1 - 3, 3 - 5, 5 - 7, etc.  When I export the form submissions, the responses have been converted to dates and attempting to reformat the CSV fields only yields an unrelated integer.  This causes us problems processing the results.   How do we get the CSV export to capture the field as text (and NOT assume it's a date)?

Reply
0 Upvotes
1 Accepted solution

Accepted Solutions
Highlighted
Regular Advisor

Unfortunately I tested and this is a bug with the system with the CSV export.  I would just recommend doing an Excel export for the time being to avoid this as those formats did not produce the same results for me.  Or consider changing the internal value of the radio button options so that it doesn't read #-#.  Maybe try adding a space in between or changing the hyphen to an underscore (ie: 1_3).

4 Replies 4
Highlighted
Regular Advisor

That sounds like a bug to me.  Have you opened a ticket with support for Hubspot to look into this?

Reply
0 Upvotes
Highlighted
Visitor

Thanks, Ben. We were told we only have access to the Community and to post here and hope for a response Smiley Sad

Reply
0 Upvotes
Highlighted
Regular Advisor

Unfortunately I tested and this is a bug with the system with the CSV export.  I would just recommend doing an Excel export for the time being to avoid this as those formats did not produce the same results for me.  Or consider changing the internal value of the radio button options so that it doesn't read #-#.  Maybe try adding a space in between or changing the hyphen to an underscore (ie: 1_3).

Highlighted
Visitor

Dowloading as XLS instead of CVS solved it.  Thanks, Ben!

Reply
0 Upvotes