You need to sign in to do that
Don't have an account?
![pooja chauchan pooja chauchan](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
restriction for user access by validation
HI Folks,
I have a scenario i.e, Whoever is created the record but that record users manager & system admin only edit the record based on Grade field. For this i implemented a validation, but its not working properly. So please suggest me.
AND(
OR(ISCHANGED( Grade_1__c ), ISCHANGED( Grade_2__c ), ISCHANGED( Grade_3__c )),
OR( $User.Id=$User.ManagerId )
)
Highly appreciated!!
I have a scenario i.e, Whoever is created the record but that record users manager & system admin only edit the record based on Grade field. For this i implemented a validation, but its not working properly. So please suggest me.
AND(
OR(ISCHANGED( Grade_1__c ), ISCHANGED( Grade_2__c ), ISCHANGED( Grade_3__c )),
OR( $User.Id=$User.ManagerId )
)
Highly appreciated!!
You can use below updated formula:
IF(OR(ISCHANGED( QnxSPM__End_Date__c ) ,ISCHANGED( QnxSPM__Start_Date__c )),IF(AND($User.Id <>Owner.ManagerId, $User.ProfileId <> 'SystemAdministratorProfileID'), true,false),false)Replace SystemAdministratorProfileID with Appropriate ID of System Admin Profile.
If this solves your problem, kindly mark it as the best answer.