Importing full name, but displaying backwards on submissions view

  • adatshalom
    Asked 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

  • Kiran Support Team Lead
    Replied on August 31, 2016 at 2: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! 

  • adatshalom
    Replied on August 31, 2016 at 4:45 PM

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

    https://www.adatshalom.net/spiritual-community-123/holidays/high-holy-days/19-spiritual-community/259-yizkor-book

    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. 

  • Kiran Support Team Lead
    Replied on August 31, 2016 at 6: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!