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 example;

Field1 Field2
red shows image from example url1 https://images.url.com/red.png
blue shows image from example url2 https://images.url.com/blue.png
green shows image from example url3 https://images.url.com/green.png

So when looking at the first line, the field2 will show a red icon, as the field1 text matches 'red'

hope that makes sense, thanks.

ChrisRyanUk

120 Points

Posted 2 years ago

2 years ago

Gaurav Sharma

5,882 Points

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

Comment

2017-04-05T08:25:05+00:00

Ⲇanom the ultimate (Dan Diebolt), Champion

29,604 Points

Get in the habit of putting formulas within a <pre> tag:

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\">"
)

(Edited)

2017-04-05T08:28:28+00:00

Gaurav Sharma

5,882 Points

Thanks Dan, I'll make sure next time :)

2017-04-05T10:16:28+00:00

Ⲇanom the ultimate (Dan Diebolt), Champion

29,604 Points

The forum will not let me edit my prior post (this is really annoying) but I intended to replace the escaped double quotes with single quotes and remove the errant semicolon in the formula. Let me try again:

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'>"
)

As well as post a version that does not even use single quotes on the attributes:

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>"
)

FWIW, because I placed these formulas within <pre> tags I have some scripts that can automatically extract formulas posted to the forum and place them into a formula corpus application. When you start looking at 1000s of QuickBase formulas in a table rather than working with formulas individually a lot of patterns emerge which helps understand the characteristics of good and bad formulas. Perhaps a byproduct of this effort will be to write up a best practices for constructing and formatting formulas.

2017-04-05T10:19:45+00:00

Gaurav Sharma

5,882 Points

Thanks Dan for this and I also tried to edit my previous post but could not able to do that. It is very annoying. Why have they done like this?

2017-04-05T10:23:36+00:00

QuickBaseCoach App Dev./Training, Champion

59,686 Points

I think the ability to edit may depend if you are signed in? It seems to me that if I click that sign in button then I am able to edit my posts. But I'm not 100% sure of that theory that it's simply forgetting to maintain my sign-on and that an extra click to get re-signed on will allow edits.