Forum Discussion

RubyKapil2's avatar
RubyKapil2
Qrew Captain
6 years ago

Pie Pieces as Buttons on Dashboard Assistance

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
------------------------------

12 Replies

  • 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
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      ...  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
      ------------------------------
      • AdamKeever1's avatar
        AdamKeever1
        Qrew Commander
        Ruby mentioned the pie is the company's icon so I assumed so.

        ------------------------------
        Adam Keever
        ------------------------------
    • DonLarson's avatar
      DonLarson
      Qrew Elite
      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
      ------------------------------
  • 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
    ------------------------------
    • RubyKapil2's avatar
      RubyKapil2
      Qrew Captain
      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
      ------------------------------
      • RubyKapil2's avatar
        RubyKapil2
        Qrew Captain
        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
        ------------------------------
  • Statements deleted, no longer relevant.
    ------------------------------
    Adam Keever
    ------------------------------