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

    Google Spreadsheet Formula for generating edit link

    Asked by studentuniontest on August 29, 2014 at 12:27 PM
    sorry not really sure I understand that - is there an example I can see on a  spreadsheet?
    google spreadsheet generated edit link linking spreadsheet
  • Profile Image
    JotForm Support

    Answered by Kiran on August 29, 2014 at 03:21 PM

    You can achieve this by using the below formula.

    ="http://www.jotform.com/form.php?formID=FORMID&sid="&Submission ID Cell No&"&mode=edit"

    Please see the screenshot (Click on it to enlarge) below :

    Here the submission ID is in the Column I. So, the submission ID shall be I2, I3 and so on for each row. You can get the respective form ID from the form edit mode :

     

     

    Hope this information helps. Please get back to us if you need further assistance. We are happy to assist you.

  • Profile Image

    Answered by UoNSU on September 02, 2014 at 09:44 AM

    Hi 

     

    many thanks - I've done this, and made it into an array formula so that it auto-copies to every row

    However when i click the link it says formula not valid

     

    this is the formula i have put 

     

    =ARRAYFORMULA("http://www.jotform.com/form.php?formID=30711732068954&sid="&BH2:BH&"&mode=edit")

     

    any thoughts on where i might be going wrong?

  • Profile Image
    JotForm Support

    Answered by KadeJM on September 02, 2014 at 10:28 AM

    Please allow me some additional time to look into this problem for you and I will get back to you about it briefly.

  • Profile Image
    JotForm Support

    Answered by KadeJM on September 02, 2014 at 11:47 AM

    Sorry about the delay. The original formula plus shifting to your array confused me slightly at first but I think I may have figured it out more now.

    From what I found I believe it's not valid because the array is causing the reference link to fail since your #ref cell was getting parsed incorrectly.

     

    You had:

    BH2:BH

    I'm not exactly sure what your BH is but it needs to reference your column cells to pull the appropriate sequential data. This means that it should actually be something like:

    =ARRAYFORMULA("http://www.jotform.us/form.php?formID=42443973435156&sid="&G2:G4&"&mode=edit")

     

    Here's a Screenshot:

    - Note that I have referenced the submission id column to pull and populate that data into the form's edit link which is now also hyperlinked together.