Hide Action if formula is true

HCL Domino Domino Forum
1

I’ve got a query regarding the formula needed for an Action button. I’m using the 'Hide Action if formula is true, formula window.

The button is a ‘Complete’ button on a Client form. I need the Complete button to be hidden if the ‘Status’ field is any of the following values;

“Awaiting Low Risk Confirmation” :

“Low Risk Declined” :

“Complete”

And if the ‘Subsidiary’ field isn’t equal to ‘No’ & ‘Subsidiary42’ field isn’t equal to Yes and the ‘ClientACScore’ is blank

I’m struggling with how the @If statement needs to be structured and which conditions need to come first

Any help would be very much appreciated as i’m new to Notes

Thanks in advance

2

Subject: Hide Action if formula is true…

Try this

(Status = “Awaiting Low Risk Confirmation” | status = “Low Risk Declined” | status = “Complete”) & Subsidiary != “No” & Subsidiary42 != “Yes” & ClientACScore = “”

3

Subject: Hide Action if formula is true…

Try something like this, break it into parts to simplify…

Hide1 := @Contains(Status;“Awaiting Low Risk Confirmation” : “Low Risk Declined” : “Complete”);

Hide2 := @If((Subsidiary != “No” & Subsidiary42 !=“Yes” & ClientACScore = “”);@True;@False);

Hide1 & Hide2

4

Subject: Hide Action if formula is true…

Try it like this:_statlist := “awaiting low risk confirmation” : “low risk declined” : “complete”;

_cond1 := @if (@isMember (@lowercase (Status); _statlist);

                      @True;

                      @False

            );

_cond2 := @if (Subsidiary42 != “Yes”;

                      @True;

                      @False

            );

_cond3 := @if (ClientAScore != “”;

                      @True;

                      @False

            );

_cond1 & _cond2 & _cond3

Hope it helps…

5

Subject: RE: Hide Action if formula is true…

Ups… I forgot the condition "Subsidiary = “No”…You can include that like the other ones…