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.
Articles, Beginner, Quick Tips
- Who: Beginner-Intermediate
- What: How to Test for and Automatically Install a FileMaker Plugin
- With: FileMaker 15 +
- Why: Instead of manually installing plugins for all your users, script it on opening!
Articles, Beginner, Quick Tips
- Who: Any Level
- What: How to Commit the Specify Calculation and Set Variable Options Windows with Key Strokes
- With: FileMaker 15 +
- Why: If you prefer using keystrokes for efficiency, use this technique