LOOKUPS VS CALCULATIONS. Which do you use and why? Would you kill off lookups? Any time you can introduce the calculation engine in a place you wouldn’t expect it, your design options extend radically. The auto enter via a calculated result is no exception. For traditional lookup duties, consider using an auto enter via calculation […]
A FOLLOW UP TO DWAYNE’S FIRST POST on moving data from repeating fields: I’m thinking that I might have to introduce some of you to the concept of repeating fields. Right now, there are probably more developers that never spent quality time with repeating fields, than us long time veterans that remember when the repeating […]
THIS TAKES ME A BACK A WAYS: Back in the day, (and I’m talking way back), FileMaker didn’t have portals. Portals were introduced along with FileMaker 3 in 1995. Right now, there are probably more developers that never spent quality time with repeating fields, than us long time veterans that remember when the repeating field […]
A basic cross tab report method by Dwayne Wright. GeneralCrossTab – YouTube.
A READER ASKS: Misbehaving FileMaker Calculations SUNDAY, NOVEMBER 17, 2013 AT 5:15AM From Dwayne Wright PMP, PMI-ACP, CSM Certified FileMaker Developer WEB: www.dwaynewright.com EMAIL: info@dwaynewright.com TWITTER: dwaynewright YOUTUBE: FileMakerThoughts A READER ASKS Sometimes an employees’ total number of hours worked is calculated wrong. It’s a simple adding calculation, so I’m at a loss as to how […]
Mimic The FileMaker Record Status MONDAY, NOVEMBER 11, 2013 AT 7:13AM From Dwayne Wright PMP, PMI-ACP, CSM Certified FileMaker Developer WEB: www.dwaynewright.com EMAIL: info@dwaynewright.com TWITTER: dwaynewright YOUTUBE: FileMakerThoughts This is a dated example file, almost ten years old now. However, it may have some elements that beginner FileMaker developers might find interesting. In this example file, we have built two […]
Go To Next FileMaker Record Failure SATURDAY, NOVEMBER 9, 2013 AT 4:13PM From Dwayne Wright PMP, PMI-ACP, CSM Certified FileMaker Developer WEB: www.dwaynewright.com EMAIL: info@dwaynewright.com TWITTER: dwaynewright YOUTUBE: FileMakerThoughts Nothing ground breaking here but I wanted to share how a looping script, set error capture and validation have to be tweaked properly to work in concert correctly. I just imported […]
Scripted Omit Constrain Within A Found Set Via A Value List SATURDAY, NOVEMBER 9, 2013 AT 4:09PM From Dwayne Wright PMP, PMI-ACP, CSM Certified FileMaker Developer WEB: www.dwaynewright.com EMAIL: info@dwaynewright.com TWITTER: dwaynewright YOUTUBE: FileMakerThoughts The following situation came up in a recent “One On One Virtual FileMaker Training” session and I thought I’d share it with you. The resolution covers […]
FileMaker Formatting Via Presentation And Data Layers SATURDAY, OCTOBER 12, 2013 AT 6:09AMFrom Dwayne Wright PMP, PMI-ACP, CSMCertified FileMaker DeveloperWEB: www.dwaynewright.comEMAIL: info@dwaynewright.comTWITTER: dwaynewright YOUTUBE: FileMakerThoughtsNow I have chatted quite a bit about formatting data on a FileMaker layout because it is an essential element of database design. In many ways the formatting choices you make […]
Business Minute 21 - Testing and Measuring - FileMaker Pro Gurus: [...] Dwayne Wright on Data and Presentation Layers [...]
Based on a readers email, one method to have a value list populate the appropriate AM/PM options for a time field. TimePop, A FileMaker Database Example – YouTube.
FMPSQL_Email – YouTube.
Video of Steve Jobs's first public demo of the Mac resurfaces after 30 years - FileMaker Pro Gurus: [...] NINETY MINUTES LONG. Watch the beginning of the Mac era… [...]