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.
How to insert data from Excel or Google Spreadsheet, and have inserted data reviewed by usersAsked by Eyalst on July 15, 2016 at 12:54 AM
I would like to insert data from an outside spread sheet (Excel or Google spread sheet) and get an approval from the user that the data is correct or what is incorrect about it.
How can I do it in Jotform.
If you want to import submissions into your form from a spreadsheet you already have, you can use our Import Data app to import the spreadsheet as submissions into your form:
To get your users to review the data entered on the form, you can send your user(s) the Edit Link of the submission, so that they can review the data that is entered. Since importing submissions from a spreadsheet will not send out email notifications to your users, you would need to manually get the link to the submission to your users so that they can review the data you have inserted for them.
The easiest option would probably be to have an autoresponder set up on your form:
In the autoresponder, you would need to do two things:
1. Add an "Edit Link" to the autoresponder, so that users can use it to edit the data of their submission:
2. Make sure that "Send on Edit" option is enabled under the Advanced tab:
When you have imported submissions, you would simply go to your submissions page, and then you'd have to use the Edit button to edit each form, and simply click on its Submit button again:
As you click on the Submit button, your user(s) will receive the autoresponder email that is sent on the editing of the submission, from where they can use the Edit link we have added into the email to edit their entered data.
Please let us know whether this will work to your satisfaction.