What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
can you pull information from another form depending on another fields info?Asked by Kgr0up on January 05, 2016 at 05:03 PM
I organize events, and I am making a form where we register hotel, plane and local transportation for attendees, however, consider some might buy a plane ticket and make changes, so,
1.for accountig reasons, I need a list where I can register ALL plane tickets
2. I need a second list where I can have the latest plane ticket updated depending on the tkt number together with hotel and local transportation.
I guess what I would want to do is, once I buy the plane tkt, fill the plane´s form and using the tkt number as the id field, prepopulate the second form.... and if there is a change, edit de submission by changing the tkt number hopint it would pull the new tkts info...
Hope I made my self clear and hope this can be worked
I think you can take advantage of our EDIT Link to achieve this in a form. Here's our guide for that:
The idea is simple, you'll get the original data through the form notification email. Once someone will edit their data, you will receive a new email containing the changes. The only downside on this steps is that you will need to manually compare the two data.
If you simply want to pass the data from the first form to another form right after submission, you can use this workaround:
This is a bit technical so if you are confused, let us know here so we can explain further.
Now, if you want a list of submissions of the two forms, you can integrate with Google Spreadsheet: http://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet.
You can also generate a report such as the grid listing: http://www.jotform.com/help/105-How-to-create-a-Grid-Listing-report.
Let us know if you need more help about this matter.