Hello Peter

Thank you for your interest in our plugin.

If I understood you correctly, you have a table with multiple columns, but you only wish to enable your users to enter the details in one of those columns, and not even see the other columns, right?

If this is true, this can only be done with a workaround.

1. You'll need to have the main table with all columns, but this table should either be coming from the database, or manually created (so it is created in the database).

2. Create an SQL query based table where you would query the original table, but only the first column.

This table would be editable, and displayed on the front, so users will see the SQL Query based table, with one column, and be able to edit it, and all the changes will be shown in the original table as well.

Best regards.

I see Peter.

The thing about this is that users would need to enter 10 rows, and our edit and new modals offer editing one row at a time.

To prevent users from seeing other users data is easy to do. Simply follow the documentation about "Users see and edit only own data" feature, and you could do this without any issues.

Best regards.

Hi Peter.

It sounds like the columns in the table don't have an editor input type defined. You need to open each column's settings, and go to "Editing" and choose the input type there:

Also, could you share the page where the table is with me, so I can take a look?

Best regards.

Hello Peter.

The issue here was that you enabled the "Users see and edit only own data" feature, and assigned the wdt_ID column to be the user ID column:

After I disabled that, the table was editable on front end.

If you wish to use this feature, you need to create a new Integer column; name it ID (for example), and then enable this feature and select that new column under "User ID Column".

"wdt_ID" column is an auto-increment column which is automatically created with manual tables, and is assigning row numbers. It cannot be set as User ID column.

Best regards.

Hey Peter.

No worries, I understand. That's why we're here - to help.

You set the "ID column for editing" to be "userid". I changed it back to wdt_ID:

That's why the plugin modified the editable column to be "wdt_ID".

You only needed to change the "User ID column":

It should work fine now. The editable column is "My Promises", "wdt_ID" is the auto-increment row column, and "userid" is the user's ID column for "Users see and edit only own data" feature.

Best regards.

Hi Peter.

Please stop making changes to the Editing settings

You made it like this now:

"ID column for editing" needs to be wdt_ID, and "User ID column" is good.

Also, "userid" column cannot have the editor input type set to "none". When you enable the option so users see and edit only own data, that column will not appear in the edit or new entry modals, and your users will be able to enter data only in "My Promises" column.

I have enabled the option so you can see all rows in the back-end:

I hid the User_ID column from front end, and tested the table - it works now:

I deleted that row, so you can continue testing. It should all work now, just leave the editing settings as they are, and of course if you have any questions, please feel free to ask.

Best regads.

Hi Peter,

Aleksandar is on vacation and I will answer you.

I am glad that you are happy with our plugin

Yes you can ask it here.

Best regards.

Hello again Peter.

You can add some conditional formatting to the column, so it is set to something like this:

This will hide the rows where that column's selectbox is set to "completed".

If this is a manual table, you can create a new SQL query based table with a query like this:

SELECT * FROM wp_wpdatatable_1
WHERE activity = 'completed'

This would pull all data from "wp_wpdatatable_1" where "activity" column has values of "completed".

To add a filter which would show completed tasks over a time period, you'll need to add a time period column, but I don't believe you'll be able to choose "last month" or something similar. If that new column is set to be date, you can add the date range filter.