Skip to main content
Question

multiple reference criteria for a status icon field

I have a status visual header for records. 
This works fine when only looking at one field [status] but I want to add an additional criteria. If [status] is closed AND [filing code] is not blank , show a different header. 

This is what I have

Case([Status],
"Logging","<img src=\"https://****.quickbase.com/up/bpxgbkbcm/g/rb/eh/va/logging.jpg\", width=\"700\">",
"Allocated","<img src=\"https://****.quickbase.com/up/bpxgbkbcm/g/rc/eh/va/Allocated.jpg\", width=\"700\">",
"Advice","<img src=\"https://****.quickbase.com/up/bpxgbkbcm/g/rc/eh/va/Allocated.jpg\", width=\"700\">",
"Awaiting Reply","<img src=\"https://****.quickbase.com/up/bpxgbkbcm/g/rd/eh/va/awaiting_reply.jpg\", width=\"700\">",
"Closed","<img src=\"https://****.quickbase.com/up/bpxgbkbcm/g/re/eh/va/closed.jpg\", width=\"700\">",
If([Filing Code]<>"", "<img src=\"https://****.quickbase.com/up/bpxgbkbcm/g/rb/eh/va/records.jpg\", width=\"700\">",
[Event - Filing Code]<>"", "<img src=\"https://****.quickbase.com/up/bpxgbkbcm/g/rb/eh/va/records.jpg\", width=\"700\">"))

I tried closing the Case() before IF but then I get two versions of the image which is not right. 
in this scenario I am seeing the closed icon but not the records icon on cases that do meet the IF criteria

Can i do this easily without creating a variable?

------------------------------
Owen Morgan
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+19
  • DonLarson
  • Qrew Cadet
  • January 20, 2020
Owen,

Getting the syntax right is always a trick when you get beyond one or two sets of parentheses. In the Case Statement you can put additional criteria after the value of the case object.  I also recommend putting the images in variables so that your logic is easier to read.

// Variable Images
var text IMGOne =  long url string  one ;
var text IMGTwo=   long url string two;

// Logic and UI
Case ( [Status],

"Logging" ,  If (  isnull([Event Code]), $IMGOne, IMGTwo),
"Closed"  ,   If (  [Checkbox]=true, $IMGOne, $IMGTwo)
  )

 
This keeps your Formula Rich Text Box nice and clean.


------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Terms & ConditionsAccessibility statement