Hey everyone!
With the Labour Day holidays coming up, we’d like to let you know about our upcoming working hours:
Thursday, May 1st: Our team will be off during Labour Day.
Friday, May 2nd: We'll also be off for an extended holiday break.
We’ll be back on Monday, May 5th, ready to respond to all messages received during this time.
In the meantime, if you need help, feel free to:
-
Use the support widget on the bottom right of our websites (Amelia and wpDataTables) — our AI-powered assistant is available 24/7 and can help with many common questions.
-
Visit our documentation, articles, or YouTube channels for quick answers and step-by-step guides.
https://www.youtube.com/@AmeliaWordPressBookingPlugin/videos
https://www.youtube.com/@wpDataTables/videos
Thank you for being so understanding, and we hope you enjoy the long weekend!
Hi,
I'm relatively new to wpData tables and mySQL.
I would like to be able to build a WP page that uses the plugin so I can see some data points from our mySQL database. I would also like to be able to edit some simple data points in the data base from the WP page. Do need "front end" or "back end" edit capability of plugin for this?
What WP access level does this page need to be able to edit the DB?
"Admin" or would "Editor" be sufficient, or can I just do a password access for this page?
Will the "wpDataTables - lite" version support this?
Thanks,
Jorgen
Hello Jorgen
Thank you for your interest in wpDataTables.
First - you wouldn't be able to do this with the Lite version of the plugin, as SQL query based tables aren't included there. Also, in the Lite version you cannot edit any tables, only create tables linked to an existing data source, like Excel, CSV or Google Spreadsheet.
You would need to construct a query which will create the table pulling the data you need from the database. Then, you need to enable Editing, and define which user roles will be able to edit the table.
wpDataTables is a WYSIWYG (What You See Is What You Get) concept based plugin. This means that the table should look and behave the same both in back-end and in front-end, so if you allow editing, the table will be editable from both back and front-end.
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
Thanks Alex for reply,
After entering your sandbox site I found the difference btw lite and premium etc. You may want to publish this on your website (I could not find any info on this)
I'm still wondering about:
What WP access level does this page need to be able to edit the DB tables?
Would "Admin" be needed or would "Editor" access level be sufficient to be editing the wpDatatTables page I built in WP?
Thx,
Jorgen
Hi again Jorgen
Only administrators of your website can create tables, and they can decide which user role(s) will be able to edit that table from front-end:
So they can choose who will be able to edit the table.
Please note, though, that SQL query based tables that have JOINs and CONCATs cannot be edited properly. Our developers are working on resolving this, but at the moment it's a limitation.
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