Conditional Expression - if not this or this then this

IFS((CONTEXT(“View”)=“Customers_Form” ), “Next”, (CONTEXT(“View”)=“Jobs_Form”), “Save Job”) returns Next or Save Job on the relevant views, but how do I make the third (default) option to be “Save” ie neither of the above conditions?

0 4 319
4 REPLIES 4

Use a SWITCH() statement.

Mr Bellave means something like…

SWITCH(CONTEXT(“View”),
“Customers_Form”,“Next”,
“Jobs_Form”,“Save Job”,
“Your text”)

Thats what I have done…

SWITCH(CONTEXT(“View”), “Customers_Form” , “Next”, “Jobs_Form”, “Save Job”, “Save”)

Thanks for your help.

Excellent!

Top Labels in this Space