-
BurkhartAsked on July 28, 2015 at 3: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" ?
Thanks,
B -
jonathanReplied on July 28, 2015 at 5:10 PM
Hi,
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.
Thanks.
-
BurkhartReplied on July 29, 2015 at 4: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.
Thanks!
-
jonathanReplied 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
http://form.jotform.me/form/52086165403451?
user guide: -How-to-Clone-an-Existing-Form-from-a-URL
After you have cloned the form, add an Excel Report to it.
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.
Thanks.