The IsEmpty function is a developer favorite, as is its opposite, Not IsEmpty. Quite often a developer will test a field for any content to ascertain the status of a record: someone who has responded, or it active in an organization, for example. IsEmpty IsEmpty( field) FMP Version: All Current Versions Of FileMaker This function […]
SIMPLE ANSWER? When the global field is the parent in a relationship. In any relationship, the record on the parent side is a single value that is the same in a matching field in one or more child records. Think of an invoice and line items on that invoice. The invoice number, say 1003, would match […]
OK, I’M TALKING ABOUT TABLE OCCURRENCE relationships here, not the other kind. Although those might get more hits… Dwayne Wright explores the basic different types of relationships that are possible between two tables: …there is a feature in the FileMaker define relationship dialog box, you can define what is a compatible relationship. For example, say we have […]
SMALL ORGANIZATIONAL TIPS are often overlooked in the overall picture. Meaning the new or intermediate developer doesn’t get up to speed quickly on tricks that would help organize his efforts. This video from Dwayne Wright shows a simple concept for organizing layouts into folders–simple yet powerful for keeping a handle on where things are in a larger […]
ONCE YOU GET YOUR MIND AROUND THE CONCEPT that records in a portal are just related records in another table, report generation becomes so much easier: It might help you to understand the options you have in printing your portals, if you take a moment to think about what portal data really is … related records […]
DWAYNE WRIGHT delves into importing folders full of images or files automatically: Simply put, you can import a folder full of files in one shot. Before this feature came along, you would have to manually select each file you wanted to import one file at a time. The import folder of data feature works specifically […]
Import Folder Full Of Data Into FileMaker | Fil...: […] Import Folder Full Of Data Into FileMaker | FileMaker Thoughts. Simply put, you can import a folder full of…
THIS TECHNIQUE has withstood the test of time: Dwayne Wright’s Save Found Set routine makes use of error checking, lists, and multiple line keys to restore a found set of records by ID. This could come in handy if you are required to keep historical reports for a particular found set – new records added […]
ERROR TRAPPING is an important part of scripting in FileMaker–and not just to keep users from landing where they shouldn’t. Dwayne Wright shows the basics of error capture, which you can use as a model to test for any error or a specific error: Part of the solution to reacting to a variety of errors […]
DYNAMIC SORTS HAVE BEEN AROUND A WHILE (as this video, recently reposted, shows), but are always worth re-visiting. Dwayne Wright’s video on this still timely. Check out how sorting by a value list changes the dynamic. Dynamic Sorts For FileMaker Explored – YouTube.
EfficientBizz: I've been told (and actually believe) that cartesian [x] and comparable [≥≤] operators are speedkillers. To avoid cartesian, i have…