Time Based record locking
FileMaker Pro 12
I am a total newbie and looking for a solution for the following:
We have a notes records inside a portal. Additional notes can be added to by users. Each note is a record contained 8 fields. Each note is time stamped on entry.
The requirement is to lock each note record in the portal to prevent data entry users from changing records in the future, but we wish to allow them some temporary to review and amend the record if they have made a mistake or want to correct spelling, grammar.
One idea is to leave the record editable for nn minutes and then have some script or trigger to lock the record to all but admin users after that time has expired.
I'm presuming various requirements for locking records come up all the time - is this suggestion viable or is there a better way of allowing temporary editing and subsequent locking