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.pngblue shows image from example url2 https://images.url.com/blue.pnggreen shows image from example url3 https://images.url.com/green.pngSo when looking at the first line, the field2 will show a red icon, as the field1 text matches 'red'hope that makes sense, thanks.

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

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

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

thanks both, i will give that a try and update you. much appreciated.

worked brilliantly, thanks both.

Icon in field depending on another field value

12 Replies

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
- _anomDiebolt_
  Qrew Elite
  9 years ago
  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\">" )
- GauravSharma3
  Qrew Commander
  9 years ago
  Thanks Dan, I'll make sure next time :)
- _anomDiebolt_
  Qrew Elite
  9 years ago
  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.
ChrisRyanUkChri
Qrew Trainee
9 years ago
thanks both, i will give that a try and update you. much appreciated.
ChrisRyanUkChri
Qrew Trainee
9 years ago
worked brilliantly, thanks both.
- GauravSharma3
  Qrew Commander
  9 years ago
  Great :)

Forum Discussion

Icon in field depending on another field value

12 Replies

Related Content

Snapshot Fields

Dropdown list depends on another field selection

Dropdown list depends on another field user

Copy Single Table from One App to Another

Consolidate Field Types