We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
Hello, I have a series of doubts with the wpdatables plugin and I would like you to clarify it for me as I am interested in acquiring the lifetime version.
Could you create a table where one of the boxes is a dropdown with a query from another table? In plan in a field my_subjects I want it to show only the subjects that are in the subjects table and that kind of thing.
Also, would there be the possibility of having the same table writing several users? In the inventory table plan and that in that they could write several users and manage only one? Or that it is hidden among them but that the admin user could gather the data?
I know sql very well so that would not be a problem.
Thanks a lot.
Hi Ayoze
Thank you for reaching out to us.
If I understand correctly you want to create relational tables? You can use our foreign key feature to display data from another table in a column of the original table and set the filtering type to selectbox to have the dropdown menu.
Please have a look at our documentation for more detailed information about this feature
https://wpdatatables.com/documentation/front-end-editing/configuring-table-relations-foreign-key/
You can link data to specific users with our plugin. To do this the table needs to be editable (so you would need to import the file, to create a manual table), and also you need to have the User ID field in the table. Meaning, if John has user ID = 5, when he logs into your WordPress site, and looks at the table, he'd only see his data if you selected the User ID column as the "User ID column" in the Editing tab above the table. If there's no user ID column, and they aren't logging into WordPress, this will not work.
You can also add the placeholder %CURRENT_USER_ID% as the predefined filtering value in column settings of "User ID" column, and the table will automatically be filtered per the ID of the currently logged in user. You can enable the Show all rows in back-end option from the Editing tab of the table to see all entries in the back-end. You can also edit the table but if you edit the table as an administrator your User ID will be saved when you make the change so make sure to turn off the Users see and edit only own data option before editing.
Please see the video below
How to create editable tables in WordPress where users edit only own rows - wpDataTables 2.0
If you want to have a specific column shown for all users you will have to add user ID number 1 next to each one of the values in that column, then copy and paste the same row values below and add user ID number 2 next to them and so on for as many users as you have. You can use the Excel like editor to copy-paste the values so you wouldn't have to add them manually one by one.
You can set this column not to be editable by setting Editing to None, so the users will be able to add the data in the empty fields only.
I hope this helps, do let us know if you need any further assistance.