No, it’s not wrong. With shared tables, each user will see their own (same) version of user specific data in each App.
But maybe you are misunderstanding how User Specific data works?
User Specific does mean exactly what it says. As an admin (or any other) user, you have no way to see the user specific data of other users. If that is what you were expecting, then no, that won’t work.
Okay, so another option could be to store a list of UserID’s in a column in your CheckList table. Each time a user completes an item, add their ID to the list. The list could either be a Joined List (comma-separated), or an Array. An array is probably easier to manipulate. In fact you could use the Multiple Files column for this purpose (I know this, because I have). To add to the array, use a Make Array column. And to remove from the array, use a Remove Element column.
Yes, use a combination of computed columns and actions. You need three columns:
A Multiple Files column. Ensure it is not user specific.
A Make Array column. This one takes two inputs:
– The Multiple Files column
– The signed in Users UserID
A Remove Element column. This also takes the same two inputs (removing the signed in Users UserID from the multiple files column)
When a user marks an item as complete, use a Set Column Values action to write the value from the Make Array column into the Multiple Files column.
And if they need to do the opposite, do the same with the Remove Element column.
To get a list of completed tasks per user, create a multiple relation column in your Users table that matches the UserID with the Multiple Files column in your Checklist/Tasks table.