Add a customized edit link column in Google Spreadsheet

  • Profile Image
    Asked on February 06, 2016 at 09:07 AM

    We integrate our form jotform responses with google spreadsheet.  

    There is always a hyperlink for editing the submission.  

    Can i get jotform to create another field name with the customised edit link data passed to that field name in it?

    In that way we can create an updated response from the submissions  passed to google spreadsheet rather than a email notification.


    thanks in advance


  • Profile Image
    Answered on February 06, 2016 at 10:16 AM

    I have come up with a solution to your concern, however, this would mean you need to make Full Name field a single field and so as the Phone Number field.

    Here's a sample form,

    On the demo form, I have added a "Customized Edit Link" field and hid it so the user of your form will not be able to see it. 

    I will create the edit link that will appear on Google Spreadsheet on that field using conditions.

    First, I need the link to my form or my form URL,

    Then, the field names of all the other field except the Customized Edit Link field: fullName, emailAddress, phoneNumber, comments, radioButton, dropDown, and checkbox.

    Lastly, the field values which will be generated in the condition.

    Creating the condition:

    The first part of the condition is making the Customized Edit Link update its value if any of the fields is filled or changed.

    Second part would be constructing the value that will be passed to the Customized Edit Link field:

    As for the result, (Note: I have unhid the Customized Edit Link field for testing purposes only)

    And here's how it would look like on Google Spreadsheet.

    By the way, you can also create separate fields for Prefix Name, First Name, and Last Name and Area Code and Phone Number, however, it will create separate fields on your Google Spreadsheet as well.

    I hope this helps. Let us know if you need any further assistance or clarifications with any of the instructions above. Thank you.

  • Profile Image
    Answered on February 06, 2016 at 03:57 PM

    thats great,


    I almost got it to work the integration with google sheets works like a dream and allows us to click on a hyperlink from our main menu to open a new jotform with prepolulated from the last submission..

    =hyperlink(vlookup(IF(ISBLANK(B2),"", IFERROR (large(filter(Submissions!C:C, LEFT(Submissions!E:E,5) =LEFT (B2,5), LEFT(Submissions!F:F,5) = LEFT (C2,5)) ,1),"")),Submissions!C2:AF,30,FALSE),B2)


    Im still having problems with the drop down menu that selects what hostel they are in... 


    {hostelAddress} it does not populate.


  • Profile Image
    Answered on February 06, 2016 at 11:13 PM

    If I can understand, you are adding this link in the spreadsheet, could be possible for us to get a sample link?

    A link where the field is not being populated, also I assume that you shared us the link of your first form, where the value is sent to your second form, please provide us the link to the second form, where the value should go in, it will be helpful for us to make some test and identify why your field is not populating.


  • Profile Image
    Answered on February 07, 2016 at 07:45 AM

    Problem solved

    Not sure what the problem was 

    cheers for the help

    Now I have a customized link on my google sheets to open a form with the last submission and to submit a new instance



  • Profile Image
    Answered on February 07, 2016 at 01:06 PM

    Glad to hear it and thank you for sharing your workaround. :)

  • Profile Image
    Answered on February 23, 2016 at 03:58 AM

    the customised edit link does not work when using date fields.


    this works for updating from an email link{fullName}&date[day]={date:day}&date[month]={date:month}&date[year]={date:year} 



    But i need this to appear in the google sheet that its integrated with

    The form:


    here is a link to the google sheet its intergrated with

    The Sheet:


    Ive asked others but I think its makes more sense asking from this old thread


  • Profile Image
    Answered on February 23, 2016 at 10:01 AM

    Unfortunately, this text:{fullName}&date[day]={date:day}&date[month]={date:month}&date[year]={date:year} 

    Will have its other characters stripped or removed if you add it in your conditional logic.

    Tag likes {date:month} can't be used to pass values, unfortunately. That is why it is being removed in the calculation area in your conditions. I see you already have another thread about it and my colleagues have already answered your question there too. 


    I'm trying some workarounds, but none work so far. Apologies. I strongly suggest posting your replies on the other thread as I see the discussion there is already established.