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

    How to change field names inside of excel or CSV report?

    Asked by menstrom on May 23, 2016 at 12:58 PM
    Also, I would like to have specific field names for the fields that I export that are not necessarily the labels that I have assigned to the fields, because the labels are the questions but the field names should be different.  For instance, the question is "Check the appropriate option that describes your housing status", but the field name should be HousingStatusCode.  Can I name the fields something other than their labels for the exported file?
  • Profile Image
    JotForm Support

    Answered by BJoanna on May 23, 2016 at 01:20 PM

    Once you create your report you can change name of headings directly on your report. 

    Other solution is to add one additional filed to your form. If the original label of your field is "Check the appropriate option that describes your housing status" add new field with label "HousingStatusCode". The hide that field so that is not visible to your users. 

    You also need to pass value from the field "Check the appropriate option that describes your housing status" to the field "HousingStatusCode". You can use conditional logic Update/calculate field value option to achieve that: https://www.jotform.com/help/268-How-to-Insert-Text-or-Mathematical-Calculation-into-a-Field-Using-a-Condition 

    Then remove filed "Check the appropriate option that describes your housing status" from your report, like I described on your other thread. https://www.jotform.com/answers/844911 

    Hope this will help. Let us know if you need further assistance. 

     

  • Profile Image

    Answered by menstrom on May 23, 2016 at 01:35 PM

    This will be very unwieldy, because I must change the field name of every field on the form!

    When I use your Quick Fields, the output does not necessarily use the label as the field name, but rather it appears that it uses the sub-label.  For instance, Full Name has a label on the form that shows as "Name of Student Applicant...":

    But the output when I download to Excel has the field names as "First Name", "Middle Name", "Last Name".  How is this accomplished?  Perhaps I can do the same thing with other fields.

    Thanks,

    Marilyn

     

  • Profile Image

    Answered by Huberson on May 23, 2016 at 03:05 PM

    The way the sub-labels for name field works is different than the textbox sub-label. This will work for Address field, Date/Time field and such but, with certain field the sub-label will not automatically used as the header in the CSV report.

    You can use the option suggested by my colleague above: adding hidden fields as label for the headers, use conditions to get their values from their corresponding fields, and remove the unwanted labels when creating the CSV report.