Forum Discussion
GauravSharma3
9 years agoQrew Commander
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
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_
9 years agoQrew Elite
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:
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.
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.