Hello Reader ,
My requirement is that I want the Approval Section i.e Approval of Approver column which has two values YES/NO โฆI want this field/column non editable in the โRejected Requests_Formโ view in my app otherwise in other views it should be editable โฆ
Could anyone suggest me the expression that will satisfy my requirementโฆrequirement is I want โApproval of Approverโ Field/Column to be non editable in the โRejected Requests_Formโ view in my app , it should only show whatever value/status that is earlier has been set by or in other view โฆ
Please help me with this
Please use CONTEXT() functions.
Please use in the column [Approval of Approver] columnโs Editable_if setting, an expression something like
CONTEXT(โViewโ)<> โRejected Requests_Formโ
Or, if the user is editing that field in some other view(s), it is better to use the equality operator as shown below
CONTEXT(โViewโ) = โApprove Requests_Formโ
or there are two such views
OR(CONTEXT(โViewโ) = โApprove Requests_Formโ, CONTEXT(โViewโ)= โReview Requests_Formโ)
Hello Sir , I tried using NOT(CONTEXT(โViewโ) = โRejected Requests_Formโ) this expression before your reply and it is working fineโฆshould i change or no?
No, not necessary to change. Generally, equality operators are a better option than non-eequality operators. Logically both will work.
Thank you for the help!
Sir now i want that coulmn/field to be non editable in two views of the app namely โRequests Approved_Formโ and โRejected Requests_Formโ. I tried using OR(CONTEXT(โViewโ) <> โRejected Requests_Formโ , CONTEXT(โViewโ) <> โRequests Approved_Formโ) but its is not working and not giving the desired outputโฆit is only working in i have single view condtionโฆwhat soultion should i go for please suggest
Please try using AND() instead of OR() and please revert if AND() works instead of OR()
AND is working sir thanksโฆbut why did OR did not work could you please tell me in short if you can , thanks!
Sure. With OR(), even if the condition is met for any one of the two CONTEXT() arguments, the expression evaluates to TRUE. And one of the two views or both the views will always not be there. So OR() always evaluates to true. With AND() , the expression evalues to true only if both the arguments , meaning both those views are not there.
got you sir thanks for this!
For reference:
User | Count |
---|---|
25 | |
24 | |
24 | |
20 | |
16 |