-
LHEDJAsked 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 -
David JotForm Support ManagerReplied 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.
-
LHEDJReplied on September 8, 2016 at 3: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?
-
Nik_CReplied on September 8, 2016 at 4: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!
-
LHEDJReplied on September 9, 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 changedwww.lhe.dj
-
LHEDJReplied on September 10, 2016 at 5: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.
-
Elton Support Team LeadReplied on September 10, 2016 at 8: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!