JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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 set up Google Spreadsheet to create the edit link next to each rowAsked by ecologsweden on April 28, 2015 at 12:46 PM2. Secondly, in the same Google spreadsheet we need to add the edit link for each submission. Fixed this in the past by using the formula =hyperlink("http://submit.jotformeu.com/form.php?formID=42652947923363&sid="&Z51&"&mode=edit";"Edit") where the value in cell Z51 would be the submission ID. Figured I could add this in a new column and add to all rows, but this won't work automatically since JotForm creates a whole new row for each new submission, so even this added column gets cleared when a new submission is being added. This forces me to manually add this data in the preferred cell. How could I solve this?
I believe that this was changed in the latest updates to our Google Spreadsheet integration.
Now an idea comes to mind, which is to use the drag option (manually) to create the link each time, like so:
While I know that screenshot shows already done submissions, this works also if they are just added by the integration.
The other alternative would be to create a Google Spreadsheet script that would do this for you. I believe that you could attach it to an event to work each time a new entry is made.