I am sorry to disappoint you, but unfortunately viewing and editing only own entries is a "package" so to speak. If you enable this feature, the user will be able to only view his own records. You can create a new table using the one they can edit, and make it non-editable, so they're only able to see the rows.
For example - you have a table ID=1 where users can view and edit only their own entries.
Then, you can create a MySQL query based table by querying the same database the first table was created from. Then, when you disable editing for that new table, let's call it ID=2 and put it on the same page, the users will be able to see all records.
You can see how to do that in the video in our documentation, around 03:15.
Thanks for your introduction. I implemented your recommended solution. The only issue is that if the user adds or modify his data in table ID=1 the table ID=2 didn't refresh automatically.
I set the autorefresh but this triggers the spinner for table ID=2 every second (which I don't like).
Is there any other solution to refresh the table ID=2 once?
Hi
Is it somehow possible that the user edits his own data but see all entries of the table.
Best Regards
Michael
Hello Michael.
Thank you for your purchase.
I am sorry to disappoint you, but unfortunately viewing and editing only own entries is a "package" so to speak. If you enable this feature, the user will be able to only view his own records. You can create a new table using the one they can edit, and make it non-editable, so they're only able to see the rows.
For example - you have a table ID=1 where users can view and edit only their own entries.
Then, you can create a MySQL query based table by querying the same database the first table was created from. Then, when you disable editing for that new table, let's call it ID=2 and put it on the same page, the users will be able to see all records.
You can see how to do that in the video in our documentation, around 03:15.
I hope this helps.
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
Hello Aleksander
Thanks for your introduction. I implemented your recommended solution. The only issue is that if the user adds or modify his data in table ID=1 the table ID=2 didn't refresh automatically.
I set the autorefresh but this triggers the spinner for table ID=2 every second (which I don't like).
Is there any other solution to refresh the table ID=2 once?
Best Regrads
Michael
Hi Michael.
Well, if you keep the refresh interval blank, it should automatically update on each page load (or refresh).
So, once the record has been updated, it should pull the data from the database if you passed it correctly.
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