Forum Discussion

Mike's avatar
Mike
Qrew Member
4 years ago

Adding a status banner as formula field

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
------------------------------
  • 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
    ------------------------------
    • Mike's avatar
      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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew 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
        ------------------------------