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

    Add a customized edit link column in Google Spreadsheet

    Asked by stevedellar 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

    steve

    Google Spreadsheet integration custom edit link conditions value
  • Profile Image
    JotForm Support

    Answered by Mike_G 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, https://form.jotform.com/60349170651958

    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, https://form.jotform.com/60349170651958

    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 by stevedellar 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.

     

    https://form.jotformeu.com/52894323651358

  • Profile Image
    JotForm Support

    Answered by Kevin_G 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 by stevedellar 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

    Great!!

     

  • Profile Image
    JotForm Support

    Answered by EltonCris on February 07, 2016 at 01:06 PM

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

  • Profile Image

    Answered by stevedellar 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

     https://form.jotform.com/60515279911962?&fullName={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:   https://form.jotformeu.com/60351548386359

     

    here is a link to the google sheet its intergrated with

    The Sheet:  https://docs.google.com/spreadsheets/d/1d967I5fNqiepeJVfa2vxKPH2a1VhGy_uH3VvoHO8SKk/edit?usp=sharing

     

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

    Cheers

  • Profile Image
    JotForm Support

    Answered by Charlie on February 23, 2016 at 10:01 AM

    Unfortunately, this text:

    https://form.jotform.com/60515279911962?&fullName={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. 

    http://www.jotform.com/answers/777325 

     

    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.