Holiday Notice – Support Unavailable on April 18 and April 21
We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!
In the meantime, if you need any help, feel free to:
-
Use the support widget in the bottom right corner on our websites (Amelia and wpDataTables) — our latest AI-powered assistant is there 24/7 to help with basic and intermediate questions,
-
Browse our detailed documentation (Amelia, wpDataTables)
-
Explore helpful articles,
-
Or check out our YouTube channels for video guides!
Amelia YouTube Channel
wpDataTables YouTube Channel
Thank you for your understanding, and we wish you a wonderful holiday weekend!
Hi, I'm testing out the sandbox version of wpdatatables, and I want to find out if its possible to set up tables where users are only able to see their own data. I know there's a setting for users to see and edit their own data, but is there a way for them to see their own data without being able to edit it?
Also, instead of identifying users based on user id, is it possible to identify users based on email address?
Thanks.
Hello Ezekiel
Thank you for your interest in our plugin.
If you want the users to be able to see their own data and add a new row, you can simply select only the "New Entry" button for the front-end:
If you want to allow them only to see their own data, a better approach would be to create a MySQL query-based table generated from the original table. Since the table has to be a database table (so, manual, MySQL query-based, or imported), you can see its database name in the "Editing" tab above the table, in the "MySQL table name for editing" section:
So, then, you would create a new MySQL query-based table with a query similar to this:
This will make the plugin compare the email column with the currently logged-in user's email address.
Please note that your email address needs to be in the table in at least one row in order for you to be able to save this table.
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