How do you offer your FileMaker users the ability to sort portals?
One method that’s been around a long time is to create a calculated field in the “child” table (the table whose records appear in the portal). This calculation is used as the portal’s sort field. The formula can become somewhat complex if it needs to account for a mix of data types, e.g. fields for date, text, number, etc. And if you want to sort by multiple fields, it gets even messier.
Another method has gained traction since the advent of tab objects (in FileMaker 8), and that is to create multiple copies of your portal. Each copy is placed on its own tab and given its own sort order. The addition of object names (in 8.5) and zero-width tabs (in 9.0) further refined this technique.
The problem with both of these methods is maintenance. In the first method, the calculation has to be revisited any time you change the fields in the portal. And in the second method, making changes to multiple copies of a portal is just a pain.
The method I’m going to show you does use a calculated field, but it’s relatively easy to grok and you never have to change it. Sound interesting? Stay tuned!
Today FileMaker Server 11 Advanced failed to start on my iMac running OS X 10.5 (it’s my developer server). I could launch the admin console and click the start button, but nothing would happen. The FMS command line was no help either.
Fortunately I have an archive of email from the fmpexperts mailing list. A year-old post from Stephen Wonfor (thanks, Stephen!) provided the answer, which was contained in this link:
Terminal Tips: Rebuild your Launch Services database to clean up the Open With menu
I downloaded the free utility Maintenance, ran it, and chose the rebuild LaunchServices option. Problem solved!
This is hilarious. I don’t remember hearing about this before, how is that possible? My first DevCon was the following year, but still…
If you use Gmail, I highly recommend you press Shift + ? right now!
(After you load Gmail, that is.)
The Pause On Error (FileMaker® Developer’s Unconference) is coming to Portland Jan 21-22, 2010. Looking forward to seeing friends and some great sessions. I’ll be hosting a FileMaker Tips & Tricks extravaganza that I think will be a nice way to wrap up the (un)conference.
Your users won’t notice it when it’s there. But they will notice when it’s not.
Nice article here.
If you use FileMaker 10 Advanced, customize your toolbar: Manage, Debugger, Data Viewer, and New Window can be one click away.
Thinking about making this site more active. Updated WordPress today, finally. Updated some of the WP plugins too, and slapped on a new theme. Not bad. Comments welcome.
The FileMaker Developer Conference is back in Phoenix this year. See you there!
Here are a few pictures from last year.
For those of you interested in knowing more about my session topics — plugins and credit card processing — I have posted some links and info that I think you will find interesting. Thanks very much to all of you who participated!
I’ll be adding things here and there, so check back occasionally.