- cbsfoodprogramAsked on March 25, 2015 at 09:33 AM
Hi. I have a form where users are able to edit the form after submission using the "edit" link i inserted into the auto responder email. (like this http://www.jotform.com/help/40-How-to-Let-Users-Update-Their-Form-Submissions-at-a-Later-Date).
The problem is I have about 200 or so submissions that were submitted before I added the "edit" link to the autoresponder. I now want to go back and have some of those users edit information. Is there a way for me to create a URL that brings up the form for the user to edit.
- JotForm SupportKiranAnswered on March 25, 2015 at 12:19 PM
Generally, the submission edit link will be like as below.
This might need some manual work in order to generate separate URLs. Since the submission ID is unique to every submission, we can create the URL by using Excel report and send the links manually or mail merge. Please follow the steps below :
Enable the submission ID and other required fields including recipient email from the submissions view.
Download the Excel report of your submissions.
Assuming the Submission ID is the column A of the excel report downloaded, the formula below should help in generating URLs that can be entered at the end of the columns.
You can copy and paste the generated URL to rest of the cells in excel. You can use these URLs to send emails to the users using mail merge.
This support document from Microsoft might help you in mail merging.
Hope this information helps. Let us know if you need any further assistance. We will be happy to help.
- cbsfoodprogramAnswered on March 25, 2015 at 03:24 PM
thank you for the detailed answer and explanation. this worked great!!
- JotForm SupportBJoannaAnswered on March 25, 2015 at 04:49 PM
In my colleague's name, you are welcome.
Do let us know if you have any further questions or issues and we would be happy to assist.