Prepopulating already submitted data with values from another form

  • TerryPillinger
    Asked 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)

    Prepopulating already submitted data with values from another form Image 1 Screenshot 30

     

    New value on second form(Available) that I am trying to update from on the second

    Prepopulating already submitted data with values from another form Image 2 Screenshot 41

     

    Any help or assistance on this would be great guys as I have been tryign for hours and hours without success.

     

    Kind Regards

    Ian

     

     

     

     

     

  • Boris
    Replied 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.

  • TerryPillinger
    Replied 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

    http://submit.jotformeu.com/form.php?formID=51665913429361&sid=310420052053972205&available=4&mode=edit

    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

     

  • Boris
    Replied 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.

    Prepopulating already submitted data with values from another form Image 1 Screenshot 20

    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.