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

    Importing full name, but displaying backwards on submissions view

    Asked by adatshalom on August 31, 2016 at 12:24 PM

    This is probably a minor issue, but odd one. We successfully imported data in "LAST NAME, FIRST NAME" format on the spreadsheet and properly displays in the submission we are giving folks to edit with the names in the appropriate text box. However, when we view the Submission data it shows a "Full Name ..." field but the "LAST NAME FIRST NAME" with no comma

    Page URL:

  • Profile Image
    JotForm Support

    Answered by Kiran on August 31, 2016 at 02:25 PM

    Do you mean to display the comma also in the Full name field? Could you confirm if you are referring to the form https://www.jotform.com/52015762207953 that you are importing the data? As I check the form http://www.jotform.us/form/62434447189160 and it looks like that you have deleted the form. Let us know if it is the clone to the original form or a different form.

    Please confirm so that we can provide with necessary assistance. Thank you! 

  • Profile Image

    Answered by adatshalom on August 31, 2016 at 04:45 PM

    Sorry for any confusion. The form to which we have imported data is at:


    When I go to view the Submissions, there is a field "Full Name of Person Completing this Form" in which one sees the data backwards "Last Name First Name"

    However, if I click Edit and view the data in the form, everything is correct: First Name showing up in the First Name box; Last Name showing up in the Last Name box.

    Just trying to figure out why this might have happened, or if is something broken on your end as part of the import process. 

  • Profile Image
    JotForm Support

    Answered by Kiran on August 31, 2016 at 06:39 PM

    I believe that you have used our import submissions app to import the submissions. When merging the first name and last name to accommodate the Full name field in the template, the format should be First Name, Last Name. It seems that you have merged these fields as Last Name, First Name which is displaying in the same way.

    If you have the template you may try importing the submissions by changing the format to First Name, Last Name so that it should be displaying normally.


    Hope this information helps!