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.
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.
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
any thoughts on where i might be going wrong?
Please allow me some additional time to look into this problem for you and I will get back to you about it briefly.
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.
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:
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.