Controlling the size of the charts within a qbase form

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Is it possible to control the size of the charts embedded within a Qbase base form? It would be great is we could use the dashboard widget within a record from.....

I would like to have 2-3 charts side-by-side.....(where I can control the chart sizes)



thanks
Photo of rocketc

rocketc

  • 774 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,678 Points 20k badge 2x thumb
If you have Admin permissions

Open form > Click "Customize This Form" (in the top right of form)

Find that particular form element (your report link field)


On the right you will have the option adjust the pixels and max rows to display

Pixels could be considered your width, and rows would be your height.

Use the checkbox on the form element to put all three in a row.

Side Note: Report Links on forms do not allow for graphs.  I believe only table reports and summary reports are eligible. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,422 Points 50k badge 2x thumb
While you may use a report link field to show any report you like, including charts, I found that you cannot set the size of the chart.  So right now I don't think that there is a native solution to be able to get the charts "side by each".

But if printing is the goal here, I suppose that you might consider printing in landscape.  I do have a better solution myself right now.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,044 Points 20k badge 2x thumb
This can easily be accomplished with script using one of the various script injections techniques (IOL, BOL, SW). The essential code to resize a rendered HighChart (width=500, height=400) is this:


var chart = Highcharts.charts[0];
chart.setSize(500, 400);

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=538
To test this code just create a page displaying a chart and paste the above code into the console (see attached screenshot).
My suggestion is to make a New Year's Resolution to learn and use script for all your QuickBase enhancements needs:
https://www.youtube.com/watch?v=rqbAsr6wN_I
If you need assistance implementing this solution fee free to contact me using the information in my profile:

https://quickbase-community.intuit.com/users/513/