Hello to all my friends and colleagues in Miami this week! I’m sorry I can’t attend DevCon this year, but I look forward to hearing all the latest and greatest FileMaker news. As a consolation prize, the weather in Portland is beautiful and OSCON is here, right down the street from my office. I’m not(…)
TIP: Sometimes we need to format numbers in a block of text, to send an email for example. We want comma separators: 1,000 — not 1000. I’d always thought this required a custom function, and there may be times when you do want to manage currency symbol or precision, etc. (For example, this.) There is(…)
I got some great responses to my last article, and I’d like to share a few of them with you (with permission from the developers). First up, from Chris Manton of BabelFix: rather than gathering the child IDs with a script, he set up a separate sorted relationship for each sort order. This lets you(…)
I am working on a FileMaker project that uses a “home” layout featuring a portal. The portal’s “parent” is a global text field containing a list of ID numbers. It’s related to an ID field in the child table. Nothing too unusual. Then I started looking at sorting the portal. One nice thing about a(…)
Kevin Frank has posted some excellent articles on FileMaker portal sorting recently: check out FileMaker Hacks. Another good place to find portal sorting examples is Database Pros. However, stay tuned for a new (and IMHO better) portal sorting technique.
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(…)
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(…)
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.