brendan_mahe

Agnes that's what I ended up doing, Jeremy Brown over in community.filemaker.com was very helpful and pointed me in that exact direction (see link below). Thanks for the link to that filemaker file it looks really useful. Rivet, I was recommended against running an ExecuteSQL function in the html because of the fact it can run whenever it wants and it can take longer to complete the task. I'm sure I'll need to use that function soon, thanks https://community.filemaker.com/message/615327

Hi, I can't seem to get filemaker pro to plot google charts the way I want them in web viewer. I want the graph to look something like this: ...Seems it would be pretty basic at first but I can't get this particular multi-series chart to work. It needs to plot ALL the records and MORE THAN ONE series. I've created one table called 'MyTable' with 3 fields 'CarName', 'CarSpeed' and 'CarWeight'. I've populated the table with 5 records. CarName on the Y-Axis, and against this, CarSpeed and CarWeight are plotted on the X-Axis as 2 series. i.e. series one is 'CarName' vs 'CarSpeed', series 2 is 'CarName' vs 'CarWeight' I've managed to successfully create 2 graphs, first one plots the series ok but only works for one record. The second, in which I've used an ExecuteSQL command to collect the table data from FMP, shows all the records but for only one field on the X-Axis. Any help appreciated. I'm running filemaker pro 14, and I've attached the fmp file, as well as the javascript code from the web viewer of each graph. Any help greatly appreciated Google Charts-Demo File.fmp12 AllRecords-OneSeries.rtf AllSeries-OneRecord.rtf