Let Users Edit Form After Submisson

  • cbs85food
    Asked on March 25, 2015 at 9: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.

     

    thanks!

  • Kiran Support Team Lead
    Replied on March 25, 2015 at 12:19 PM

    Generally, the submission edit link will be like as below. 

    http://submit.jotformpro.com/form.php?formID=41185204054950&sid={SubmissionID}&mode=edit

    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.

    Let Users Edit Form After Submisson Image 1 Screenshot 40

    Download the Excel report of your submissions.

    Let Users Edit Form After Submisson Image 2 Screenshot 51

    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.

    ="http://submit.jotformpro.com/form.php?formID=41185204054950&sid="&A2&"&mode=edit"

    Let Users Edit Form After Submisson Image 3 Screenshot 62

    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.

     

  • cbs85food
    Replied on March 25, 2015 at 3:24 PM

    thank you for the detailed answer and explanation.  this worked great!!

  • BJoanna
    Replied on March 25, 2015 at 4: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.