What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Change output field how it displays after exporting

    Asked by Burkhart 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

    exporting after how excel name thanks same
  • Profile Image
    JotForm Support

    Answered by jonathan 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

    Answered by Burkhart 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
    JotForm Support

    Answered by jonathan 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.