-
jh101Asked on June 8, 2020 at 3:01 PM
-
Elton Support Team LeadReplied on June 8, 2020 at 7: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.
-
jh101Replied on June 9, 2020 at 10:28 AMOk, 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
... -
Amin_NReplied on June 9, 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.
-
jh101Replied on June 9, 2020 at 1:28 PMExport 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
... -
Amin_NReplied on June 9, 2020 at 3: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.
-
jh101Replied on June 9, 2020 at 5:28 PMWe 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
... -
Amin_NReplied on June 9, 2020 at 6: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:
Please give it a try and let us know how it goes.