Hello Alex.

Thank you for your purchase.

You can create editable table where users can see and edit only their own data, as described in our documentation. If you follow the tutorial there, you'll see that in order for the admin to view all users' data, you need to create an admin table and use this one as user-editable.

You can set the Editor input type option of those static columns to None, so they won't appear in the edit modal. And only those 4 columns would still be editable.

So, if ISM_Order column is the one that "picks up" the unique user ID, then this looks ok, and you just need to configure the current table, so users can only see and edit their own data.

Please let me know if I understood what you meant correctly, and also if this helps.

Best regards.

Hello again Alex.

If I understood you correctly, this is what you mean:

Users have one table where they are able to see and edit only their own data, with 12 static columns that'd have Editor Input Type set to "None", so when they add new or modify existing content, they are only able to add 4 remaining columns.

Then, they'd have a different table which would simply display all that data to all users. Correct?

It might sound a little complicated, but please bear with me.

The best way to go about this would be to create a table that contains the first 12 columns, and use them as a Foreign Key in the first (user-editable) table. Now, since you say the data is static, and doesn't change for any user, I believe you only need one row, but the table has to have 24 columns in the database (PHPMyAdmin), so you can use the Foreign Key option (each column has to have an ID, so the Store Value of foreign keys would know what to compare the Display Value to).

Then, in the user-editable table you'd add relations to those first 12 (also 24 in total) columns from the previously created table, have a User ID auto-increment column, and add 4 more columns which will be editable by the user on front end.

The Foreign key columns don't have editing enabled by default, so users will only be able to modify those 4 remaining columns.

In the end, you need to create an admin table which would read all the data, and optionally disable editing for the whole table, so the users can only see what's in it.

Please go through the documentation and examples on both Foreign Keys and User Editable tables to get a better understanding of what I'm saying if, by any chance I made it too complicated.

Also, when viewing the documentation for User Editable tables, please look at the video, it explains how to view the content as admin as well.

Best regards.