Discussions

Expand all | Collapse all

Pie Pieces as Buttons on Dashboard Assistance

  • 1.  Pie Pieces as Buttons on Dashboard Assistance

    Posted 12-06-2019 06:40
    Dashboard has a Pie image. This image has 8 wedges of a pie assembled into a pie shape. I want to be able to click each pie wedge so that it acts like a button to a one of 8 different dashboard Pages.  Has anyone done something similar? Thanks for the help.

    ------------------------------
    Ruby Kapil
    ------------------------------


  • 2.  RE: Pie Pieces as Buttons on Dashboard Assistance

    Posted 12-06-2019 07:02
    I know that this is easy on a regular Summary report.  I will have to now test if it's possible on a chart!

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



  • 3.  RE: Pie Pieces as Buttons on Dashboard Assistance

    Posted 12-06-2019 07:16
    Thanks Mark. The image we are using is company's icon that is a Pie with different colored pieces. Each piece represents a different part of the project process. I was able to break up the pie into the different wedges. I was trying to figure out how to override the 3 to a row, and rows grid for placement of buttons on a dashboard. I appreciate the help.

    ------------------------------
    Ruby Kapil
    rubykapil@wi-finity.com
    Wi-Finity, Inc
    ------------------------------



  • 4.  RE: Pie Pieces as Buttons on Dashboard Assistance

    Posted 12-06-2019 07:36
    And to add, even if I had solved the how to break free of the grid layout on dashboards, I still have no idea how to use the wedges as buttons. Thanks.

    ------------------------------
    Ruby Kapil
    rubykapil@wi-finity.com
    Wi-Finity, Inc
    ------------------------------



  • 5.  RE: Pie Pieces as Buttons on Dashboard Assistance

    Posted 12-06-2019 08:04

    Can you post an image of what you mean in your post above. 


    But regardless, my suggestion would be to use a Summary report but for the Group By Rows  and the columns if you are using Column Grouping, to use a Formula Rich Text Hyperlink field with an Image as the thing to click on as opposed to words. Post back if you need help with the syntax for that hyperlink. 



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



  • 6.  RE: Pie Pieces as Buttons on Dashboard Assistance

    Posted 12-06-2019 11:19
    Here is a screen shot of a summary report with an icon that is drillable into any target URL, such as a dashboard.  So not a piechart but a graphical looking summary report.

    Here is he formula

    var text WordsOne = "<img src=https://images.quickbase.com/si/48/002-music.png>";

    var text WordsTwo = "<img src=https://images.quickbase.com/si/48/054-winlogo.png>";

    var text Words = If(Rem([Record ID#],2)=0, $WordsOne, $WordsTwo);


    var text URL = "http://www.google.com";

    "<a target=_blank href=" & $URL & ">" & $Words & "</a>"




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



  • 7.  RE: Pie Pieces as Buttons on Dashboard Assistance

    Posted 12-06-2019 09:23
    Edited by Adam Keever 12-06-2019 17:07
    Statements deleted, no longer relevant.
    ------------------------------
    Adam Keever
    ------------------------------



  • 8.  RE: Pie Pieces as Buttons on Dashboard Assistance

    Posted 12-06-2019 17:07
    Edited by Adam Keever 12-06-2019 17:09
    You can use the area shape element and an image map generator to get coordinates. So here is the prototype; I will only show a few images so you can see that each pie slice references a different URL (seen at the bottom left of each image):





    There is a website that can help you identify the coordinates of the pie slices in your chart:
    https://www.image-map.net/

    You upload your image and then create the areas. I used poly and clicked several points on the arc to best fit the poly area to the pie slice. I was not sure if I was on the right track at first so I don't have an image to show all eight pie slices, but I went back and made an image of one slice so you get the idea:

    Then you can apply all of your coordinates to the following formula in a rich text formula field (or a code page) changing out the "XXXX" for your realm and DBID and all of the URL's for the pages you want to navigate to:
    "<img src=\"https://XXXX.quickbase.com/up/XXXX/g/rb/eg/va/Picture1.jpg\" width=\"100%\" usemap=\"#pie\">\n\n
      <map name = \"pie\">\n
      <area shape=\"poly\" coords=\"329,16,209,38,79,139,26,266,326,322,329\" href=\"https://opentextbc.ca/dbdesign01/chapter/chapter-1-before-the-advent-of-database-systems/\" target=\"_blank\">\n
      <area shape=\"poly\" coords=\"328,328,24,274,22,372,49,459,104,541,172,594,328\" href=\"https://www.science.gov/\" target=\"_blank\">\n
      <area shape=\"poly\" coords=\"331,329,177,597,251,628,341,639,422,623,484,595,331\" href=\"https://beautifier.io/\" target=\"_blank\">\n
      <area shape=\"poly\" coords=\"334,328,489,594,545,552,593,496,621,431,637,382,334\" href=\"https://discover.dtic.mil/products-services/\" target=\"_blank\">\n
      <area shape=\"poly\" coords=\"332,325,637,379,643,304,627,237,600,174,332\" href=\"http://eroi.com/create-your-very-own-interactive-quiz/\" target=\"_blank\">\n
      <area shape=\"poly\" coords=\"335,324,487,57,548,104,599,171,335\" href=\"https://erdplus.com/#/standalone\" target=\"_blank\">\n
      <area shape=\"poly\" coords=\"332,323,386,20,434,34,485,55,332\" href=\"https://www.makeitfrom.com/compare/SAE-AISI-1045-S45C-G10450-Carbon-Steel/SAE-AISI-1140-G11400-Carbon-Steel\" target=\"_blank\">\n
      <area shape=\"poly\" coords=\"332,322,333,14,385,20,332\" href=\"https://exceljet.net/formula/categorize-text-with-keywords\" target=\"_blank\">\n
      </map>"
    I'm glad you asked this question Ruby. I planned to work on digital check sheets that would allow an operator to view an image of a complex part and click on a small section of it to navigate to relevant specifications in a check sheet. This will come in handy. I hope you are able to utilize this method.

    ------------------------------
    Adam Keever
    ------------------------------



  • 9.  RE: Pie Pieces as Buttons on Dashboard Assistance

    Posted 12-06-2019 17:09
    ...  But would this be a static image?

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



  • 10.  RE: Pie Pieces as Buttons on Dashboard Assistance

    Posted 12-06-2019 17:12
    Ruby mentioned the pie is the company's icon so I assumed so.

    ------------------------------
    Adam Keever
    ------------------------------



  • 11.  RE: Pie Pieces as Buttons on Dashboard Assistance

    Posted 12-06-2019 17:16
    Oh, now I get it.

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



  • 12.  RE: Pie Pieces as Buttons on Dashboard Assistance

    Posted 12-07-2019 09:13
    Mark and Adam, I am so grateful for your expert advice. I will test out the two methods. Both solutions open up the door to greater creative options for dashboard. Thanks for taking the time to help me. I'll let you know how it goes.

    ------------------------------
    Ruby Kapil
    ------------------------------



  • 13.  RE: Pie Pieces as Buttons on Dashboard Assistance

    Posted 12-08-2019 09:55
    Adam,

    This is very innovative.   I want to get a sample up and running in a Formula RT. 

    The next leap would be to have dynamic image that did this.  I suspect it is a huge leap in the Quick Base world.


    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------