Make it possible to populate on edit URL through URL parameter

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

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.

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?

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!

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

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.

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!