I am trying out this plugin for the first time and it seems promising, but I have a few questions:
1. I want users to be able to see all entries/rows in the table, but only be able to edit their own on the front end. It seems like it's not possible to do this using just one table (as seeing and editing are linked) but, from a support thread on Envato it looks like it's possible to mirror one table to another and have different settings for each, such that the second table could be non-editable and show all rows. If I am right about this, could you tell me how I do this, as I haven't been able to work it out.
2. For the editable table above, which will only show one row, is it possible that the edit button would always be active - i.e. that the user wouldn't have to click on the row to make the button active (as there is only one row to edit). I think this would be less confusing for the user.
3. At the moment when I hide a column on the front end, it is also hidden on the back end, unless I use the excel view. Is this expected behaviour?
4. Making a column non-editable means that it doesn't show in the edit window pop-up on the front end. Is there a way of showing it in this pop-up, even though it wouldn't be editable? This would be helpful for my purposes.
I can only ask that you consider implementing the feature to see but not edit any row but your own.
In the meantime I have implemented the two table solution - one editable with just a single row and one not editable with all of the rows, but I still have the same question as Michael_Rieder. I want the second table, which takes the data from the same MySQL table, to auto refresh, but only when the editable table is actually changed - it is not feasible to use the autorefresh setting and to constantly see the rotating arrows. This part of Michael's question wasn't answered.
There would need to be a simple Ajax call to refresh the second table when the first table is edited.
The ideal solution would of course be a 'see but not edit' feature, but if such a change isn't feasible in the near future, what js would be needed to refresh a specific table id when an edit is made to another specific table id?
I still have the other questions from my original message.
1. Glad to see you found a partial answer for that question. Unfortunately, creating a script that would send out an admin-ajax call whenever one table is edited, so the other table will refresh itself would be considered custom work, and isn't included in the support of the plugin. You can, of course create it yourself if you know how.
The "see, but not edit" feature has already been requested, and it is on our to-do list. So it is expected in one of our future updates, but I cannot say if that will be any time soon, since there are a lot of new features requests, bug fixes, and general priority tasks they are currently busy with.
If you still haven't found a way to implement one table as "users see and edit only own data", and the second one as "view all data" (Admin table), please take a look at our documentation, and take a look at the video. It explains how you can create this admin table.
2. This would also be possible to achieve as a custom solution. Included support covers help with bugs and general inquiries for the plugin features, but not writing custom code. As you're developing some custom solution if you need our assistance we can offer you our paid customization service.
3. wpDataTables is a WYSIWYG (What You See Is What You Get) concept based plugin. This means that the table should look the same both in back-end and in front-end. So, if you want to hide a column only from front end, you can do it using CSS. Something like:
I am trying out this plugin for the first time and it seems promising, but I have a few questions:
1. I want users to be able to see all entries/rows in the table, but only be able to edit their own on the front end. It seems like it's not possible to do this using just one table (as seeing and editing are linked) but, from a support thread on Envato it looks like it's possible to mirror one table to another and have different settings for each, such that the second table could be non-editable and show all rows. If I am right about this, could you tell me how I do this, as I haven't been able to work it out.
2. For the editable table above, which will only show one row, is it possible that the edit button would always be active - i.e. that the user wouldn't have to click on the row to make the button active (as there is only one row to edit). I think this would be less confusing for the user.
3. At the moment when I hide a column on the front end, it is also hidden on the back end, unless I use the excel view. Is this expected behaviour?
4. Making a column non-editable means that it doesn't show in the edit window pop-up on the front end. Is there a way of showing it in this pop-up, even though it wouldn't be editable? This would be helpful for my purposes.
Thanks,
Nick
I can now see that one part of my question is answered here: https://tmsplugins.ticksy.com//ticket/1967301/
I can only ask that you consider implementing the feature to see but not edit any row but your own.
In the meantime I have implemented the two table solution - one editable with just a single row and one not editable with all of the rows, but I still have the same question as Michael_Rieder. I want the second table, which takes the data from the same MySQL table, to auto refresh, but only when the editable table is actually changed - it is not feasible to use the autorefresh setting and to constantly see the rotating arrows. This part of Michael's question wasn't answered.
There would need to be a simple Ajax call to refresh the second table when the first table is edited.
The ideal solution would of course be a 'see but not edit' feature, but if such a change isn't feasible in the near future, what js would be needed to refresh a specific table id when an edit is made to another specific table id?
I still have the other questions from my original message.
Hello Nick.
Thank you for your purchase.
1. Glad to see you found a partial answer for that question. Unfortunately, creating a script that would send out an admin-ajax call whenever one table is edited, so the other table will refresh itself would be considered custom work, and isn't included in the support of the plugin. You can, of course create it yourself if you know how.
The "see, but not edit" feature has already been requested, and it is on our to-do list. So it is expected in one of our future updates, but I cannot say if that will be any time soon, since there are a lot of new features requests, bug fixes, and general priority tasks they are currently busy with.
If you still haven't found a way to implement one table as "users see and edit only own data", and the second one as "view all data" (Admin table), please take a look at our documentation, and take a look at the video. It explains how you can create this admin table.
2. This would also be possible to achieve as a custom solution. Included support covers help with bugs and general inquiries for the plugin features, but not writing custom code. As you're developing some custom solution if you need our assistance we can offer you our paid customization service.
3. wpDataTables is a WYSIWYG (What You See Is What You Get) concept based plugin. This means that the table should look the same both in back-end and in front-end. So, if you want to hide a column only from front end, you can do it using CSS. Something like:
<style> td.column-column_name { display: none !important; } th.column-column_name { display: none !important; } </style>You would add this before the shortcode, when you're creating the page.
4. I am sorry to disappoint you again, but this would also probably be possible as a customization, but not with built-in features of the plugin.
Best regards.
Kind Regards,
Aleksandar Vuković
[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