This demo needs a little more work to make it easier to use and integrate but the guts of it are working properly. Since QuickBase in
not providing a lot of help in using JavaScript with the product you sort of have to get creative in how to do it yourself. For this example I created a
Tasks table with a task/button for opening a new window with the chart report and adding the script into that new window to
redraw the chart with the modified properties (in this case a different maximum yaxis value). Other chart modifications and integration options are possible.
Tasks Table ~ Click "ModifyChart.js" Button and note the scale change on redraw
https://haversineconsulting.quickbase.com/db/bk89redf6?a=q&qid=1 Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=523 You can modify any feature of a QuickBase generated chart but some more work probably is needed to make it easier to use. More to come as I have time. Feedback would be appreciated.
UPDATE: I forgot to mention that this is my database for
UFO Sightings in the United States. You really need to check out how your state ranks in sightings. Yeah it is a real thing - read today's news..
https://www.youtube.com/watch?v=2MRdtXWcgIw