Issue passing data from one form to another using URL parameters

  • Profile Image
    innovalinks
    Asked on October 03, 2017 at 05:50 AM

    Hello, this works perfectly when you are dealing with one submission at a time. But is there a way for it to work when you receive multiple "Form 1" submissions before you get to open the prepopulated "Form 2" URL?

    What I have found is that everytime I click on the prepopulated URL, if I have 4 submissions, it will retrieve the latest form data, then the previous one, then the previous one and so forth.

    Is there a way to make the URL call up the fields for a specific form sumbission?



    This is a re-post of a comment on How to Automatically Pass Form Data to Another Form

  • Profile Image
    Mike_G
    Answered on October 03, 2017 at 01:41 PM

    I would like to apologize for the inconvenience. However, based on the guide, each form link produced to prepopulate Form 2 is created based on the data submitted from Form 1. This means that the data that will prepopulate Form 2 will be different provided that the data entered in Form 1 before submitting it are also different from other submissions.

    Here's a clone version of the sample Form 1 in the guide — https://form.jotform.com/72753701955967

    When you submit that form you will receive an email autoresponder as long as you provide a valid email address. You will also be redirected to a prepopulated clone version of Form 2 in the guide.


    The email autoresponder that you will receive should contain a link to the clone version of Form 2 (with URL parameters). Clicking the link will open also open the prepopulated clone version of Form 2 in the guide.

    If you make another submission in the clone version of Form 1 above, with different field inputs, you would still get the same Form 2 link, however, the value of the URL parameters will already be different. Loading that link will load the prepopulated Form 2 with different field values.

    May we know the form(s) you are working on so we can check it on end, please?

    Also, if in any case, I have misunderstood your concern, please feel free to let us know and provide us more details of the issue you are encountering.

    We will wait for your response.

  • Profile Image
    innovalinks
    Answered on October 04, 2017 at 08:04 AM

    Hello and thank you for your prompt response. Let me try and explain a little bit more what I am trying to do. Also, the form is in Spanish so I will try and explain as much as I can so you understand the form.

    The form I am working on is for internal use in our company, in which my customer support team submit a form (https://form.jotform.co/innovalinks/Bajadelinea) requesting the cancellation of a service.

    That form "BajadeLinea" sends an automated response email to the user and also a notification email to Admin Staffer. In that notification email I have included the URL to prepopulate another form with the basic information from the request (https://form.jotform.co/innovalinks/ConfirmacionBajaDeLinea) and in that second form the Admin Staff can change the status to either Confirmed or Rejected. Then, again the Customer Support user gets an email with their request status.

    Everything would be great, except for the fact that I cannot control the speed at which the requests come in and are answered, so if someone submits another "BajadeLinea or Form1" before we can fill "Conf..Linea or Form2" then I may have a logistical mess in my hands.

    If there is a way to point the prepopulation URL to copy the fields from a specific submission, then my job is a lot easier. If there is not currently a way, then I can omit the prepopulation of fields and just ask the Admin Staff to fill in a field with the Submission ID taken from "BajadeLinea or Form 1" into "Conf..Linea or Form2" and that way we have a way of tracking which requests have already been approved or rejected.

    Here is the URL I included in the notification emails:

    https://form.jotform.co/innovalinks/ConfirmacionBajaDeLinea?Solicita={Solicita1}&TipoDeLinea={tipoLinea}&TipoDeBaja={TipoBaja}&folio={folio1}&Cliente={Cliente1}&unidad={unidad1}&serie={serie1}&linea={linea1}&sim={sim1}&direccionIp={direccionIp1}&email1=email&NumSol={Id}

    I hope this helps you better understand my issue and if there is a workaround, please let me know. Thanks!

  • Profile Image
    Mike_G
    Answered on October 04, 2017 at 12:34 PM

    Thank you for explaining your concern further. 


    So far, below is what I understand:

    First, your Customer Support Team fill up Form 1 (https://form.jotform.co/innovalinks/Bajadelinea). I noticed that most of the fields in Form 1 are filled with the help of our Spreadsheet to Form widget.

    After Form 1 is submitted by your Customer Support Team, your users will receive an email autoresponder and your Admin Staff will receive an email notification based on the "Type of Line" selected ("Global SIM" or "Telcel")

    The email notification the Admin Staff receives has a link to Form 2 (https://form.jotform.co/innovalinks/ConfirmacionBajaDeLinea). The link includes parameters that will prepopulate Form 2.

    Then in Form 2, the Admin Staff can either select (Confirmed or Rejected). Once the Admin Staff submits the form, an email notification will be sent back to the Customer Support with the status of their request. And your users will also receive an email autoresponder as well based on the status of the request.

    If I'm understanding your concern correctly, the submissions can be easily identified by the Admin Staff since the email notification containing the request will be separate per submission made by the Customer Support. The link to Form 2 received by the Admin Staff thru email notification will be different from the others since it came from different Form 1 submission.

    I understand that you would like to utilize two forms for your processes, however, if you want to track each request whether it is approved or rejected, you may consider checking this guide when building an approval process workflow — A-General-Approach-on-Building-an-Approval-Process-Workflow

    If you use that workaround, when your Customer Support submits the form, the Admin Staff will receive an email notification containing the "edit link" of that particular submission submitted by the Custom Support. Also explained in the guide is a way to show/hide fields if the form is in edit mode. This way the "Approval field" will only be shown to the Admin Staff. Once the form is submitted by the Admin Staff, an email can be sent again to the Customer Support. You need to enable the "Send on Edit" option of the email notification which was also mentioned in the guide. Now, to easily identify if the request is "Approved" or "Rejected" you can update the email "subject" to include the "Status" field similar to how you can add Form Title as Email Subject — How-To-Add-The-Form-Title-On-The-Notification-Email

    If you have other questions or concerns, please feel free to contact us again anytime.