-
TerryPillingerAsked on June 24, 2015 at 11:02 AM
HI,
This one has got me!
I have tried passing the value from one form to another using the URL parameter which works fine.
The issue I have which I hope is durable is the following
One form contains the details of an agent including a textbox that states a total number of boards, for example 5.
They click on the button which takes them to a second form and the agent details are passed also using he method mentioned earlier. - all great !!
A board is booked In the second form by entering 1, in the used board which then changes the available value to 4 - all great still !
Then this is where it all falls down,
I want the total boards box in the 1st form to change from 5 to the new amount of 4, it does this very briefly but then changes back to the original amount of 5.
I know its got to do with the passing URL syntax, I think ?
I am nut sure how to update the existing value in the first form as this now has a SID number in addition to the form id.
Here is my links which hopefully helps
Blank new Agent details
http://www.jotformeu.com/form/51665913429361
New board form
http://form.jotformeu.com/form/51673369168365
New Agent form completed
http://submit.jotformeu.com/form.php?formID=51665913429361&sid=310420052053972205&mode=edit
Box on first form to be updated(Total boards)
New value on second form(Available) that I am trying to update from on the second
Any help or assistance on this would be great guys as I have been tryign for hours and hours without success.
Kind Regards
Ian
-
BorisReplied on June 24, 2015 at 12:33 PM
Ian, upon taking a look, I can see that you are using a hard-coded submission ID on the thank-you page of your second form:
http://www.jotformeu.com/TerryPillinger/My_Link&sid=310420052053972205&available={available16}
Now, I would like to take a step back and try to confirm what is your expected workflow. As I understand it, your users are filling and submitting your first form - Blank new Agent details.
Upon submitting this form, they are redirected to New board form, where some fields are prepopulated from the first form. On this second form, you are updating a certain field. After this second form is submitted, you would like to edit the existing submission info from the first form (Blank new Agent details), and update a field with a value from this second form.
Am I correct in understanding your desired workflow?
If so, I believe that you will also need to pass the submission ID back of your initial form submission.
In other words, on your first form's thank you URL, you would also need to forward/prepopulate the submission ID to your second form.
http://form.jotformeu.com/form/51673369168365?agent={agentBusiness}&total={totalboards}&agentEmail={agentEmail}&someHiddenFieldOnSecondForm={id}
You will then need to create a (hidden) field on your second form to capture the {id} of your first submission, from my example above, the name of the field on your second form would be someHiddenFieldOnSecondForm.
Then, on the thank you link of your second form, you would need to edit the submission ID from that hard-coded number 310420052053972205, to the value of your new someHiddenFieldOnSecondForm.
http://submit.jotformeu.com/form.php?formID=51665913429361&sid={someHiddenFieldOnSecondForm}&available={available16}&mode=edit
Please try setting it up in this manner, Ian, and kindly let us know how it goes.
-
TerryPillingerReplied on June 25, 2015 at 4:08 AM
Hello Boris,
thank you for providing me with and excellent step by step guide above.
I have done everything as described, passing the id to the second etc, all works except the value appears very briefly, like for a split second then disappears ?
Below is the URL that is passing the values
As said, it appears to pass the value then removes it ?
Any further help would be great as this nagging little bit is pivotal to the overall system
Kind regards
Ian
-
BorisReplied on June 25, 2015 at 6:02 AM
Yes, it seems that we do not support form prepopulating of the Edit Submission links. The Edit Submission page firstly loads the prepopulated value, then it realizes that these prepopulated values are not from the submission that you are trying to edit, and updates the values so that you are editing the first submission.
This makes it unfeasible to edit the first submission with form prepopulating.
I can only recommend that you please ask your users to edit their first submission available number manually, by including text such as:
Please update the number of available boards to {available16} on the page that opens upon submit.
The {available16} would be replaced with an actual number of available boards on your second form, so your users only need to enter this number manually in the form (edit submission) that opens upon submitting your second form.
I would also like to point out that it still doesn't seem that you have set up your forms to catch the actual submission ID from the first form, as recommended above. If you wish to edit the actual submission of the first form, even manually, you need to use its submission ID in the thank-you link.
Please let us know how it goes.