Monday, November 30, 2009

FileMaker Flot Chart (offline charts without plugins)


When it comes to FileMaker charting, developers usually start thinking about plugins, or online web viewer (for example: Google Chart API) solutions.

In the following example I show you how you can create an offline chart in FileMaker which looks great.


I came across Flot when I was looking for javascript graph solutions, and I really liked it.
Though I will use this. You can download the source of it, which has great example files as well.

The FileMaker integration is quite simple. We'll need a field, which holds the Javascript files. (I copied the jquery.flot.min.js, jquery.min.js and the excanvas.min.js script after each other into a field (in the example file attached it's called chartsource.

Then using this, and the field data, I created a web viewer which will display those fields to me.

The example file only shows the basics of creating an offline graph, it's up to you to look at Flot documentation and create different kind of graphs.

The demo file can be downloaded from here .

Please also visit our site, http://crm.fm which has our main FileMaker product, and support us by buying it. Thanks!

The material on this document is offered as is. There is no representation or warranty, expressed or implied, nor does any other contributor to this post. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.