Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
3 years ago

Button colors

Hello,
I have found QuickBase Clip Art Icons and have used this:
"<img src=\"https://images.quickbase.com/si/16/221-point_red.png\" title=\"PAST

But, I need to have at least 25 different colored buttons to use as identifiers on reports.  How would I create more buttons? 
Please note: I have no programming skills!

Thank you
Lynne H

------------------------------
BuildPro
------------------------------
APIs and custom code

17 Replies

Sort By
  • HankHalverson's avatar
    HankHalverson
    Qrew Cadet
    3 years ago
    Hi Lynne,
    I was in your shoes about a month ago. A great resource that requires very minimal programming skills is Kirk Tratchy's magic button app within QuickBase. If you search for magic button you should be able to find it fairly easily, then from there his app has more buttons and button functions than most people will ever need. You can look at each button and copy past the code it makes buttons very easy. And even better he has a YouTube channel that help walk you through some of them.

    I hope that helped,
    Hank

    ------------------------------
    Hank Halverson
    ------------------------------
    • BuildPro's avatar
      BuildPro
      Qrew Captain
      3 years ago
      Thank you.  I have the Magic Button App.  that is where I have accessed the buttons I am currently using.  However, I need more colors for the buttons and do not know how to that.

      ------------------------------
      BuildPro
      ------------------------------
    • BuildPro's avatar
      BuildPro
      Qrew Captain
      3 years ago
      I have tried this using the "Rich Text Button Builder" app, but there is something wrong with the formula...

      if([Customer Initials]="SMH",https://buildproconstructionco.quickbase.com/db/brr53r65a?a=dr&r=b&rl=bt5)

      ------------------------------
      BuildPro
      ------------------------------
      • HankHalverson's avatar
        HankHalverson
        Qrew Cadet
        3 years ago
        Here is some code I used for a button. You can copy past this into a rich text formula. The first part of the code will allow you edit the size and the color of the button so you can make it literally any color. The second part of it edits the function of the button. In my case it redirects you to a new url. You will have to change the app token, FID, the [DBID_], and the url code. 



        //formatting visuals of button
        var text bgcolor = "#34A853";
        var text txtcolor = "white";
        var text style = "style=\"text-decoration: none; background:" & $bgcolor & "; border-radius: 5px; padding: 8px 20px; color: " & $txtcolor & "; display: inline-block; font: normal 700 24px/1 \"Calibri\", sans-serif; text-align: center; text-shadow: none;";

        //Inner workings of button
        var text url =

        URLRoot() & "db/" & [_DBID_RFP_REQUEST_FORM] & "?act=API_EditRecord&rid=" &[Record ID#]
        & "&apptoken=uwi4fb9cj4szcdzjnfxd5xz3te"
        & "&_fid_148=2"
        & "&rdr=" & URLEncode("https://divisionsinc.quickbase.com/db//brpms6hce?a=dbpage&pageID=19");

        "<a " & $style & " href=\"" & $url & "\">Approve</a>"

        ------------------------------
        Hank Halverson
        ------------------------------
  • EvanMartinez's avatar
    EvanMartinez
    Qrew Elite
    3 years ago
    Hi Lynne,

    If you are looking for a library of icons you can use and an example of how you set up the formula you might find this article Colorful Icons make Quickbase more Productive a helpful resource. It links away to an accessible library of images you can call out to in Quickbase and gives an example of the set up since you aren't looking to have the images link away to anywhere you are just trying to display images correct?

    You can do that with a formula rich text field and a formula like this as an example:

    Case ([Status],"Not Started","<img src=\"https://images.quickbase.com/si/16/227-rect_red.png\">>",
    "<img src=\"https://images.quickbase.com/si/16/229-rect_yellow.png\">>",
    "<img src=\"https://images.quickbase.com/si/16/228-rect_green.png\">>",
    null) 


    ------------------------------
    Evan Martinez
    ------------------------------