IF formula with YES/NO parameters

[amirCKP]

Hi guys,

Is there any formula that I can turn on Main parameters, and at the same time, after turn on the Main parameter, I can choose to on which parameter that link to main parameter to be on or off. If I turn off the main parameter, all the parameter that link with main parameter will turn off too.

For example, main yes/no parameter is A and there are B, C and D with yes/no parameter link to parameter A.

If I turn on parameter A, I can choose either B, C or D to be on.

Then if I turn off parameter A, all B, C and D will be off automatically.

is it possible? or is it my explanation is to complicated. haha

thank you

[PavelAnd · Accepted solution]

Hi @amirCKP . Do you want to add conditions using API? If not, then such questions should be posted here.
As for your question, you can add additional parameters (result), as in the .gif below.

[TripleM-Dev.net · Accepted solution]

Hi,

As @PavelAnd shows below you will need additional "calculation parameters" to perform this.

But the formula can be simplefied.

A, B, C and D are the input Yes/No parameters.

A = Main (so if Off, B, C, D should also be off)

Calc_B = And(A, B)

Calc_C = And(A, C)

Calc_D = And(A, D)

So only if A and B are true, true is returned, otherwise it's always False (if both false, also false is returned)

- Michel

[amirCKP]

Hi @PavelAnd .  Im sorry. I am new here and Im not really sure what is API means. Btw thanks for your idea. It works prefectly! 😁.

Same goes to @TripleM-Dev.net . Thanks for the simplified formula. After a months think about the formula, finally I get the perfect solution to my problem. 😅.

[Albert.Maduro]

This is very useful