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 322
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