FileMaker and IT, Computer News
Using Add-ons via a Charting Example
FileMaker Date Formats & Functions
Avoiding Record Locks
Prettifying Your UI
Multi-Criteria Portal Filtering
Universal Record Marking
Who doesn't need to mark subsets of records? I've rarely, if ever, worked on a solution which couldn't take advantage of simple record marking. Whether it's for creating a user based subset or simply toggling an active or favorite value. Marking records is something...
Using Custom Menus
FileMaker Error Codes – How to use them
Choosing the Proper Data Storage
One of the more troublesome questions we ask ourselves as developers is "Am I doing this the right way?". And, while it applies to most all situations, it most certainly applies to data structure. If you don't structure your data well enough, then you either have to...
Best Default Fields
When you consider every little action you take while creating any type of software, if you add all those actions up, you can end up with a lot of extra repeated steps. In consideration of all the fields you may be creating for various utility purposes, along with your...
Hide Object When Calculations
Sometimes it's nice to revisit the basics and make sure you've covered all your bases when it comes to what you can do with certain features. In this video, I take a good look at using the Hide Object When calculation and cover the various options I'm familiar with....
Access Controlled Button Bars
If it's not absolutely necessary, preventing a user from accessing parts of your software is a bit better than letting them know what's possible or what's hidden from them. It also allows a given group of users to focus better without presenting options which may not...
Copying Filtered Portal Data
In FileMaker, once you've filtered a portal, which displays a subset of related data, there may be situations where you need to get that data out. A prime example is needing to further manipulate the data within a spreadsheet. A recent solution I was developing had...
Saved Search Queries
While there are some features which FileMaker provides natively, I often wonder how heavily they are used. One feature in particular is the Saved Finds feature, which is only available in Find Mode. It's a great feature in terms of convenience, however, its...
Filtered Portal Record Counts
In FileMaker, some features seem like they should be an easy solve. Yet, the dynamic nature of creating something in FileMaker means its development simply can't account for all the possible things a developer might want to do. When it comes to showing the actual...
Database Discovery & Intelligence
Better Drop-down Lists
Oh the pain of a slow rendering layout! The other day I came across a painfully slow layout which was literally CRAWLING. It reminded me of one of my own situations where I needed to create a solution for some type of creative data input. This, of course, was based on...
