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.