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

    Make it possible to populate on edit URL through URL parameter

    Asked by LHEDJ on July 20, 2016 at 11:40 AM

    I've already used www.prepopulate.jotform.io but now I'd like to use the "Edit Submission" link to carry an answer from the sheet to a question on the already filled form.

    I've tried the following combinations:

    https://jotform.co/form.php?formID=123?rowNumber=10&sid=456&mode=edit
    https://jotform.co/form.php?formID=123&sid=456?rowNumber=10&mode=edit
    https://jotform.co/form.php?formID=123&sid=456&mode=edit?rowNumber=10
    https://jotform.co/form.php?formID=123&rowNumber=10&sid=456&mode=edit
    https://jotform.co/form.php?formID=123&sid=456&rowNumber=10&mode=edit
    https://jotform.co/form.php?formID=123&sid=456&mode=edit&rowNumber=10
    https://jotform.co/form.php&formID=123?rowNumber=10&sid=456&mode=edit
    https://jotform.co/form.php&formID=123&sid=456?rowNumber=10&mode=edit
    https://jotform.co/form.php&formID=123&sid=456&mode=edit?rowNumber=10
    https://form.jotform.co/form/123?rowNumber=10&sid=456&mode=edit
    https://form.jotform.co/form/123&sid=456?rowNumber=10&mode=edit
    https://form.jotform.co/form/123&sid=456&mode=edit?rowNumber=10
    https://form.jotform.co/form/123&rowNumber=10&sid=456&mode=edit
    https://form.jotform.co/form/123&sid=456&rowNumber=10&mode=edit
    https://form.jotform.co/form/123&sid=456&mode=edit&rowNumber=10

    already submitted
  • Profile Image
    JotForm Support

    Answered by BDAVID on July 20, 2016 at 12:50 PM

    Try with this: https://www.jotform.com/edit/SubmissionID/

    Example:

    1) Edit link: https://www.jotform.com/edit/341820012499684301/ 

    2) Populated text: https://www.jotform.com/edit/341820012499684301/?firstName=David&lastName=Bonilla 

    Let us know if you need more help.

  • Profile Image

    Answered by LHEDJ on September 08, 2016 at 03:27 AM

    Thanks David, this works. But before I can use it I need to find a way to convert the "Edit Submission" link that JotForms sends to my sheet to an actual URL.

    Google Sheets doesn't have a formula to reverse a Hyperlink to URL text, can I set JotForms to send the whole URL as text rather than the "Edit Submission" as a Hyperlink?

  • Profile Image
    JotForm Support

    Answered by Nik_C on September 08, 2016 at 04:20 AM

    You can create an Edit link by using this URL:

    https://www.jotform.com/form.php?formID=FORMID&sid={id}&mode=edit

    Where FORMID is ID of the form and {id} is ID of the submission.

    You can use that link and it will create automatically Edit link for each submission.

    Hope it helps, if you need any additional assistance please let us know.

    Thank you!

  • Profile Image

    Answered by LHEDJ on September 09, 2016 at 11:47 PM

    WOW Thank you so much :-)

    This solution is one of several used to integrate JotForm with Ultradox.
    This is used to instruct Ultradox as to which row to process, when Editing an already submitted form.

    The following formula will only work on Row 2 of Google Sheets (Row 1 is setup to check row 2 is in the right place, i.e. if you edit, move or delete a form question):

    =arrayformula(if( row($D2:$D)=2, "Link to Edit Client Enquiry Form", if( len($D2:$D), HYPERLINK("https://jotform.co/form.php?formID=00000000000000&sid=" & Submissions!DK:DK & "/?rowNumber=" & ROW(G2:G),"Edit Submission"),)))

    ($D2:$D) - IF "this" row has something in it, activate the arrayformula for that row, (D) can be changed.
    Submissions!DK:DK - Is the column the Submission ID is stored.
    "/?rowNumber=" - Is the name of the JotForm field you want the row number to go
    ROW(G2:G) - Adds the current row number, (
    G) can be changed

     

    www.lhe.dj

  • Profile Image

    Answered by LHEDJ on September 10, 2016 at 05:26 AM

    I've encountered a problem, when the POST link is clicked (that adds additional info to the already filled form via the HTML link) it clears any pre existing data, leaving only the data being added from the link.

    Keeping in mind I'm trying to Post Populate not Pre Populate.

  • Profile Image
    JotForm Support

    Answered by EltonCris on September 10, 2016 at 08:23 AM

    I hate to say this but it is not possible to populate data using URL parameters on edit URL. That is not yet supported and I'm not sure if we have such plans in the future. However, I will escalate this to our devs so they will hopefully consider this in the future. I could not assure you anything about this though but rest assured, any updates or decision about this will be posted on this thread.

    As of its current behavior, when you try to populate on edit URL through URL parameters, the data from URL are quickly inputted to the fields but they are removed after that because the existing submissions data overpowers everything.

    You can see it in action here:

    We will let you know via this thread once this is implemented. Thanks!