Getting Started

 View Only
  • 1.  Adding a status banner as formula field

    Posted 03-08-2021 19:14
    I saw a youtube video where somebody added this really cool status banner -- he was using an app called "Empower Forms and form rules" but I don't see it in the exchange.  Does anybody happen to have or know where I can find that formula?

     Thanks for any help!!

    ------------------------------
    Michael Brumfield
    ------------------------------


  • 2.  RE: Adding a status banner as formula field

    Posted 03-08-2021 19:37
    Do you have a link to the video?  Not sure what you mean.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Adding a status banner as formula field

    Posted 03-09-2021 09:37
    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
    ------------------------------



  • 4.  RE: Adding a status banner as formula field

    Posted 03-09-2021 09:55
    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
    ------------------------------



  • 5.  RE: Adding a status banner as formula field

    Posted 03-09-2021 12:12
    Oh, my god, Mark -- this is the coolest thing EVER!!  Thank you so much!!!

    -Mike

    ------------------------------
    Michael Brumfield
    ------------------------------



  • 6.  RE: Adding a status banner as formula field

    Posted 03-17-2021 11:11
    Hi 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?





  • 7.  RE: Adding a status banner as formula field

    Posted 03-17-2021 12:25
    If 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
    ------------------------------