Question on using icons in view

HCL Domino Domino Forum
1

Hi,

I’m hoping this is a simple question, as it’s been giving me a headache (also new to notes development :slight_smile: )

I have a field on a form, say status, that can be one of four values. I want to have an icon in the view depending on what the status of the activity is.

I can only get it to work using two values:

@If(severity=“Urgent”;114;113);

But if I have four values (Urgent, Normal, Increasing, Decreasing) how would the formula do this? I’ve tried many variations that just dont work and the help isn’t all that clear.

Thanks!

Gary

2

Subject: Question on using icons in view

@If(severity=“Urgent”;114;severity=“Increasing”;117;severity=“Decreasing”;118;113);

Note: I have no idea what the icons for 117 and 118 are, but this is the syntax you need.

3

Subject: Still not working …Question on using icons in view

Thanks for the help,however, when I do use that formula, it doesnt work … I get only the first icon 114, and the last icon 113. I’m not getting the 117 and 118 icons… which I think is pretty wierd

Any further help is greatly appreciated!!!

Gary

4

Subject: RE: Still not working …Question on using icons in view

Take a good look at what’s actually stored in the documents. Remember that the last value (in this case, 113) is an “else”, so if your severity value doesn’t EXACTLY match the values you are testing in the first, second and third cases, it will get 113.

5

Subject: Thank You!!!

couldn’t believe it, but I checked and found the problem… an alias! (Jeez!!!)Removed it, and now the formula works great !!!

Thanks !!!

6

Subject: Try: @If(severity=“Urgent”; 114; severity = “Normal”; 113; severity = “Increasing”; 115; 116);