Forum Discussion
Mike
Qrew Member
Sorry, Mark! I found the video at like 3 am and so, of course, could not find it after you asked! He talks about it at the 22:09 mark, Mark. Thank you so much for helping me AGAIN!
-Mike
https://www.youtube.com/watch?v=0a3WR1wWJZ4&t=2506s
------------------------------
Michael Brumfield
------------------------------
-Mike
https://www.youtube.com/watch?v=0a3WR1wWJZ4&t=2506s
------------------------------
Michael Brumfield
------------------------------
MarkShnier__You
4 years agoQrew Legend
The app is in fact in he exchange called
Empower - Forms & Form Rules
But 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.com
mark.shnier@gmail.com
------------------------------
Empower - Forms & Form Rules
But 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.com
mark.shnier@gmail.com
------------------------------
- Mike4 years agoQrew MemberOh, my god, Mark -- this is the coolest thing EVER!! Thank you so much!!!
-Mike
------------------------------
Michael Brumfield
------------------------------ - NirajShah44 years agoQrew CadetHi Mark,I cannot find the app in the exchange and I don't have access to the YQC realm that you linked to. Could it be called something else?ᐧ
- MarkShnier__You4 years agoQrew LegendIf you search on EMPOWER there will be 39 hits. Scan the results and you will see the app.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Related Content
- 2 months ago
- 2 months ago
- 3 months ago
- 2 months ago