redballoon Posted January 20, 2008 Share Posted January 20, 2008 How do you lock a record ? say after 2 weeks you want to lock a record how do you do that ? Link to comment Share on other sites More sharing options...
redballoon Posted January 20, 2008 Author Share Posted January 20, 2008 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... Link to comment Share on other sites More sharing options...
redballoon Posted January 24, 2008 Author Share Posted January 24, 2008 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 . Link to comment Share on other sites More sharing options...
aholtzapfel Posted January 24, 2008 Share Posted January 24, 2008 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. Link to comment Share on other sites More sharing options...
redballoon Posted January 24, 2008 Author Share Posted January 24, 2008 Good pointer, Thanks... could the host be any machine holding the files not necessarily a Filemaker Server just a shared file using filemaker sharing ?? Link to comment Share on other sites More sharing options...
aholtzapfel Posted January 25, 2008 Share Posted January 25, 2008 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. Link to comment Share on other sites More sharing options...
Newbies aufatsee Posted February 7, 2008 Newbies Share Posted February 7, 2008 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5946 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now