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?
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!
User | Count |
---|---|
33 | |
30 | |
30 | |
19 | |
17 |