Make it possible to populate on edit URL through URL parameter

  • Profile Image
    LHEDJ
    Asked 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

  • Profile Image
    BDAVID
    Answered 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
    LHEDJ
    Answered 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
    Nik_C
    Answered 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
    LHEDJ
    Answered 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
    LHEDJ
    Answered 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
    EltonCris
    Answered 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!