Change output field how it displays after exporting

  • Profile Image
    Burkhart
    Asked 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" ?

    Thanks,
    B

  • Profile Image
    jonathan
    Answered on July 28, 2015 at 05: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.

     

  • Profile Image
    Burkhart
    Answered 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.

    Thanks!

     

  • Profile Image
    jonathan
    Answered 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.