Feature request - Save submission edit link to integrated Google Spreadsheet.

  • WardChristman
    Asked on January 5, 2015 at 11:12 PM

    I would like to have the edit link shown to you (saved) in the Google Spreadsheet for each submission. This would be extremely useful help customers to edit their entries.

  • Ashwin JotForm Support
    Replied on January 6, 2015 at 2:59 AM

    Hello WardChristman,

    Upon your request, I have created a feature request ticket and sent it to our back end team. We will get back to you as soon as we have any update from them.

    For now, I will suggest you to generate your submission's edit link yourself and it is very easy to do so. The edit link URL is constructed as mentioned in below format:

    http://www.jotform.com/form.php?formID=FORM_ID&sid=SUBMISSION_ID&mode=edit 

    In the above URL, you just need to replace the "FORM_ID" with the ID of your form and "SUBMISSION_ID" with the id of your form's submission which you want to edit.

    You can also add formula to generate the edit link in your google spreadsheet. Please check the screenshot below on how to generate the edit link for every submission in your google spreadsheet:

    Feature request   Save submission edit link to integrated Google Spreadsheet Screenshot 20

    So basically, you can use the following URL in your google spreadsheet and replace the "E2" with the cell number of your spreadsheet which has the submission id and also change the form ID:

    ="http://www.jotform.com/form.php?formID=FORM_ID&sid="&E6&"mode=edit"

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!

  • alp_deniz
    Replied on October 3, 2015 at 11:38 PM

    Hello,

    My sincere apologies for this delayed update. We have enabled edit links in Google Spreadsheets a while ago and new integrations should have edit links in them.

    For your information, you may like to disable them by deleting the edit link column until we add the option to Spreadsheets integration wizard.

    Thank you for your patience.

    Kind regards