IT PAYS to dig deep into the themes and styles part of FileMaker 13. Rob Poelking shows a work around for a problem that was bugging him: Have you tried setting the color or opacity of your portal object only to find that it doesn’t seem to take? That happened to me and it took […]
ALWAYS BE ON THE LOOKOUT for simple, effective tricks. Larry Keyes describes one such trick for building a quick and dirty FileMaker SQL Query Screen. Note that this isn’t a full-blown SQL implementation, it will only respond to SELECT statements. (You can’t INSERT or DELETE, for example. Also, if there any problems with your […]
DWAYNE WRIGHT demonstrates some interesting and useful techniques in the process of duplicating records using an array: Building lists, getting list values, list counts, and lots more. Published on Apr 25, 2014 This is one of my longest straight uncut videos of all time and I only struggled in a few places and had just […]
I’LL ADMIT IT: I haven’t done much translating to and from Unicode. Kevin Franks has, and with an assist from Jeremy Bante, put together a FileMaker utility file with all of the conversions. This weekend I threw together a Unicode utility file (unicode-characters.zip). It takes the values 1 through 65535 and converts them into Unicode symbols, […]
SOMEHOW I missed this technique for counting unique records in a portal or found set. Thanks to Nick for tracking it down. …but how can I show a count of my sales people?” There are various ways to solve this problem, and it’s a problem worth solving, because once you have this technique under your […]
THIS WEEK: The Situation, Portal Styles, Cash Cow Filemaker Success Tips : 295_FM_Success_Tips.
SOME BASICS ARE TIMELESS. Exporting files in FileMaker is one. Dwayne Wright explains the process: A situation may arise where you want to take some of the data you have gathered in your FileMaker solution and (move / copy) it to another database, software package or spreadsheet. This process has a name and it is […]
FORWARD AND BACK BUTTONS using the latest FileMaker capabilities. And best of all, it’s modular! Give Paul Jansen’s modular solution a test run–you’ll love it. BrowserNav adds web browser like layout navigation history and requires a single script, one custom function (Optional) and back and forward buttons. Once the script and custom function have been added to […]
A FAIRLY SHORT video showing how to build a versatile solution using FileMaker and FileMaker Go: Published on Apr 30, 2014 Need a custom business solution that works where you work; be that on train, plane, automobile, office, home, etc.? The FileMaker 13 Platform makes it easy for anyone to create custom business solutions for iPad, […]
GREAT ADVICE from Richard Carlton on scaling a FileMaker database to a 100 users. He lists very specific steps–reduce calculations and portal sorting, for example–that will improve performance as the user count increases. Making a database that can work with 100 simultaneous users is not something that is easily done for a novice developer. We have given […]
I HADN’T given much thought to changing a timestamp from text to a timestamp. Didn’t even think it was necessary. But it turns out there are some instances where it is. Daniel Shanahan shows us how: FileMaker Server has a timestamp on its log. However, when you export the log data and import it into […]
AN INTERESTING LOOK at unintended consequences when working on a live FileMaker database by Kevin Franks. I’ve experienced occasional problems when doing so and was not able to reproduce them. It seems that if a user adds a new record (manually or via script) while the developer is doing any of the following causes the problem: […]
TROI announced the beta release of their powerful File Plugin: Troi File Plug-in 7 Troi File Plug-in is a very powerful tool for getting access to information outside the FileMaker Pro database. Any files stored on the rest of the computer can be accessed through the functions of the plug-in. Troi File Plug-in 7.4.9.1 beta […]
PART 2 OF THE PERFORM SCRIPT ON SERVER series from Vince Mennano. You’ll want to study this one as closely as Part One: Are you ready to experience a whole new level of User Interaction? Now, go ahead and drag the “BabyNamesInArizona.xlsx” file into the “Drag file to be imported here” area. Then all you need […]
- FileMakerProGurus: […] into a usable timestamp. Watch this if you want to improve those skills. Part 1 can be found here. FileMaker…