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.

  • Profile Image

    How to set up Google Spreadsheet to create the edit link next to each row

    Asked by ecologsweden on April 28, 2015 at 12:46 PM
    2. 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?
  • Profile Image

    Answered by Ben on April 28, 2015 at 01:17 PM

    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.