I know this should be really simple, but for the life of me can’t get it to work.
1.) I’m trying to display a check mark and X if a radio button with Yes or No is selected. Check = Yes and X= No.
2.) Made sure the two requirements where met, per Designer help:
You must select the column property “Display values as icons.”
You must use a column formula that results in a number that corresponds to the icon you want to display from the table of predefined icons, or you must enter the name of an image resource as the value for the column.
3.) My column formula is @If(Online != “Yes” ; 202; 203)
I can’t get the icons to change in the view if Yes or No is selected.
Thanks.
Subject: Displaying an icon in a column - Not Working
The values for a red cross and green tick are 81 and 82 respectively.
Subject: RE: Displaying an icon in a column - Not Working
True, I’m using different icons listed in the Table of column icons.
Subject: RE: Displaying an icon in a column - Not Working
The view icon table in Designer Help ends at icon 183, and your numbers are greater than that. Where did you get those icon numbers?
You can create image resources with names instead and use the image name instead of a number in the view column formula.
Subject: RE: Displaying an icon in a column - Not Working
I changed the icon images to 81 and 82 with the same results. I’ll try your suggestion, thanks Martha.
Subject: Displaying an icon in a column - Not Working
What if you test this:Set the formula to be just Online (the field name) and set the column to not show as icons?
Do you see “Yes” and “No” then?
Subject: RE: Displaying an icon in a column - Not Working
Karl,
that works with this code.
up:=“1”;
down:=“2”;
@If(Online = “2” ;up ;down)
What gives?
Subject: RESOLVED - Displaying an icon in a column - Not Working
Make sure the field you’re referencing is not set to ‘Computed for Display’. I set it to editable and it worked.
Thanks all!
Subject: Displaying an icon in a column - Not Working
Silly question: Is the value of your radio button really “Yes” / “No”? Or is it aliased to “Y”/“N” or 1/0?
-rich
Subject: RE: Displaying an icon in a column - Not Working
The value is set to “No”