Is it possible to make available for other Form data inserted in a Form

  • AlbertoCuozzo
    Asked on November 13, 2015 at 5:05 AM

    I'd like to know the best way you suggest to make availbale data inserted in a specific Form to all other Form that need of them.

    Thank you

    Alberto

  • Sammy
    Replied on November 13, 2015 at 7:23 AM

    Hello Alberto,

    You can pass data from one form to another via URL parameters.

    Here is the approach in summary.

    1. Copy the field tags of the field whose value you'd like to transfer from the first form, the tags can be accessed under the field properties.

    Is it possible to make available for other Form data inserted in a Form  Image 1 Screenshot 40

    2. copy your second form URL and construct the UR paramters fro prepopulating  using the following tool http://prepopulate.jotform.io/

    Kindly refer to this guide http://www.jotform.com/help/71-Prepopulating-fields-to-your-JotForm-via-URL-parameters

    e.g http://www.jotformpro.com/form/53152660302949?email={email3}&names={name1}

    The black parameter are the field tags on the second form while the orange ones are the tags of the first form

    3. Paste the above URL into your custom thank you page for the first form so that after submissions the user will be redirected to the second form with the specified parameters.

    Is it possible to make available for other Form data inserted in a Form  Image 2 Screenshot 51

    Is it possible to make available for other Form data inserted in a Form  Image 3 Screenshot 62

    http://www.jotform.com/help/211-Setting-Up-the-Thank-You-Page

     

     

     

     

     

  • AlbertoCuozzo
    Replied on November 13, 2015 at 8:27 AM

    Thank you very much Sammy for your prompt answer.

    This will be useful for my work surely.

    I think I need to clarify better my question anyway.

    What I mean is for istance if I use the Address Form where I write:

    - Field 1 Name

    - Field 2 Address

    This is my Dental Office Hierarchy

    Suppose now I have to visit each Dental Office for business reason and I use for that the Visit Form. In this I have:

    - Field 1 Name

    - Field 2 Address

    This is my Visit Repository

    Of course I'd like to get info coming from the Address Form and I'd like to handle the following:

    - See the name previously type in Address form in order to choose what I need

    - See the linked Address in the proper field.

     

    Is it posible?

    Thank you one more time

    Alberto

  • Kiran Support Team Lead
    Replied on November 13, 2015 at 10:39 AM

    I'm not sure if I understand your question correctly. But it looks that you are looking for the same thing that our colleague Sammy has already provided. To understand much better, I've created a demo form for you. Please check the form and let us know if you are looking for a different one.

    Link to Address Form : https://form.jotform.com/53164378877975

    Link to Order Form : https://form.jotform.com/53164144403951

    The order form will be redirected automatically after submitting the Address form pre-populating the Name and Address field data from Address form.

    You may try submitting the Address form and see how the data will be transferred to Order form.

    Please let us know if you are referring to something different. We will be happy to help.

     

     

  • AlbertoCuozzo
    Replied on November 13, 2015 at 11:09 AM

    Hi Kiran.

    That you show is correct in the case I want to type an order immediately after typing and Address.

    But imagine I want to type an order after typing 100 Addresses selecting the name of one of them directly in the field NAME in the order Entry form.

    What to do in this case?

    Thank you

    Alberto

  • Charlie
    Replied on November 13, 2015 at 12:44 PM

    From what I understood, you would like the data collected from "Address" form to be readily available in your "Visit" form.

    Let's say you filled out 100 submissions in your "Address" form, now in your "Visit" form, you want to fetch existing submission from the "Address" form and populate it in your "Visit" Form, is that correct?

    Unfortunately, there is no easy way for this, here are the approach that I can think of:

    Method 1:

    Store the submission data captured by "Address" form to your own database. You can do this if you are familiar with send POST Data, PHP and MySQL. Here's a guide about it: http://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP 

    Now the data is in your database, you can easily prepopulate the "Visit" form based from the records you have in your database. However, you'll need to develop your own PHP script for this or hire a developer.

     

    Method 2:

    You can embed your form on a page and use API to fetch submission data of "Address" form to your "Visit" form. Here's our API page: http://api.jotform.com/docs/#submission-id 

     

    Both methods require a developer or knowledge in programming. I hope that helps.