Big news last month from Goya: Their free BaseElements Plugin has been updated to 3.1, and now supports SMTP and a host of other new features: And one more release note, we’ve updated the free BaseElements Plugin to 3.1.0. This is a huge release, lots of cool new features. This version removes support for Windows XP, so […]
Another AHA moment from a FileMaker developer, Robert Samnegård, of FileMakerbloggen.se: Have you always wished that you could control your iOS device from a distance or are you longing for a version of FileMaker Go that works with the Apple Watch? FileMaker Go 14, our example app and a cheap Bluetooth headset will take you […]
The Day Functions are a set of three very handy, built-in FileMaker functions, which, when combined with a few other functions, add the ability to manipulate the day portion of a date: The Day (Date) function hands back the numerical date of the date in its parameter. Put like that, it probably sounds a bit useless. If you’re […]
A nice example of using text functions to isolate data from a field by Stuart Gripman of FullCityConsulting: The past few posts have covered an array of text parsing functions. There are countless scenarios where you may need to manipulate text in FileMaker, but the two I most often encounter are data migration and data […]
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 […]
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 […]
Stuart Gripman’s post on GetNthRecord explains the function better than any other I’ve ever read, and the examples are clear cut and straight forward: This is exactly as straight forward as it seems. Replace fieldName with the name of a field in the local table and recordNumber with any number (within the total number of records in the […]
GetContainerAttribute: This function has 35 different arguments that you can send to it to get specific information about the item in a container field. FullCity Consulting gives us the use of the few of the more fun ones, and the full list is below: New in FileMaker 13, and previously fawned over in this very blog, is the GetContainerAttribute function. […]
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 […]
I like this function–it’s easy to use and can be called as a modular subscript if you send a variable or script parameter to it when invoked: WindowNames Simple database systems may be easily contained within a single window, but you don’t have to get too terribly complicated before popping a new window makes a […]
File this one under “something useful I learned today that someday will come in handy.” Somehow I did not remember (or perhaps really understand the use of) the use of the FieldComment function. But I have had times where having the comments available in the data viewer when in layout mode would have been helpful. […]
Thu, 16 October 2014 319_FM_Success_Tips No padding in table view, Latest Radioshack stuff, Get( Scriptresult ) and Dialog boxes Direct download: 319_FM_Success_Tips.mp3 Category:podcasts — posted at: 5:30 PM Filemaker Success Tips : 319_FM_Success_Tips.
One of the most frustrating situations in FileMaker is when you get a “?” in your calculation instead of the answer to the calculation. Stuart Gripman of FullCityConsulting has a very elegant solution for tracking down the error code lurking behind the “?” using the EvaluationError function: When FileMaker is faced with this, or any, unsolvable […]
A simple little twist that leads to an improved user interface. Bob Kelley of the Scarpetta Group combines the Get(windowmode) function with “Hide Object” feature in FileMaker 13 to only show/hide certain buttons when in Find mode, making it less confusing to users, and limiting their ability to change course in the middle of a paused […]