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

  • Profile Image
    Asked 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


  • Profile Image
    Answered on January 05, 2016 at 07:59 PM

    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:

    You can also generate a report such as the grid listing:

    Let us know if you need more help about this matter.