Forum Discussion
OwenMorgan
6 years agoQrew Member
I created a bool to combine the two filing code fields, called "has no records filing code?" and is true when both fields are blank
so working with that I tried this but I can't close it properly
// Logic and UI
Case ([has no records filing code?]=true,
Case([Status],
"Logging" , $LoggingHeader,
"Allocated" , $AllocatedHeader,
"Awaiting Reply", $AwaitReplyHeader,
"Closed" , $ClosedHeader)
, $RecordsHeader)
------------------------------
Owen Morgan
------------------------------
so working with that I tried this but I can't close it properly
// Logic and UI
Case ([has no records filing code?]=true,
Case([Status],
"Logging" , $LoggingHeader,
"Allocated" , $AllocatedHeader,
"Awaiting Reply", $AwaitReplyHeader,
"Closed" , $ClosedHeader)
, $RecordsHeader)
------------------------------
Owen Morgan
------------------------------
DonLarson
6 years agoQrew Deputy
Owen,
Two changes.
1) I put in variables to check the values from your Case Statement.
2) I removed the extra parantheses around the fields in the If clause
Put this into the field and check the results. I am hoping that you will see from the Debug fields that something is amiss in the data.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Two changes.
1) I put in variables to check the values from your Case Statement.
2) I removed the extra parantheses around the fields in the If clause
// Source Control
// Variable Images
var text LoggingHeader = "<img src=\"****.quickbase.com/up/bp9dy8gr2/g/rb/eh/va/... width=\"700\">";
var text AllocatedHeader = "<img src=\"****.quickbase.com/up/bp9dy8gr2/g/rc/eh/va/... width=\"700\">";
var text AwaitReplyHeader = "<img src=\"****.quickbase.com/up/bp9dy8gr2/g/rc/eh/va/... width=\"700\">";
var text ClosedHeader = "<img src=\"****.quickbase.com/up/bp9dy8gr2/g/rc/eh/va/... width=\"700\">";
var text RecordsHeader = "<img src=\"****.com/up/bp9dy8gr2/g/rc/eh/va/records.jpg\", width=\"700\">";
var text Status = [Status];
var text EventFC = [Event - Filing Code];
var text FilingCode = [Filing Code];
// Logic and UI
// Debug Fields
$Status & "<br>"&
$EventFC & "<br>"&
$FilingCode & "<br>"&
// Case Statement
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)
Put this into the field and check the results. I am hoping that you will see from the Debug fields that something is amiss in the data.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------