Lock Records if creation date more than a month

[Ismail AlAbdulmohsen]

Hello; can I Lock Records if creation date more than a month so user can not edit the record and can only browse it?

[comment]

In users' privilege set, select 'Custom privileges…' for Records access, then select 'limited…' for Edit privileges in the relevant table. Use a formula like:

Get ( CurrentDate ) - CreationDate < 30

as the calculation. Of course, you need to have a CreationDate field that auto-enters the creation date for this.

 

Edited December 7, 2019 by comment

[Dr.Gopala krishnam raju AMBATI]

7 hours ago, comment said:

In users' privilege set, select 'Custom privileges…' for Records access, then select 'limited…' for Edit privileges in the relevant table. Use a formula like:

Get ( CurrentDate ) - CreationDate < 30

as the calculation. Of course, you need to have a CreationDate field that auto-enters the creation date for this.

 

IS this same formula can be applied with layoutenter script trigger

[Wim Decorte]

Yes, but triggers are layout specific so if you forget to cover one place where one of its fields exists...

Using Record Level Access in the privileges is a much better solution.

[Ismail AlAbdulmohsen]

Thanks and working ok, how can I change the message that will come to user when he try to update an old record?

[comment]

On 12/8/2019 at 5:49 PM, Ismail AlAbdulmohsen said:

how can I change the message that will come to user when he try to update an old record?

I don't know a really good way to do this. The best that I can think of is attach an OnLayoutKeystroke script trigger to the layout, with a script that does something like:

If [ Get ( AccountPrivilegeSetName ) = "Users" ] 
  Beep
  Show Custom Dialog [ "Your message" ]
  Exit Script [ Result: False ] 
End If

However, you will still get the standard access privilege error message if, for example, you drag and drop into a field.

 

Edited December 10, 2019 by comment

[comment]

On 12/8/2019 at 4:12 AM, Dr.Gopala krishnam raju AMBATI said:

IS this same formula can be applied with layoutenter script trigger

No, because you still want users to be able to browse the records.

 

[Fitch]

If you want security triggers, vote:

https://community.filemaker.com/en/s/idea/0870H000000fyNHQAY

[Ismail AlAbdulmohsen]

On 12/10/2019 at 1:54 AM, comment said:

I don't know a really good way to do this. The best that I can think of is attach an OnLayoutKeystroke script trigger to the layout, with a script that does something like:

If [ Get ( AccountPrivilegeSetName ) = "Users" ] 
  Beep
  Show Custom Dialog [ "Your message" ]
  Exit Script [ Result: False ] 
End If

However, you will still get the standard access privilege error message if, for example, you drag and drop into a field.

 

Hello; I'm using this function in the Access see attached, so how can I resolve it;

[comment]

On 12/11/2019 at 7:03 PM, Ismail AlAbdulmohsen said:

I'm using this function in the Access see attached, so how can I resolve it;

Not sure what your question is.

Edited December 12, 2019 by comment

[Ismail AlAbdulmohsen]

On 12/13/2019 at 1:26 AM, comment said:

Not sure what your question is.

Hello; I'm using this { Get ( CurrentDate ) - CreationDate < 30} in the Custom Record Privileges as calculation for limited access so the user can not modify the record if it is more than 30 days since created.