Hello Jake

Thank you for your interest in wpDataTables.

Depending on your server's performance and hosting plan, wpDataTables can handle tables with millions of cells. If you have a good hosting plan, and a good server, you would be able to use our plugin, but please note that tables that consist of millions of records will probably load much slower than smaller tables.

If the table is created using a simple query from a single table, like SELECT * FROM myDatabaseTable then you would be able to post that table on the front-end page, and have your customers search for any data in the table.

If you wish to hide the table before search or filtering is applied, you would need to purchase our add-on Powerful Filters as well, but if you don't need to hide the table before filters are applied, you don't need the add-on.

Hello again Jake

You could use filters for this, but I don't believe that's what you're hoping for to achieve.

Maybe the best approach would be to include placeholders and then provide the same table multiple times using different shortcodes.

For example, if a column consists of "Income Statement", "Balance Sheet", or "Cash Flow", you can add a predefined filter to that column %VAR1%.

Then, on one tab (using tabs carousel widget for example), you would add [wpdatatable id=1 var1='Income Statement']; in the other tab you would add [wpdatatable id=1 var1='Balance Sheet'], and so on.