2 Replies Latest reply on Mar 23, 2011 8:45 AM by philmodjunk

    Locking a record from new alterations



      Locking a record from new alterations


      Is there a way to lock a specific record to retain the integrity of htat record per a specific date. Currently I have a field that displays when a record was last modified, but I need to find a way to sign off on a record being complete and unaltered from ongoing changes. This is a HIPAA - related thing.

        • 1. Re: Locking a record from new alterations

          I too have a need for that. Once a record gets a certain status, I would like to be able to lock all changes to this record and it would become a history record.  We used to have a way to "greyout" certain fields or all on a giving screen (record)

          • 2. Re: Locking a record from new alterations

            You can use Manage | Security to lock records on a record by record basis that includes the value of a field in the record. You can define a number field, named Locked in your table. A script can set the value to 1. Then an expression such as:  Not Locked will control whether a user can edit the record or not. You can also set up expressions that compare a date field to Get ( CurrentDate ) to make the records lock on the basis of a date field. If you have a field called CreationDate, that auto enters the creation date, for example, you could use CreationDate = Get ( CurrentDate ) to limit access to the record to the day that it was created. (Playing games with your system clock, however, would allow a user to get around this lock.)

            See "Editing record access privileges" in FileMaker Help and check out this particular sub section: "Entering a formula for limiting access on a record-by-record basis" for a detailed description of how to set this up.