Jump to content
Sign in to follow this  
Papabjoe

Chart using Filemaker Pro

Recommended Posts

Papabjoe    0

Hello all.

I have a problem that may be a step backwards for most of you. Starting in Version 7, I was an active user and developed some almost sophisticated solutions. Over time, my needs for FM dropped and as a result, so has my expertise.

My new role in my job requires some charting that would typically be done in Excel. However, I am doing most of the data entry and reporting in filemaker 9.

I need to create bar charts and I need a quick way to accomplish this.

My current idea, without upgrading to 11, is to create the summary date I need, export it as an excel file with the command to launch the application once the export is complete.

From there I would manually select the data and create a chart.

Question?

Is there a more efficient way to do this in filemaker 9 for mac? I'm not able to purchase any additional software or plugins. Ideally, I'd like to script it so that it not only exports the data but launches excel, and creates the chart. The reason being is that others in my office, may have to perform this task, and they are less than literate in FM, or excel for that matter.

Thank you for your assistance.

Share this post


Link to post
Share on other sites
Agnes Riley    20

Truthfully, the best way to go about it is to upgrade to FM11. Or use a chart plug-in, like fusion charts.

I did, however, created an AppleScript some time ago that sent the data to Excel to chart it then got the chart stored as a picture in FileMaker. Too bad these things break with every OS and software update.

So, back to my original suggestion: upgrade your FM version. That are quite a few new things in 10 and 11 over 9; you'll appreciate them.

Share this post


Link to post
Share on other sites
Papabjoe    0

Thanks, but my issue is that I'm entrenched in an excel only office. My superiors are skeptical filemaker is as neato as I keep telling them it is. Needless to say, authorization to purchase upgrades or plugins is not going to happen. If I can make this work and satisfy the requirement for charts, I can then illustrate how I had to bubble-gum and chicken-wire the solution together. While that may or may be enough to motivate the purchase of an upgrade, I still need the solution. Believe me, if I could buy it, I would.

I will look into fusion charts though. Thanx for the tip.

Share this post


Link to post
Share on other sites
comment    1,382

I'm not able to purchase any additional software or plugins.

There are many ways to produce a chart in a web viewer - Google Chart Tools and FusionCharts for FileMaker being just the first two that come to mind.

---

FusionCharts for FileMaker is not really a plugin, and IIRC, it's free.

Edited by comment

Share this post


Link to post
Share on other sites
JerrySalem    5

I agree that using Google Chart may be the way to go. You get much better control over formatting using google than the native FileMaker chart tool.

You can learn how to build a chart using an http call here;

http://code.google.com/apis/chart/image/docs/making_charts.html

put the http code, into a web viewer and that is it.

This week (!) google updated the chart tool, I am not sure if the wizard will help you but check this out too;

http://code.google.com/apis/chart/image/docs/chart_wizard.html

this looks like a great tool!

Jerry

Share this post


Link to post
Share on other sites
ron G    1

There are many ways to produce a chart in a web viewer - Google Chart Tools and FusionCharts for FileMaker being just the first two that come to mind.

---

FusionCharts for FileMaker is not really a plugin, and IIRC, it's free.

Jan 11, 2014.  FusionCharts 'free' is no longer available.

Share this post


Link to post
Share on other sites
ron G    1

I agree that using Google Chart may be the way to go. You get much better control over formatting using google than the native FileMaker chart tool.

You can learn how to build a chart using an http call here;

http://code.google.com/apis/chart/image/docs/making_charts.html

put the http code, into a web viewer and that is it.

This week (!) google updated the chart tool, I am not sure if the wizard will help you but check this out too;

http://code.google.com/apis/chart/image/docs/chart_wizard.html

this looks like a great tool!

Jerry

Jan 11, 2014

Chart Wizzard is removed.  Code Playground is not useful in telling me how to get Google Charts to recognized FM tables.

post-72145-0-09068400-1389494370_thumb.p

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

  • Similar Content

    • By Little Mighty
      Hi Guys
      I can't figure out a solution for this. The final result is an export, No data have to be stored in filemaker afterwards.
      I need to combine and export data from 3 tables to the SAME field in Excel. Lets say we have table A: A1, A2 and A3, table B: B1, B2 and B3 and table C: C1, C2 and C3. These are tied together by a unique number in the solution. I need these fields to output i the export as all 1's in one column beneath each other, all 2's in one column beneath each other and all 3's in one column beneath each other. 
      I am thinking, that I need a new table to combine these fields in 3 new fields D1, D2 and D3 and then do the export of this table. After export, the table could be deleted until next export. I am thinking this should be set up as a script. 
      Does the above make sense, and could it be done via a script?
      Thanks for the help - really appreciate it!
    • By hutchlad
      Hey Guys,
      Just a quick one, I have a large report that groups products together via Style, and has totals at the bottom in the green section (I realise they arent totalling but thats not my issue)
      My issue is, that when I export as a spreadsheet, my products stay grouped by Style, but I cannot for the life of me get the totals to stay underneath the columns of each group! Any help or advice would be appreciated, I just want it so that its in the format below with the group of products, then the totals beneath.
       

    • By Bartek
      Hi there,
      I am making cutom import and export from/to excel documents.
      Is there any way to merge excel cells in scribe?
      I can easly find out which fields are merged when importing.
      two nested loops and if second col or row is empty while reading i consider it merged.
      Problem is while exporting.
      I need to add new rows to excel documents and keep 1 column merged for each set of rows(like in sub summary but vertical).
      Thanks in advance for any help.
      Have a nice day.
    • By PedroAlex
      Good afternoon everyone.
      I need to open a .xlsx file by pressing a button
      I have tried with a script, where I establish a variable
      $ filename = e: \ Works \ Josram \ Presup \ AAVSA \ slopes 345 7 Apr 14.xlsx
      And using the command "Send DDE Execute"
      The service name = "c: \ Program Files \ Microsoft Office \ Office16 \ Excel.exe"
      But when you run it, it just does nothing
      Can someone tell me that I'm doing wrong?
      I don't need to import o export a file. 
      I only need, when i click a button Excel runs and open the .xlsx file
      Thanks in advance
      regards
      Pedro
    • By Bartek
      Hi There,
      First of all many thanks to creators for amaizng plugin.
      What is the syntax for inserting images to excel?
      ScribeDocWriteValue ( “addImage()”; image ; page ; x location ; y location ; height ; width ) 
      Do not work for xlsx with error about invalid cell name (first parameter is function adn for excel it seams it is not recognized) for pdf works fine as in demo expample
      I tried standard syntax for excel where first parameter is table cell and second is image in container but it do not insert the image.
      Any suggestions?
      Thanks in advance.
      Bart
×

Important Information

By using this site, you agree to our Terms of Use.