Skip to main content
Question

Pie Pieces as Buttons on Dashboard Assistance

  • December 6, 2019
  • 0 replies
  • 69 views
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
------------------------------

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • December 6, 2019
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
------------------------------
Mark Shnier. Your Quickbase Coach
AdamKeever1
Forum|alt.badge.img+2
  • AdamKeever1
  • Quickbase Alumni
  • December 6, 2019
Statements deleted, no longer relevant.
------------------------------
Adam Keever
------------------------------
AdamKeever1
Forum|alt.badge.img+2
  • AdamKeever1
  • Quickbase Alumni
  • December 6, 2019
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
------------------------------
    Terms & ConditionsAccessibility statement