Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Scripting chart creation in Excel

bchaplin
in AppleScript & Automator

Featured Replies

I just need to know if the following is possible with FM 8 or 8.5 (at work, we are still running version 6!):)

We have a database which displays multiple records per person, in portals. By hand, I have exported this information into a tab-separated text file, imported it into Excel, and constructed a fairly complex graph based on it. Now my boss wants me to find a way to automate this process so that a novice could do it, relatively quickly, for hundreds of records. I can buy the latest version of Filemaker if this will help us accomplish the task. Is FM v.8 more powerful than v.6 for this kind of thing?

So, can I script not only the export of certain fields, but also their import into Excel and the chart creation, through some sort of AppleScript? We are running Mac OS X Tiger, but the end users are on Windows.

If there was a plug-in that would make the charts from within FM, that would be even better. I've googled but so far I haven't found anything that will graph the content of portals.

Create an account or sign in to comment

https://fmforums.com/topic/44792-scripting-chart-creation-in-excel/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.