- BurkhartAsked on July 28, 2015 at 03:34 PM
Is there a way to change the way a field displays when we download it into excel?
If our Field name now (on the form) is "Issue Y/N Please allow......", can we make it so that that same field once imported into excel now has the header at the top called just "Issue" ?
- JotForm SupportjonathanAnswered on July 28, 2015 at 05:10 PM
The downloaded data will use the actual field label/question name in the form. This is the same to the exported data to Excel -- the column/header name of the Excel data is the actual field label/name.
A trick you can do is to use a dummy TEXT field (from Form Tools) as the visual question/label/name of the field in the form, while hiding the actual field label/name. See image below for the idea.
so in the live form it actually look like this
the submission data will use the actual field label/name
Hope this help. Let us know how we can assist you further.
- BurkhartAnswered on July 29, 2015 at 04:39 PM
I know how to see the CSS code. You're saying I need to manipulate that CSS code to make it hide the field label? I'm not sure how to do that.
- JotForm SupportjonathanAnswered on July 30, 2015 at 12:31 AM
I think you will be able to understand the concept better if you clone my test form
user guide: -How-to-Clone-an-Existing-Form-from-a-URL
Then test the form by submitting it..
If you check your Excel submission data, you should see that the column header is "Issue" and not "Issue Y/N Please allow..."
I hope this help. Let us know if we can assist you further.