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.
