Name element not populating correctly in Emails and Google Sheets

  • Profile Image
    lynnephelps
    Asked on April 26, 2019 at 02:45 PM

    I used the Name element in the form builder, I did not create my own fields. On the form, it breaks it down into a first name and a last name field although both are under Name.

    However, in all the output, I'm having problems with the way the Name field is populated.
    First name contains the first AND last name.
    Last name contains the last name.

    This affects the Email Notification, the Autoresponder, and the Google Sheet file.
    HELP!

  • Profile Image
    lynnephelps
    Answered on April 26, 2019 at 02:49 PM
    Examples:
     
    Google Sheet
     
    1556304503Jotform_Sheet_Name.PNG
     
    Email Notification and Autoresponse:
     
    1556304530Jotform_Email_Name.PNG

  • Profile Image
    zuritapia
    Answered on April 26, 2019 at 05:42 PM

    Hi @lynnephelps!

    Thank you for reaching out to our Support Forum! After further inspecting your form it looks like the Name field on your form is to enter like this:

    1556314042Screen Shot 2019-04-26 at 2.27

    This is causing the google sheet to show two separate columns. What I recommend using to avoid this mix up is maybe trying to use the Short Text Entry Widget like in the example below.

    1556314876Screen Shot 2019-04-26 at 2.40

    Here is the cloned form I created as reference. https://form.jotform.com/91156248515963