Tag Archive for 'FileMaker 11'

Page 2 of 2

Speak your Mind. Using Comments, part 1.

Recently I was on a family trip to Pittsburgh.  We were walking around the campus of Carnegie Mellon and I saw this memorial brick;
Eschew Obfuscation

It got me to thinking about some of the monster databases that I have had to take over for clients.  When I take over a project, often I am spending a great deal of time just trying to figure out what the developer was trying to do.

Our earlier posts on this blog are generally concerned with improving the user experience(better printing workflow) or getting more out of your data (One Report two sets of summarized data).  Today I would like to return to that lowly person, the developer.  Anything that I can do that can make my job easier will make be a better developer and ultimately make my customers happier.  Or as my grandfather would say to my grandmother, “What would you do if I got hit by a bus?” Continue reading ‘Speak your Mind. Using Comments, part 1.’

 

Customizing the Toolbar in FileMaker Pro 11

The status toolbar is the gray area located horizontally across the top of a FileMaker Pro 11 window and can be easily customized to suit your needs. If you’re using older versions of FileMaker, the status toolbar combines all of the functionality of the old status area, which was located on the left side of the window, and the optional standard toolbar, both of which existed in versions prior to FileMaker 10. By default the status toolbar comes loaded with commonly used features, such as record navigation (the book), Show All, New and Delete Record, and Find. Depending on how you use FileMaker, there may be other buttons that make more sense for you to have on the toolbar. With a few clicks, you can set up your FileMaker toolbar however you’d like.

Continue reading ‘Customizing the Toolbar in FileMaker Pro 11′

 

Please Join us June 22nd: Using FileMaker as a SQL Front End

Greetings FileMaker Enthusiasts,
Our next Philadelphia FileMaker User Group meeting has been scheduled for Tuesday evening, June 22nd 2010 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
As always, pizza and soft drinks will be provided.
Please RSVP here if you are planning to attend this meeting:

USING FILEMAKER AS A SQL FRONT END

 

Easy Navigation between Form / List / Table views in FIlemaker 11 using ‘View as:’

It doesn’t matter what route you take if you don’t have a destination

-or-

Trigger happy

One thing that I really like about the direction that FileMaker has been going in since version 9 has been how the programming environment now encourages of the use of native UI features in FileMaker in highly customized solutions.  Those of us who have been developing prior to FileMaker 9 – or those of us who have inherited solutions built before 9 –  know all too well what it means to lock down the Status Area and then build core UI elements from scratch to replace the lost functionality.  Many developer-hours have been spent to ‘reinvent’ features that were already in FileMaker, but in prior versions couldn’t be modified well enough to work in certain situations.

A clear, obvious example of this is the Toolbar.  Almost every single ‘professional’ system I have worked with by default hides the Toolbar, and then the developer is forced to reinvent the forward and back buttons, the book/rolodex widget, and every other element of the Toolbar using buttons and scripts on the layout itself.  What a waste of time!

In this blog post I’m going to look at one small segment of the Toolbar – the “View As” widget – as an example of how the Toolbar can be leveraged using Script Triggers. Continue reading ‘Easy Navigation between Form / List / Table views in FIlemaker 11 using ‘View as:’’

 

Easy Master-Detail in Filemaker 11 Using Filtered Portals

The Problem: Creating Master-Detail interface elements in Filemaker 10 and earlier was not straight forward.

Masster-Detail

You’d have to create a field to store the id of the currently selected record, then create a relationship matching just that id. If you’re in a multi-user setting you’d have to make sure the id storage field was global, so that selection was per user, not per record, otherwise you’d have the problem when one user changed the selection the selection would change for everyone.

The Solution: Now in Filemaker Pro 11 that all goes away with Filtered Portals.

Setting the global variable can use the same mechanism (onObjectEnter) on the portal. Remember though, in Filemaker Pro 11 you’ll need to add a refresh to update the portal.

Set Selected ID

Now all you have to do is set a script that sets a global variable, drop a relationship on the layout (potentially the same relationship you make the selection from) and filter it by the selected id.

Filtered Portal

Set the Calculation of the Filtered portal to match the selected ID with the record ID

Now you’ve got a simple interface that is easier to maintain and modify.

 

March 23: Please Join us for an exclusive look at FileMaker 11!

Greetings FileMaker Enthusiasts,
Our next Philadelphia FileMaker User Group meeting has been scheduled for Tuesday evening, March 23rd 2010 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
+  Google Map: http://tinyurl.com/37mhhh
As always, pizza and soft drinks will be provided.
Please RSVP here if you are planning to attend this meeting:

Join us for an exclusive look at FileMaker 11!

We have a very special featured speaker coming from FileMaker this evening – Matt O’Dell, our regional FileMaker Systems Engineer!
Matt will be giving us an overview of the new features in FileMaker 11, and their implications both for making life easier for FileMaker users and for new techniques for the developer.  Matt’s presented to PFUG twice before, most recently on using server OS and FileMaker scripting and Script Sequences, and we’re pleased to have him back.
What’s new in FileMaker 11?
FileMaker Charts!
Quick Reports in Table View
Snapshot Links
Recurring Imports
Quick Finds!
Inspector – a master tool palette for layout design
Object Badges
Built-in Invoice Starter Solution
Layout Folders
Portal Filtering
Scripting Enhancements
Improved File Security, including specific file access authorization
Variables in Find Requests and Merge Fields
We’re looking forward to this presentation, and hope you’ll be able to join us.

About the Speaker:

Matt O’Dell is a Systems Engineer with FileMaker in the Northeast US and Canada. He has 11+ years experience using FileMaker and building web solutions. Along with being a certified FileMaker Developer, he also is an authorized FTS trainer and a certified MySQL 5.0 developer. Prior to working for FileMaker, Matt was an application developer, trainer, and  tech support professional with Soliant Consulting in Chicago.