Articles, Digging-Deep, Quick Tips
- Who: All Users
- What: How to Use Square Brackets Instead of Nesting Functions
- With: FileMaker 11+ (not sure how far back it goes)
- Why: Nesting with functions like Substitute can get tricky the deeper you go, but with square brackets you can add as many extra conditions as you need and keep it clean and readable.
Articles, Digging-Deep, Quick Tips
- Who: All Users
- What: How to Force an Auto-Enter Text Field Calc to Update
- With: FileMaker 11+ (not sure how far back it goes)
- Why: You don’t want to slow your solution down with an unstored calc, but the auto-enter calc is not updating when you need it to.
Articles, Beginner, Quick Tips
- Who: All FileMaker Developers who copy / paste items from one layout to another.
- What: How to copy from one layout and paste to another in the exact same place.
- With: FileMaker 12+ (likely earlier versions as well)
- Why: Copying layout items from one layout to another is often faster than recreating the item.