What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Is there a way to paste data from html table to excel avoiding the line breaks (hard returns)?Asked by FailsafeNetwork on April 22, 2016 at 12:15 PM
We do not collect submissions, but deliver autoresponders to client sites who will need to collect the data. Is there a way to embed an excel table
I am creating a form that is a template for investigations. Once the user inputs the information, the user submits the form to their designated email address. My company DOES NOT WANT to see the users SUBMISSIONS. The information inputted is typically the users client-company sensitive. That being the case, I made the autoresponder go to the designated email address, with a table providing all of the data. Then, the person receiving the email can copy the inputted data, and then paste it into excel.
Here is the problem:
If there are returns in one out of the many data cells, copying and pasting into excel recognizes those returns only as multiple cell content. I need to try to make this as easy as possible for the client.
Is there a way to embed an excel table into the autoresponder, for making copy and pasting more fluid?
If not, any advice would be amazing.
paste to excel line break html table
Unfortunately, we do not have such an option. However, a way around this could be creating an Excel report: https://www.jotform.com/help/101-How-to-create-an-Excel-Report
And including the link in the Autoresponder to download the Excel file. However, this report will show all the entries received up to date, not only an individual submission. Hope this helps, let us know if you have more questions.
Hi, Unfortunately, this will not work for me, as each individual submission needs to be privately viewed. Can I code within the autoresponder to remove hard returns from the inputted data?
I have tried different field types and table formats, but unfortunately, this is not likely that we can filter or avoid the hard returns.
Only the single line input seems to be working in this case.