The app is in fact in he exchange called
Empower - Forms & Form RulesBut to see that banner in action you need to click on one of the button to view on an alternate form. #3. button
Here is he formula. for [Status Banner] in Customers
var text mainStyle = "width: 650px; height: 25px; display: flex; color: #FFFFFF; font: normal 600 14px/1 'Calibri', sans-serif;";
var text style = "width: 100px; height: 30px; text-align: center; display: flex; justify-content: center; align-items: center; margin: 0px 1px;";
var text New = If(
[Status] = "New", "<div style=\"" & $style & " background: #57a3f0; border-radius: 12.5px 0px 0px 12.5px; \"><p>New</p></div>",
"<div style=\"" & $style & " background: #57a3f0; border-radius: 12.5px 0px 0px 12.5px; \"><p>New</p></div>"
);
var text Working = If(
[Status] = "Working", "<div style=\"" & $style & " background: #57a3f0; \"><p>Working</p></div>",
If([Status]="Follow Up" or [Status]="Appointment Set" or [Status]="Unqualified" or [Status]="Qualified",
"<div style=\"" & $style & " background: #57a3f0; \"><p>Working</p></div>","<div style=\"" & $style & " background: #C1C3C4; \"><p>Working</p></div>")
);
var text FollowUp = If(
[Status] = "Follow Up", "<div style=\"" & $style & " background: #57a3f0; \"><p>Follow Up</p></div>",
If([Status]="Appointment Set"or [Status]="Unqualified" or [Status]="Qualified",
"<div style=\"" & $style & " background: #57a3f0; \"><p>Follow Up</p></div>","<div style=\"" & $style & " background: #C1C3C4; \"><p>Follow Up</p></div>")
);
var text AppointmentSet
= If(
[Status] = "Appointment Set", "<div style=\"" & $style & " background: #57a3f0; \"><p>Appointment Set</p></div>",
If([Status]="Appointment Set" or [Status]="Unqualified" or [Status]="Qualified",
"<div style=\"" & $style & " background: #57a3f0; \"><p>Appointment Set</p></div>","<div style=\"" & $style & " background: #C1C3C4; \"><p>Appointment Set</p></div>")
);
var text Unqualified
= If(
[Status] = "Unqualified", "<div style=\"" & $style & " background: #F95A5A; border-radius: 0px 12.5px 12.5px 0px; \"><p>Unqualified</p></div>",
"<div style=\"" & $style & " background: #C1C3C4; border-radius: \"><p>Unqualified</p></div>"
);
var text Qualified
= If(
[Status] = "Qualified", "<div style=\"" & $style & " background: #6BBD57; border-radius: 0px 12.5px 12.5px 0px; \"><p>Qualified</p></div>",
"<div style=\"" & $style & " background: #C1C3C4; border-radius: 0px 12.5px 12.5px 0px; \"><p>Qualified</p></div>"
);
Case([Status],
"Qualified",
"<div style=\"" & $mainStyle & "\">" & $New & $Working & $FollowUp & $AppointmentSet & $Qualified & "</div>",
"Unqualified",
"<div style=\"" & $mainStyle & "\">" & $New & $Working & $FollowUp & $AppointmentSet & $Unqualified & "</div>",
"<div style=\"" & $mainStyle & "\">" & $New & $Working & $FollowUp & $AppointmentSet & $Unqualified & $Qualified & "</div>")
ā
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------