How to get Data from other form tables.

  • kmedley96
    Asked on August 10, 2022 at 10:27 PM

    I watched the video on how to create multiple payment options and did that. The problem is that I can't generate one report with all entries that show the payment method. I have cash, check, and credit card. So, depending on their payment type, its funneling to one of the three instead of every registration going into one form. Is there no other way to get every entry into one form?

    Jotform Thread 4255138 Screenshot
  • Kim JotForm Support
    Replied on August 11, 2022 at 2:33 AM

    Hi Kristie,

    Thanks for reaching out to Jotform support. You can actually connect your submission table to another submission table from another form. This guide will show you how to do that. It's easy, let's do it:

    1. Click the Add Tab button in Jotform Tables.
    2. Select Tables then click Next.

    tables add tab min Screenshot 10You can also choose any of the other tab styles.

    3. Now, choose Connect to Form then click Next.

    tables create view connect form min Screenshot 214. Afterward, select the form then click Next.

    tables create view select form min Screenshot 325. Check the Select all box then click Create.

    tables create view select all min Screenshot 43You can also drag and drop the fields that you want in your new view.

    A new tab will appear and you can now view and manage the connected form’s data in the new tab — all changes to the entries will reflect in the connected form’s records.

    tables new contact form tab view min Screenshot 54
    Give it a try and let us know how it goes.