firstly i would like to check my understanding. im correct that each user gets his own input field i.e if user X puts a record into the field only he can see it?
secondly is there a way one user can have visibility of all these?
Yes you are right, each user can change the value and it is limited to them, other users cant see it.
I dont think so there are any ways to get those values from all users
i would of thought as an administrator of the system i could see what others are doing within the system even if its a tool outside of the application itself.