I understand it's a holiday for you. Whenever you're back, can you tell me how to do the following:
I have a table with many columns. I would like to have tabs above the table to organize it better. Under each tab, a selected number of columns are shown. Except for the first column, which is common for all tabs.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
I am not sure if i fully understood the use-case scenario,
but for example, with our current default capabilities, we have the ability to allow users on front-end to have this 'Columns visibility' in the Table Tools settings on back-end table settings.
And if we allow that, there will be the button which users can choose to hide or show from the table's available columns.
And the list of table's available columns can only be changed on the back-end.
-
If i understood, you would like to have several tabs above the table,
and for example, the first column will be present in all variations;
but let's say in Tab 1 , if someone clicks it, it loads a table with columns 1, and 2.
On Tab 2, we click it, and it loads the same table, but with columns 1 and 3,
and so on, something like that?
-
We currently don't have any built-in solution to achieve something like this with the same table,
but i like the idea, so you can make a suggestion for our devs, and we will do our best to come up with a solution as soon as possible.
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
At this moment with our current built-in capabilities,
you can only make a workaround like this, with one "main Manual table" and multiple SQL Tables that will pull data from the source "manual table".
Check what is the SQL Table name for editing under Editing Tab of the Main table that has all the columns.
Then copy this table name, and make several SQL Queries for multiple tables,
each table for each tab.
-
Then, for example, SQL table 1 can have query like :
SELECT column 1,
column 2
FROM main_Table_Name
Then, SQL Table 2 ( for the second tab), can have :
SELECT column 1,
column 3
FROM main_Table_Name
and so on...
Then you would implement each individual SQL table shortcode for each tab on this page, and it should work.
You will have to make the tabs outside of our plugin, of course, on the WordPress page itself, with the page builder of your choice, for that part we are not able to provide support,
we are also not able to make SQL Queries for our users;
I hope that this helps to at least give you an idea what are the current capabilities and limitations.
Thank you Milos. Yes, that is a workaround to have multiple tables from one main master table under different tabs using WordPress and SQL queries table.
However, how can I have one common set of filters above for all these multiple tables? So if I filter something, it affects all these tabs? I mean I don't want to have separate filters for each table under each tab. Then when I change the tab, the previous filter won't be applied here. So ideally the filter needs to be a master one (even if the master table is hidden) and then the filters pass on or affect all these queried tables under each tab.
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
At this time, the only way how you can make a filter that can affect multiple tables on same page Is through a prefiltered URL that holds filtering parameters.
For example, if you use a prefiltered URL with a column filter,
and if you have multiple tables on page that have same header name for that column,
this URL filter will affect all tables on this page.
But i know that this is not what you need for the use-case, just wanted to mentioned that is the only way right now.
Let me know if you have any additional questions. Thanks
Hi,
I understand it's a holiday for you. Whenever you're back, can you tell me how to do the following:
I have a table with many columns. I would like to have tabs above the table to organize it better. Under each tab, a selected number of columns are shown. Except for the first column, which is common for all tabs.
Is this possible with CSS or something?
Thank you
Hi, Syed
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
I am not sure if i fully understood the use-case scenario,
but for example, with our current default capabilities, we have the ability to allow users on front-end to have this 'Columns visibility' in the Table Tools settings on back-end table settings.
And if we allow that, there will be the button which users can choose to hide or show from the table's available columns.
And the list of table's available columns can only be changed on the back-end.
-
If i understood, you would like to have several tabs above the table,
and for example, the first column will be present in all variations;
but let's say in Tab 1 , if someone clicks it, it loads a table with columns 1, and 2.
On Tab 2, we click it, and it loads the same table, but with columns 1 and 3,
and so on, something like that?
-
We currently don't have any built-in solution to achieve something like this with the same table,
but i like the idea, so you can make a suggestion for our devs, and we will do our best to come up with a solution as soon as possible.
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
At this moment with our current built-in capabilities,
you can only make a workaround like this, with one "main Manual table" and multiple SQL Tables that will pull data from the source "manual table".
Check what is the SQL Table name for editing under Editing Tab of the Main table that has all the columns.
Then copy this table name, and make several SQL Queries for multiple tables,
each table for each tab.
-
Then, for example, SQL table 1 can have query like :
Then, SQL Table 2 ( for the second tab), can have :
and so on...
Then you would implement each individual SQL table shortcode for each tab on this page, and it should work.
You will have to make the tabs outside of our plugin, of course, on the WordPress page itself, with the page builder of your choice, for that part we are not able to provide support,
we are also not able to make SQL Queries for our users;
I hope that this helps to at least give you an idea what are the current capabilities and limitations.
Thank you
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thank you Milos. Yes, that is a workaround to have multiple tables from one main master table under different tabs using WordPress and SQL queries table.
However, how can I have one common set of filters above for all these multiple tables? So if I filter something, it affects all these tabs? I mean I don't want to have separate filters for each table under each tab. Then when I change the tab, the previous filter won't be applied here. So ideally the filter needs to be a master one (even if the master table is hidden) and then the filters pass on or affect all these queried tables under each tab.
Does that make sense? This will be a huge help.
Thanks
Hi, Syed
Sorry for the delay.
Unfortunately, when it comes to filters included with tables,
we currently don't have any way to achieve for a filter from one table to affect the filters on other tables on the page.
It is a good idea for a future option, though, so you can suggest this to our devs.
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
At this time, the only way how you can make a filter that can affect multiple tables on same page Is through a prefiltered URL that holds filtering parameters.
For example, if you use a prefiltered URL with a column filter,
and if you have multiple tables on page that have same header name for that column,
this URL filter will affect all tables on this page.
But i know that this is not what you need for the use-case, just wanted to mentioned that is the only way right now.
Let me know if you have any additional questions. Thanks
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables