by nautilusfm_muk48m | Jan 19, 2020 | Blog, FileMaker Tips, Quick Tips
When you want to display all records from a table in a portal, there are two ways to create the relationship; one of them is absolutely the wrong way to do it, The right way is to use a cartesian join and the wrong way, because it’s considerably slower, is to...
by nautilusfm_muk48m | Jan 19, 2020 | Blog, FileMaker Tips, Quick Tips
Go to related record or GTRR as it is more commonly known is a function that all FileMaker developers use all of the time because it is incredibly fast and efficient but what is FileMaker doing behind the...
by nautilusfm_muk48m | Jan 19, 2020 | Blog, FileMaker Tips, Quick Tips
Windows flash (which is really annoying) happens when you are running a script that is constantly opening and closing windows but this simple trick will show you how to eliminate them. All you have to do is open the new window off-screen leaving nothing to...
by nautilusfm_muk48m | Jan 19, 2020 | Blog, FileMaker Tips, Quick Tips
If you’re going to a set of related records in order to perform an action on those records, i.e., delete, them, you MUST first trap to see if there are actually related records to go to. If you don’t do this, the action that you were going to take will be...
by nautilusfm_muk48m | Jan 19, 2020 | Blog, FileMaker Tips, Quick Tips
One of the most used and useful calculations I know is to multiple any number (positive or negative) by -1 (minus 1) which turns a negative into a positive and vice...
