Forum Discussion
DonLarson
6 years agoQrew Elite
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
------------------------------
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
------------------------------
OwenMorgan
6 years agoQrew Member
thanks Don,
I am not getting any closer I feel.
// Variable Images
var text LoggingHeader = "<img src=\"https://****.quickbase.com/up/bp9dy8gr2/g/rb/eh/va/logging.jpg\", width=\"700\">";
var text AllocatedHeader = "<img src=\"https://****.quickbase.com/up/bp9dy8gr2/g/rc/eh/va/Allocated.jpg\", width=\"700\">";
var text AwaitReplyHeader = "<img src=\"https://****.quickbase.com/up/bp9dy8gr2/g/rc/eh/va/awaiting_reply.jpg\", width=\"700\">";
var text ClosedHeader = "<img src=\"https://****.quickbase.com/up/bp9dy8gr2/g/rc/eh/va/closed.jpg\", width=\"700\">";
var text RecordsHeader = "<img src=\"https://****.com/up/bp9dy8gr2/g/rc/eh/va/records.jpg\", width=\"700\">";
// Logic and UI
Case ([Status],
"Logging" ,
If (([Event - Filing Code])<>"" and ([Filing Code])<>"", $LoggingHeader, $RecordsHeader), $LoggingHeader,
"Allocated" ,
If (([Event - Filing Code])<>"" and ([Filing Code])<>"", $AllocatedHeader, $RecordsHeader), $AllocatedHeader,
"Awaiting Reply" ,
If (([Event - Filing Code])<>"" and ([Filing Code])<>"", $AwaitReplyHeader, $RecordsHeader), $AwaitReplyHeader,
"Closed" ,
If (([Event - Filing Code])<>"" and ([Filing Code])<>"", $ClosedHeader, $RecordsHeader), $ClosedHeader)
------------------------------
Owen Morgan
------------------------------
I am not getting any closer I feel.
It's a formula to determine the status header image
The field is called [status header]
I want it to show the formula based on the status field EXCEPT when there is a filing Code [Filing Code] or [Event – Filing Code] both text fields.
I cannot make it work! AM I missing something obvious? Is there a better way to separate the override that the Filing Codes mean for the formula??
// Variable Images
var text LoggingHeader = "<img src=\"https://****.quickbase.com/up/bp9dy8gr2/g/rb/eh/va/logging.jpg\", width=\"700\">";
var text AllocatedHeader = "<img src=\"https://****.quickbase.com/up/bp9dy8gr2/g/rc/eh/va/Allocated.jpg\", width=\"700\">";
var text AwaitReplyHeader = "<img src=\"https://****.quickbase.com/up/bp9dy8gr2/g/rc/eh/va/awaiting_reply.jpg\", width=\"700\">";
var text ClosedHeader = "<img src=\"https://****.quickbase.com/up/bp9dy8gr2/g/rc/eh/va/closed.jpg\", width=\"700\">";
var text RecordsHeader = "<img src=\"https://****.com/up/bp9dy8gr2/g/rc/eh/va/records.jpg\", width=\"700\">";
// Logic and UI
Case ([Status],
"Logging" ,
If (([Event - Filing Code])<>"" and ([Filing Code])<>"", $LoggingHeader, $RecordsHeader), $LoggingHeader,
"Allocated" ,
If (([Event - Filing Code])<>"" and ([Filing Code])<>"", $AllocatedHeader, $RecordsHeader), $AllocatedHeader,
"Awaiting Reply" ,
If (([Event - Filing Code])<>"" and ([Filing Code])<>"", $AwaitReplyHeader, $RecordsHeader), $AwaitReplyHeader,
"Closed" ,
If (([Event - Filing Code])<>"" and ([Filing Code])<>"", $ClosedHeader, $RecordsHeader), $ClosedHeader)
------------------------------
Owen Morgan
------------------------------