I receive a 2 column email but need to select just the right side, is there a way edit that? Right now it selects both sides.

  • Profile Image
    jh101
    Asked on June 08, 2020 at 03:01 PM
  • Profile Image
    EltonCris
    Answered on June 08, 2020 at 07:15 PM

    You can customize your email notification and remove the 2nd column but you will have to add the field variables manually in order for the form data to be included in the email.

    Here's a visual guide:

    Go to Settings > Emails > edit Notification then you can do the same on the visual guide below to delete the 2nd column and re-add the field variables.

  • Profile Image
    jh101
    Answered on June 09, 2020 at 10:28 AM
    Ok, I tried that.    Now the form sends both Field Name and Submitted Data in one column.       The biggest issue is we need to select + copy just the Submitted Data from the emails.     I'm pasting the data to an Excel file so I need to be able to copy and past just the Submitted Data from the emails to Excel.      We manually send confirmation emails to our clients so we need to have the Field Name and Submitted Data on the emails while being able to select + copy just the Submitted Data.
    On Monday, June 8, 2020, 07:15:40 PM EDT, Jotform wrote:

    A new response has been received: Answered by EltonCris

    You can customize your email notification andremove the 2nd column but you will have to add the field variables manually inorder for the form data to be included in the email.
    Here's a visual guide:
    Go to Settings > Emails > editNotification then you can do the same on the visual guidebelow to delete the 2nd column and re-add the field variables.
    View this thread on browser » Unsubscribe Thread 1591658138
    ...
  • Profile Image
    Amin_N
    Answered on June 09, 2020 at 12:35 PM

    Hi again, @jh101!

    Why would you try to copy-paste submission data from email into Excel sheet while you can do it the right way within your Jotform account?

    Don't you know that you can export submissions as Excel file?

    Please refer to the following guide for more information:

    How-to-Download-Form-Submissions-as-Excel-CSV-PDF

    After reading the guide, if you still need further assistance, please let us know.

  • Profile Image
    jh101
    Answered on June 09, 2020 at 01:28 PM
    Export to Excel is not sufficient.  We confirm multiple form submissions to our clients with a single email.     At the same time we clarify any issues or concerns with the data.     Export to Excel is only used when the emails are not working.   
    We still need to select only the Submitted Data from the emails.     It works like that in our asp form, so I'm hoping it can work with Jot form too.
    On Tuesday, June 9, 2020, 12:36:12 PM EDT, Jotform wrote:

    A new response has been received: Answered by Amin_N

    Hi again, @jh101!
    Why would you try to copy-paste submission data from email into Excel sheetwhile you can do it the right way within your Jotform account?
    Don't you know that you can export submissions as Excel file?
    Please refer to the following guide for more information:
    How-to-Download-Form-Submissions-as-Excel-CSV-PDF
    After reading the guide, if you still need further assistance, please let usknow.
    View this thread on browser » Unsubscribe Thread 1591720540
    ...
  • Profile Image
    Amin_N
    Answered on June 09, 2020 at 03:28 PM

    Hi again, @jh101!

    Why don't you just keep one column for submitted data within email template and remove the other column for field name ?

    Also, did you know that you can attach fully-customizable submission PDF report to every email sent?

    Related guides:

    How-to-Edit-the-Email-Template-for-Notifications-and-Autoresponders

    How-To-Include-Submissions-As-PDF-Attachment-In-The-Email-Notifications

    Please give it a try and let us know how it goes.

  • Profile Image
    jh101
    Answered on June 09, 2020 at 05:28 PM
    We tried that first.     The reason we want a 2 column email is not all fields are required.     So we end up with a single column of data with blank lines in between.     Those emails are sent to our clients as confirmation. The 1 column emails are missing the field names, so it's not detailed enough to send to our clients.     And we are back to needing the 2 column emails.      I'm really trying to make this work, as we have been in business 20 years and have over 3000 regular clients.    
    I'm definitely willing and will experiment with different options as I think we can figure something out.
    The biggest issue is keeping the data on the form after the submit button is pressed, with or without a separate confirmation page.    
    Its a must have for us.
    On Tuesday, June 9, 2020, 03:28:58 PM EDT, Jotform wrote:

    A new response has been received: Answered by Amin_N

    Hi again, @jh101!
    Why don't you just keep one column for submitted data within email templateand remove the other column of field name ?
    Also, did you know that you can attach fully-customizable submission PDFreport to every email sent?
    Related guides:
    How-to-Edit-the-Email-Template-for-Notifications-and-Autoresponders
    How-To-Include-Submissions-As-PDF-Attachment-In-The-Email-Notifications
    Please give it a try and let us know how it goes.
    View this thread on browser » Unsubscribe Thread 1591730936
    ...
  • Profile Image
    Amin_N
    Answered on June 09, 2020 at 06:51 PM

    Hi again, @jh101!

    Since you mentioned that you need email template to have 2 columns, one for field name and one for submission, then you probably need to add a a new column to email template using the "Add column before" and/or "Add column after" buttons as shown below:

    1591742865Kazam_screenshot_00401.png

    Please give it a try and let us know how it goes.