Forum Discussion

ChrisRyanUkChri's avatar
ChrisRyanUkChri
Qrew Trainee
9 years ago

Icon in field depending on another field value

HI all, newbie question here, and something i cannot figure out. I want to create a new field, but have it show a icon. But the icon will be different depending on another field for that entry. for e...
GauravSharma3's avatar
GauravSharma3
Qrew Commander
9 years ago
HI Chris,

Please create a formula text field and turn on the Allow some HTML tags to be inserted option in the field.

Use this formula:

Case([Field1],"red", "<img src=\"https://images.quickbase.com/si/16/227-rect_red.png\"; title=\"red\">", 
"blue", "<img src=\"https://images.quickbase.com/si/16/230-rect_blue.png\"; title=\"blue\">",
"green","<img src=\"https://images.quickbase.com/si/16/228-rect_green.png\"; title=\"green\">")

Please let me know if you need any further help.

Thanks,
Gaurav