Change output field how it displays after exporting

  • Burkhart
    Asked on 28. heinäkuuta 2015 klo 15.34

    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

  • jonathan
    Replied on 28. heinäkuuta 2015 klo 17.10

    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.

    Change output field how it displays after exporting Image 1 Screenshot 40

    so in the live form it actually look like this

    Change output field how it displays after exporting Image 2 Screenshot 51

     

    the submission data will use the actual field label/name

    Change output field how it displays after exporting Image 3 Screenshot 62

     

    Hope this help. Let us know how we can assist you further.

     

    Thanks.

     

  • Burkhart
    Replied on 29. heinäkuuta 2015 klo 16.39

    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!

     

  • jonathan
    Replied on 30. heinäkuuta 2015 klo 0.31

    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..."

    Change output field how it displays after exporting Image 1 Screenshot 20

     

    I hope this help. Let us know if we can assist you further.

    Thanks.