Pulling data from one table to populate another?

  • Resolved website044

    (@website044)


    8 years, 10 months ago

    Hello,

    Is there a way to populate fields from one table into another. For example, have a long master list of restaurants and have categories in that master list like “pasta” or “steak”…. then on table 2, have it load anything on master list with that category of ‘steak’?

    The goal would be to have that ‘steak’ table never need to be updated should the master list/table have anything added or changed steak related.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter website044

    (@website044)

    8 years, 10 months ago

    Oh, and i have one more question aside from the above, so if you could answer both. It is related, so I didn’t want to create a second topic, but I would love to have them answered separately.

    Question 2: Can a link be used to load a table with a search term entered, thus only needing to use one master list/table but have a link load the table so that only ‘steak’ is typed in and this way I wouldn’t need secondary tables to load data from the master table. Even if in the embed code for that table, can code inside the embed table code make that table search by ‘steak’ upon loading? Thanks.

    • This reply was modified 8 years, 10 months ago by website044.
    Plugin Author Tobias Bäthge

    (@tobiasbg)

    8 years, 10 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    This sounds like a good use case for the TablePress Extension from https://tablepress.org/extensions/row-filter/
    You would basically filter your master table for the desired individual category and get the desired smaller table.

    For that link, you could basically employ the idea from https://wordpress.org/support/topic/search-from-another-page/ (which uses another Extension to extend the filtering via a URL parameter).

    Regards,
    Tobias

    Thread Starter website044

    (@website044)

    8 years, 10 months ago

    Amazing! Worked! Thanks so much. I have donated before, a few years ago, but I plan to again here shortly. You are awesome, best support ever, too!

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    8 years, 10 months ago

    Hi,

    no problem, you are very welcome! 🙂 Good to hear that this helped!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Pulling data from one table to populate another?’ is closed to new replies.