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

    Separating First and Last Name on Reports...

    Asked by cmygsa on September 13, 2012 at 11:15 PM

    I included the "Full Name" field on my form.  However, when I look at the Submissions where I can download all of my submissions to Excel, it all goes into ONE column of the report.  Can that be separated into First Name and Last Name on the Submissions Report?  Your help and guidance would be appreciated!  Thanks, Alissa

    Page URL:
    http://www.jotform.com/submissions/22558789152162

    Screenshot
  • Profile Image
    JotForm Support

    Answered by jonathan on September 14, 2012 at 01:20 AM

    @cmygsa

    Since you already used the compound field Full Name from the quick tools, instead of a single textbox each for first and last name, the output report considers the field as one only.

    If you do not have submissions yet for this form, perhaps you can edit the form and use a separate textbox field instead. The resulting output report will automatically adjust to this.

    If in case you have submissions already, and you cannot edit the form anymore (please note: deleting a field will delete also the data for that field), what you can do instead is produce the report in another way.

    1. You can integrate the form to Google doc spreadsheet, and use the google spreadsheet as the report. In the spreadsheet, you can use the 'text-to-column' split method to split the compound Full Name into 2 column.

    2. Download the submissions as Excel, and use it as the output report. In Excel, there is also a function 'text-to-column', so, you can also split the Full Name field.

    Hope this help.

    Please inform us if you have further inquiry.

    Thanks.