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.
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
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.
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.
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.