I posted on ClickWork’s trick to trigger a script on a remote client back in August, and was very impressed with the concept. Richard Carlton likes it so much he made a video demonstrating some of the possibilities: Published on Jan 7, 2015 FileMaker does not natively contain this ability on its own… and […]
Although this article is an advertisement for Productive Computing’s server based services, it covers all of the arguments for using remote servers for a FileMaker server hosting solution: Server Hardware Installation and configuration Expertise Server Maintenance Security Bandwidth Uptime Backups Licensing Server Hardware Server hardware is a big ingredient in the performance and wellbeing of […]
I started working with FileMaker 13’s new Install Plug-In File script step recently after watching Matt Petrowsky’s video on this subject. After careful study, I modified a client ‘s beta database to install two plug-ins (Base Elements and 360Works Scribe) on startup. And immediately started having problems with registration on the Scribe plugin–the plugin was […]
One of the most frustrating issues when dealing with ExecuteSQL is the dreaded question mark (“?”) FileMaker returns as the result of the malformed query. Your query does not work for some reason, but you have no idea what the problem is. Daniel Wood, of Digital Fusion, stumbled upon a method to coerce a useful error […]
Something new to learn over at FullCity Consulting: a way to use the Sign function to optimize code: How about a real-world example? We can use Sign in combination with our friend the Choose function to generate a message to appear on an invoice or statement. This calc will show an appropriate message whether the customer owes you […]
I’ve been browsing the FileMaker help site and found a some interesting FileMaker tips to share: Saving a layout with an unknown object causes slow performance and file size increase Saving a layout in FileMaker Pro 12 that contains an unknown object or an object from a newer version of FileMaker Pro causes the file to become slower and slower and the […]
Shawn A. Krueger: "This issue only occurs when the host machine is on Windows." Solution: Get a Mac! ;^)
Don Clark: That's what I use!
Don’t miss this! Jesse Barnum, of 360Works, will be presenting via teleconference at the upcoming New Mexico FileMaker User Group meeting Tuesday, 1/13/15. Jesse will be covering MirrorSync, 360Works FileMaker synching software solution. Afterwards, he will be taking questions and answers. The meeting starts at 5:30 PM MST, and Jesse will present starting at […]
Guy Stevens is back! It’s been a while since he made any FileMaker videos, and for his return he tackles FileMaker audit logs. His 30 minute video presents one way to add auditing to your solution. The comments are mixed, as the solutions requires a lot of work to implement. To be fair, the motive driving […]
Shawn A. Krueger: There are many ways to do an audit log. This one seems like one of hardest. The first change I…
Don Clark: I agree, Shawn. Not one of his better efforts. He could make that more modular.
Geist Interactive announced FMQBO, a beta product designed to connect FileMaker to QuickBooks Online (QBO). This is big news for Mac users, as QuickBooks integration has never been available to Mac users in any way: Filemaker QuickBooks Mac Integration We are releasing a new product called, FMQBO. FMQBO connects FileMaker 12 or 13 running on Macs (and/or PCs) […]
Integration with rest of the world is increasingly important for FileMaker developers. There are many instances where that integration requires fetching data and bringing it into a FileMaker database. There are many established ways to to make data available for other developers to fetch: XML, JSON, .csv files, etc. Today’s topic is JSON and FileMaker. JSON (JavaScript Object Notation) uses name/values pairs […]
All work and no play is never any fun. So let’s start the new year with a bit of fun before getting down to business: Stuart Gripman built a database that generates ancient insults: Old Timey Insult Generator – FileMaker Database. This guy found a piece of his T-bird inside his arm 51 years […]
The Count function is a scripting staple for FileMaker developers, and it is used in a variety of ways, usually as a way to count related records as some sort of a test. But as Stuart Gripman points out, it is really handy in the same table, as well: Count simply tells you how […]
Version 0.73 is the latest, and this new release includes improved Python list & set support, and allows additional parameters to shell commands. So, what is bbox, you might ask? It’s a free FileMaker plugin from Beezwaz for Mac users: bBox FileMaker external plug-in is a toolbox of functions freely available to all developers. Use it to extend […]
Gianandrea Gattinoni: Very interesting, but unfortunately, I found some errors in the demo file (field definitions, queries, etc.) f.i. invoice::number and invoice::total…
Don Clark: Good catch! I don't normally have time to dig into these files until I need to use them.
What would you change or add to FileMaker if you had a magic wand? Ryan Klenk of Anvil Dataworks offers up his wish list of goodies: FileMaker has always been great at consistently developing and delivering new features to their platform and it’s allowed us to create some awesome solutions for our customers. Even so, […]
Rick Rowland: I'd like to see some simple looping in calculations. What I could write in Delphi as X := 10; for…
Don Clark: That would be nice, indeed!
Jan Stieperaere: Hi Don, Thx for the great review! Grts, Jan Stieperaere Clickworks Belgium
Don Clark: You bet, Jan!