You need to sign in to do that
Don't have an account?
ranga babu vangalapudi 2
how to restrict a user to edit a field only on friday
I want users to edit some particular field only on every friday,
For this i used following validation:
CASE( WEEKDAY(DATEVALUE(CreatedDate)),
2, ISCHANGED(Age_in_Years__c),
3, ISCHANGED(Age_in_Years__c),
4, ISCHANGED(Age_in_Years__c),
5, ISCHANGED(Age_in_Years__c),
NOT(ISCHANGED(Age_in_Years__c)))
but it is throwing an error: "Incorrect argument type for function 'CASE()'"
Can any one help me on this.
Thanks,
Ranga.V
For this i used following validation:
CASE( WEEKDAY(DATEVALUE(CreatedDate)),
2, ISCHANGED(Age_in_Years__c),
3, ISCHANGED(Age_in_Years__c),
4, ISCHANGED(Age_in_Years__c),
5, ISCHANGED(Age_in_Years__c),
NOT(ISCHANGED(Age_in_Years__c)))
but it is throwing an error: "Incorrect argument type for function 'CASE()'"
Can any one help me on this.
Thanks,
Ranga.V
Please use the following Error Conditional formula Which will throw error if you are making changes to Age_in_Years__c field other than on Friday
Thanks
All Answers
Try this below code:
AND(WEEKDAY(DATEVALUE(CreatedDate))=6,ISCHANGED(Age_in_Years__c))
If you find it positive then mark it best answer.
Thanks,
Jolly Birdi
Please use the following Error Conditional formula Which will throw error if you are making changes to Age_in_Years__c field other than on Friday
Thanks
As per your subject that you want to restrict user for friday update, then the below Code will help you out for this.
Please mark this as best if it resolve your problem.
Thanks,
Jolly Birdi