How can I make the entries from one form populate the options on another?

In other words, I have an event where people can register to host the event (form one) and then on form two, people can register to attend the event. On form two, the options for locations to attend the event are populated from the entries into the database on form one. Does that make sense and is that possible?

Here's how it needs to work for the user on form two:

First they type in their zip code and the venues that registered to host an event on form one with that zip code would appear. 

Next they select the venue where they want to attend the event.

Then if that venue has a luncheon option, they will be asked if they will attend a lunch. They will also be given other information about the venue (like parking) that the venue provided on form one.

When they're done, they'll be asked if they want to register another person or complete the registration.

Any info you can provide would be extremely helpful. Thank you!

Hi,

This is how I understand the process.

There are two kinds of users. User 1 is someone who want to host an event, so he/she fills out Form 1. User 2 are those people who want to attend the said event, they will fill out Form 2 for that.

Unfortunately, Form 2 can't fetch data from Form 1, unless you manually input the the submission details of Form 1 to Form 2 and set the conditional logic for it. Example, all the venues or zip code that were submitted in Form 1 will be manually inputted in the conditions or list of events of Form 2. But that's that not efficient and would defeat the purposes of automation. 

What I can think of is that you need to have a website with a database. This is how I will design it.

1. First, Form 1 will send the hosting event details to a database using PHP. Here's how: https://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP.

2. The data will then be stored in your MySQL database.

3. You'll need to embed Form 2 using the default script code or the form's full source code in your website page.

4. In your website page, you can use PHP to fetch data from your database and output it to your Form's 2 code. 

For the other functions you are looking like showing options for luncheon or if they want to add another person, that could be done using conditional logic or using our widgets that allows multiple entries.

I hope that helps. Do let us know if you need more information on this.

I think this is a very sensible question. Using date from previous submissions in workflows is core to how many businesses operate. After all a client gives you some data and if you don't do anything meaningful with it what's the point.

It is in this area where JotForm is not at its strongest - nor are its competitors at least those I looked into. To be more specific, yes you can get to the data and you can report on it or use apps or connectors to put it somewhere else. But what you can't do out-of-the-box feed it back into JotForm forms.

I discussed this a bit towards then end in my comment on this https://www.jotform.com/answers/626784-Possibility-to-have-global-properties-in-my-forms.

To the specific problem another solution not requiring your own MySQL database would be to use the JotForm API to feed data into your form. You still need to host the form on your own web site and you will run into obstacles with feeding the data into your form because JotForm uses iframes and they are loaded from a different domain than yours so XSS prevention will get in your way. The same applies to the solution proposed above. So your only solution is to host the full JotForm source code on your own site and update it each time you make a change in JotForm. Not a very robust process and you need your own web site (most business will have that though but most likely hosted with some other service provider not in house).

Another big barrier is that you also need to be savy with JavaScript, AJAX, etc - so nothing someone non techical can really do. And if JotForm changes their JavaScript it is likely that your data injection JavaScript will break as a result. Again, not very robust.

Bottom line - JotForm - please let us use our data in our forms in an easy manner.

I do realise that this would move JotForm along from being just a simple form builder / form submission handler to provide some workflow support. But my view is that there would be a captive market for that out there and it would make the product even more attractive.

Cheers

@tbawa

Thanks for your reference but I don't think this relates to the user question. Anyway, your question has been handled on this thread https://www.jotform.com/answers/62678 and I can see that it has been submitted to our higher ups as a feature request. If you have any further concerns about it, we suggest to post it on this thread to avoid confusions. 

Thanks for your understanding!