Separating First and Last Name on Reports...

  • Profile Image
    cmygsa
    Asked 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

  • Profile Image
    jonathan
    Answered 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.