Validation rule: Consult_Lock_Submitted_status

Name

Consult_Lock_Submitted_status

Label

Consult_Lock_Submitted_status

Object

Assigned_Person__c

Active

Yes

Formula

AND(
NOT(ISNEW()),
System_Spending_Plan_Status__c = 'Submitted',
NOT(ISCHANGED(Spending_Plan_Owner__c)),
NOT(ISCHANGED(GAB_Approval_Request_Sent__c)),
NOT($UserRole.Name = 'Trusts Office (OGC)'),
NOT( $Profile.Name = 'System Administrator')
)

Error message

Only Trust Office users can update submitted Consultation records

Error location

Top of Page

Description

with the exemption of trust office roles, consultation is locked when SP status is submitted or review