Hi Janine,

Thank you for your purchase.

Sorry for the late response, we have some agents that have contracted Covid-19, so our team is cut in half.

1) You will need to create Editable table first. You can setup editing based on user role or if you need you can set Users can see and edit own data.

2) If I understand you you will need to have one column in table that have that categories and then you can set filters(selectbox,multiselectbox or checkbox) and client then can filter table based on category. You can see Advanced filtering.

3) Check out Users can see and edit own data link from 1). There you will need to provide user ID not username. Everything is explain how to create this table in video and text format in our docs on this link.

Let me know is this what you looking for.

Best regards

Hello Janine

I am sorry to disappoint you, but unfortunately, something like this is not possible with the plugin's built-in features.

The feature works using the currently logged-in user's user ID (from wp_users table in the database), and it can't be changed.

Hello Janine

The User ID is being pulled from your wp_users database table, and that table (by default) doesn't allow any duplicates in the User ID column.

If you have predefined values in a "User ID" column of an import you're referring to, then you could have an unlimited number of 1s or 14s in that file, since they would not be pulled from the database, but elsewhere.

Can you please show us what you mean in a few screenshots, or a screen recording?

Hi again Janine

The wdt_ID column is a unique, auto-increment column that is used for editing, deleting, and adding new rows - those are row numbers in there.

If the User ID column is not being populated automatically, that means that the column doesn't have any data in it, in the database, so you would need to either manually populate it before enabling the "Users see and edit only own data" feature, or join the wp_users table in your database, to fill in the required data based on other parameters.

Hi again Janine

There's a video about "Users see and edit only own data" on our documentation, but there's no video about how database tables handle data from wpDataTables.

All manual tables have a "wdt_ID" column. This column stores row IDs which are auto-incremented (1, 2, 3, 4, 5, 6, 7...). It is used for table editing, so without this column you cannot edit the table.

The user ID is being pulled from the database table wp_users, and it needs to be matched with a User ID column in your wpDataTable. So, when you create a table, if that table is imported, and already contains some data, you need to go into wp_users table in your database, and find the ID corresponding to the user from the table you're importing.

If all these users exist in the database:

They are stored with their email addresses. So, you need to edit the table, and in the User ID column, populate the ID next to the email of the user.

Hi again Janine

Since the data isn't pre-filled, you would need to manually associate each row to your users' IDs from the database.

If you create a new table, with a UserID column, and set that column to be a User ID column for "Users see and edit only own data" feature, once they add a row, their ID would be automatically populated in there.

Hi again Janine

That's good, but with this approach, if you're adding rows manually, you need to assign each row to a User ID. So if [email protected] has User ID: 4, you need to add "4" in the User ID column, in that row.

If you simply created the table, and leave it empty for other users to edit, once you enable the "Users see and edit only own data" feature, when they add a new row, the User ID will be automatically filled by the plugin. All you have to do is make sure this column is selected as the User ID column in the "Editing" tab above the table.