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

  • Profile Image
    Asked 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(""&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 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.