I am considering to purchase wpdatatables. However, I am looking for a functionality that I cannot find in the live demo version.
I would like to load all my user data from google sheets and show a table and a Apex Radial Bar Chart, only populated with data of the logged in user.
I already saw that I can select the function "allow front-end editing" and then select "limit editing to own data only". But this function does not help me completely. (1) it is not available if I upload my data from google sheets, and (2) I do not want the users to edit their data. I only want them to see their own data.
Can you explain how I can fix this in wpdatatables?
Yes, we have a workaround solution to achieve your use case of having a non editable table filter for logged user and to have the chart to follow the filter of the table.
1. First I will show an example for the table filtering.
We have a workaround for non-editable ( linked to a file source) tables,
to restrict only showing the rows for the currently logged-in user.
I will show you an examplw with a table linked from an Excel file, but you can use the same method for any non editable table.
- First, you would have to add a custom "user_id" column on the source Excel side, which you can hide if needed in our plugin from the front-end.
We will add a predefined filter value to it, using a Place Holder "Current User ID";
- Check that the filter type is set as "Text", as shown on this screenshot.
- Here is how an example table linked to a source file looks before we make any changes, with visible filters above the table.
And now, when we set the pre-filter, with Administrator logged in ( In our case, the user ID is 1), we only see rows matching that user ID.
- The user_ID filter is still visible, which means, if someone changes/deletes this value, they could see the whole table.
We will hide it from the front-end with some custom CSS added in the "Customize" section of the main table settings.
- It should be easy to do, depending on your knowledge of HTML and CSS.
You have to find the correct selector using the browser inspector tool, add the style "display:none" property to it, and it will disappear from the front-end.
On our example table, the custom CSS is :
#table_1_5_filter_sections {
display:none; }
- Now, the user_ID filter is gone from the front-end.
- Optionally, you can hide the user_id column from the front-end, if needed, either using the column settings tab or the "column list" button from the back end Admin area.
- If you need more details about this, don't hesitate to contact us further.
Hello,
I am considering to purchase wpdatatables. However, I am looking for a functionality that I cannot find in the live demo version.
I would like to load all my user data from google sheets and show a table and a Apex Radial Bar Chart, only populated with data of the logged in user.
I already saw that I can select the function "allow front-end editing" and then select "limit editing to own data only". But this function does not help me completely. (1) it is not available if I upload my data from google sheets, and (2) I do not want the users to edit their data. I only want them to see their own data.
Can you explain how I can fix this in wpdatatables?
Thanks in advance,
Bram van de Veerdonk
Hello,
Yes, we have a workaround solution to achieve your use case of having a non editable table filter for logged user and to have the chart to follow the filter of the table.
1. First I will show an example for the table filtering.
We have a workaround for non-editable ( linked to a file source) tables,
to restrict only showing the rows for the currently logged-in user.
I will show you an examplw with a table linked from an Excel file, but you can use the same method for any non editable table.
- First, you would have to add a custom "user_id" column on the source Excel side, which you can hide if needed in our plugin from the front-end.
We will add a predefined filter value to it, using a Place Holder "Current User ID";
- Check that the filter type is set as "Text", as shown on this screenshot.
- Here is how an example table linked to a source file looks before we make any changes, with visible filters above the table.
And now, when we set the pre-filter, with Administrator logged in ( In our case, the user ID is 1), we only see rows matching that user ID.
- (If you need more detailed information about using Place Holders in wpDataTables, here is our documentation about that https://wpdatatables.com/documentation/table-features/using-placeholders/);
- The user_ID filter is still visible, which means, if someone changes/deletes this value, they could see the whole table.
We will hide it from the front-end with some custom CSS added in the "Customize" section of the main table settings.
- It should be easy to do, depending on your knowledge of HTML and CSS.
You have to find the correct selector using the browser inspector tool, add the style "display:none" property to it, and it will disappear from the front-end.
On our example table, the custom CSS is :
- Now, the user_ID filter is gone from the front-end.
- Optionally, you can hide the user_id column from the front-end, if needed, either using the column settings tab or the "column list" button from the back end Admin area.
- If you need more details about this, don't hesitate to contact us further.
2. Now, to have the chart follow your table's filtering, you need to place the source table's shortcode on the same page with the chart, then in the chart settings enable " Follow table filtering" option (https://wpdatatables.com/documentation/wpdatacharts/follow-table-filtering-in-charts/).
Let me know if that helps.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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