Due to FileMaker version 16’s new warnings about connecting to servers without SSL, after upgrading, some opener files simply don’t open files from FileMaker Server over the network like they did under previous versions of FileMaker Pro or FileMaker Advanced. The symptom: Many users use “opener” files, local files saved on their hard drives, to open FileMaker databases […]
This hidden feature of FileMaker has been documented elsewhere, but there’s a little quirk that isn’t always mentioned. You can capture a screenshot of your current layout in FileMaker by going into Preview mode, and selecting “Copy” from the “Edit” menu. This places a screenshot of the Preview on the clipboard. However, if you script this, […]
TL;DR: A corrupt record can cause sporadic performance problems in FileMaker databases, especially when accessing them remotely. I encountered an interesting error recently. A client database on which I am working remotely suddenly took much longer to open than it used to – increasing from about 20 seconds to fully open to about 4 minutes. The database […]
TL;DR: Legacy scripts and calculations which depend on values in container fields may break when those fields are converted to external storage. A rare circumstance, but worth filing away, maybe it’ll help someone with future troubleshooting: I was working on a legacy database yesterday, converting the numerous container fields to external storage to slim down […]
There is a discussion on Soliant’s blog of using the Char function and unicode Byte Order Marks to sort dynamically-generated value lists into a custom order. One of the comments was from a user that had a problem getting this technique to work in FileMaker Pro 11 with numeric fields. Here is an FM11 demo […]
