Tag Archive for 'FileMaker 11'

DevCon 2011 Recap

2011 FileMaker Developer ConferenceOver the past ten years, the annual FileMaker Developer Conference (DevCon) has been a truly enjoyable experience for me. It’s the one place on the globe that the best and brightest FileMaker talent gather for a little under a week to share ideas, learn techniques, find answers to challenges, collaborate, and get a few hints about the future of FileMaker.

This year’s conference was held at the gorgeous San Diego Hilton Bayfront where we enjoyed temperatures in the 70s with low humidity and a pleasant breeze. The accommodations and facility was top notch, with plenty of space for the conference and all of the normal hotel patrons.

Continue reading ‘DevCon 2011 Recap’

 

Navigating to List Views with Summary Parts

Here is a behavior I am not fond of. When I click on a button to go to a list, I expect to be at the top of the list on the first record.  This works fine if you are using any version of FileMaker.  However with version 10, Filemaker introduced a new wrinkle, sub-summary layout parts that are visible in Browse mode.  This wonderfully useful feature did introduce one unexpected consequence.

Continue reading ‘Navigating to List Views with Summary Parts’

 

FileMaker 11 and OS X Lion

For those OS X users itching to get onto Lion, but FileMaker compatibility is holding you back, you have a dim green light. FileMaker just posted some details on FileMaker’s compatability.

Proceed with caution since there might some hidden ‘gotchas’ that haven’t come to light yet. But if you don’t use Web publishing, older excel exports (Pre-Excel 2007), Asian characters and 0 and negative decimal place, you might dip your toe in the water.

OS upgrades are serious business, especially with production systems, so we don’t recommend jumping in cold. Test on a development server and non-production clients first, and be sure and have a full backup of both your computer and custom FileMaker solution.

 

Tracking Changes in Your Database

Everyone likes a good story, even one that relates to a database. When you are working with a database that is shared among different users you will eventually see this scene, or perhaps experience it yourself:

You, or someone else, are staring at the computer screen looking at a record that has changed since the last time you looked at it and you mutter to yourself, “Who changed this record?  This is not the same as the last time I looked at it!”

An audit log is like looking at a record through time.  It will let you trace any changes that have been made on a piece of data in your database.  For example, in a contact management system an audit log will let you see address changes over time for a particular person.  You can use an audit log in an ordering system to track changes made to each invoice over time.  It is also an important tool for determining workflow processes. Remember the old adage, “who what when where why and how”.  Who changed this record? What data was changed? When was it changed? Why was it changed?and How?  An audit log can tell you all of these things (except probably the “Why”).

Continue reading ‘Tracking Changes in Your Database’

 

Choose the Right Layout

Ah the good old days!  Back when the status area was vertical, if you wanted to display a particular layout depending on some conditions, then you needed to create your own navigation buttons.  But face it, those buttons were never as good as the native navigation provided by FileMaker.  Thanks to script triggers we can use the built-in navigation buttons and also conditionally display a particular layout.

Continue reading ‘Choose the Right Layout’

 

We can Sort it out

The other day I was sitting with a client, looking at a list view layout.  The client said to me, “Can you make it so that when I click the headers the columns will sort, like in Table View or Excel?”  No problem, I said; I’ll just make each header a button that runs a Sort script step.  They she said “Well, when I click each one it should sort ascending and then descending, just like Excel.”  Ok – a little bit more inconvenient; I need to use a script and a bunch of of fields to keep track of ascending/descending.  Finally, she dropped the bomb.  “Oh, can I have those cute little up and down arrows, like in Excel?”  That is the last straw, I thought.  Now I have to make scripts, fields AND graphic calculations for those dumb arrows.

There must be a better way to do this.  Using the great scientific tradition of standing on the shoulders of giants I searched the web for good solutions.  Using  a combination of scripting and merge global variables you can easily put up and down arrows next to sorted headers.  This technique only requires a script.  No extra fields are required go make it work.

Continue reading ‘We can Sort it out’

 

Please Join Us January 25: Separation Model Smackdown!

Greetings FileMaker Enthusiasts,
Our next Philadelphia FileMaker Developer Group meeting has been scheduled for Tuesday evening, January 25th 2011 at 6:00 PM. The meeting will be held at the IT Solutions Fort Washington Office.
414 Commerce Dr., Suite 150, Fort Washington, PA 19034
Please RSVP here if you are planning to attend this meeting.

SEPARATION MODEL SMACKDOWN!

With Kevin Ayers and Jason Mundok
versus
Presented in a loose debate format, Kevin and Jason will argue the respective merits of the Separation Model versus the Unified Model.  Kevin is a strong proponent of the benefits of Separation architecture, and Jason…well, let’s just say he’s skeptical.  Don’t get him started.
 

FileMaker: Inspector Keyboard Shortcuts

Enjoy this guest post by our friends at Skeleton Key in St. Louis.

I used to use the keyboard shortcut in previous versions of FileMaker Pro to get to the “object info” window. One of the things I didn’t like about FileMaker Pro 11 is not being able to get to the inspector without using the mouse. Then I found the shortcut. You may have known this from the start, but if you did shame on you for not telling me :-)

Mac InspectorWindows InspectorWhile in Layout Mode on Mac OS X you can use Command+1 to go to the Position tab of the inspector. Command+2 takes you to the Appearance tab and Command+3 takes you to the Data tab. Use Control instead of Command on Windows. Once there, the tab key will navigate you through the items on that inspector tab.

Also if you have multiple inspectors open at once (one showing each tab), then these keyboard shortcuts will switch inspectors for you instead of switching tabs on the current inspector window.

Thought you might want to know about this hidden gem!

Chad Adams, FileMaker Certified Developer at Skeleton Key

 

Crossing Drupal II

In last week’s episode I mapped out our goal for this series: learn how to understand Drupal from the perspective of a Filemaker developer.

Following our motto of “Shut up and Fix it”,  we’re going to simply create a Drupal web site.  We’ll build a storefront that has products and a small blog attached.  Once that is running, we’ll attach the Drupal site to a FileMaker back end system.  This will allow us to pull product info from the back end system and possibly have users log in and track their orders.  That’s the end state we’ll be working toward in this series.

This week let’s expand our understanding a bit by taking a walk through the Content Construction Kit (CCK).

You’ll remember that last week we learned that a “Content Type” is analogous to a Table.  By default Drupal gives us two fields in each table:  Title and Body.  In order to make a useful database, we are going to need to add more fields to each table.

At its heart Drupal is a Content Management System.   Since the content that Drupal is designed to manage is typically a blog, the default Content Types in drupal are a Page and a Story.

The Page Content Type is normally for info that doesn’t change often, and a Story is typically used for things that change often.  Remember these are only the Drupal defaults; as with Filemaker, you are expected and encouraged to change the setup as appropriate.

We’re going to be using the Story content type for our store blog.  If all you are doing with Drupal is writing a blog, you’re basically done.  Stop reading here!

For this project, however, we plan to do a bit more, so  we’ll need to add some more descriptors into Drupal.

 
Pages: 1 2 3 4 5

Building robust error logs in FileMaker 11

As FileMaker developers, we have all had the experience when a user contacts us regarding a discovered glitch in our systems. And, because users aren’t developers, they may not be able to provide the most accurate information regarding what they were doing on which layout when said glitch happened.

It is possible to set up a FileMaker system to trap for error logs, however. There are a number of tools available to a developer to better track what’s going on with data so that when a user calls you with less-than-clear error reports, you can still track down the source of the problem. Continue reading ‘Building robust error logs in FileMaker 11′

 
Pages: 1 2 3 4 5