can you pull information from another form depending on another fields info?

  • Kgr0up
    Asked on January 5, 2016 at 5: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

    thanks

  • Welvin Support Team Lead
    Replied on January 5, 2016 at 7:59 PM

    I think you can take advantage of our EDIT Link to achieve this in a form. Here's our guide for that:

    http://www.jotform.com/help/40-How-to-Let-Users-Update-Their-Form-Submissions-at-a-Later-Date

    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:

    http://www.jotform.com/help/351-How-to-automatically-pass-form-data-to-another-form

    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.