Prevent old record editing for users with limited access rights
I have 2 access rights levels in my db - admin and manager, where manager has less rights.
How can i prevent a manager to change anything in an old record, for example of yesterday and before that?
I want him to be able to create and edit only today's records.
There are "fields" called 'Modified by', 'Modified on' and 'Created by' (and its alternative _md). To access them they have to included in a formula field. I don't think there's a 'Created on' (its alternative _cd wouldn't work for me).
To get over this and have full control of your set-up I would add a date field called DateCreated. Set the Default value to Today. In the Writable if section of the table have code along the lines of
userRole() = "admin" or DateCreated = today()
This will also have to be done for any child records as this alone will not prevent those from being changed.