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.
Feature request - Save submission edit link to integrated Google Spreadsheet.Asked by WardChristman on January 05, 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.
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:
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:
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:
Hope this helps.
Do get back to us if you have any questions.
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.