How do you lock a record ?

say after 2 weeks you want to lock a record how do you do that ?

Looks like in

Record Priveleges >

I have set this calculation on the edit option

( creator = Get(AccountName) ) and ( date Entered + 13 ≥ Get(CurrentDate) )

Which I believe will work...

OK I finally got this working the only way I could lock a record after 14 days is to use this calculation...

date Entered > Get ( CurrentDate ) -13

date Entered being a value inserted into the field date Entered when the record is created, this is a non modifiable date set using the Field Options.

I hope that helps some people .

warning - using the Get(CurrentDate) gets the date from the local computer and if the user has the ability to change the date/time on thier computer they could access anything they want to by ajusting it. If the file is hosted using a FM server you might be better off to use the Get(CurrentHostTimestamp). That would be pulled from the server and the end user would not have any access to it. Additionally, if the PRAM battery in the computer goes bad (and they do once in a while) it could also cause unexpected results.

Good pointer,

Thanks...

could the host be any machine holding the files not necessarily a Filemaker Server just a shared file using filemaker sharing ??

I believe (I don't normally run files this way) that the host time stamp will come from whatever computer Hosts the files, even if it is not done with an FM_Server App.

Hi, notice that the "timestamp for host" does not applicable to "Auto-Enter" - modification.

Is there any better way to do so ?

Thanks a lot.