With Carafe Kitchen, implementing JavaScript into your Claris FileMaker 16+ solutions has become as easy as copying a script. With all the new features in FileMaker that are supporting JavaScript, the one thing that I found lacking and still difficult to overcome was a solid process for managing and implementing JavaScript libraries. After struggling to roll my own implementations that could be maintained easily, I was relieved and excited to find this valuable tool. Carafe Kitchen has been one of the most exciting FileMaker tools for me this year.
Looking to other industries for operational wisdom can be quite beneficial, especially when that industry has accomplished great things. In this presentation, we’re going to look at the incredible safety record of the airline industry in the last ten years, and compare that to software project management. What does it take to mitigate the well-known human factors in our projects so that we can complete things on time and on budget? Find out in this presentation, Preventing Disaster: Completing Projects With Zero Fatalities.
With the advent of Claris FileMaker 19, we are starting to see some new FileMaker add-ons, a brand new feature that is still technically “coming soon” according to Claris. One of the first products available for FileMaker using the new add-on architecture is the newly revised DayBack calendar product from Seedcode. We have been integrating the DayBack calendar for many years now and have seen the product evolve over time. This latest edition is taking advantage of many of the new FileMaker 19 capabilities, and has some really great new features. I’d like to go over some of the similarities and differences between “DayBack Classic” and DayBack 19 as well as benefits to upgrading.
Relationships are the basis of relational database design. When set up properly, table relationships will ensure your database runs like a well oiled machine. However, sometimes we run into systems where relationship keys are open to the user, exposing data to the risk of human error if a relationship is changed improperly. It’s sometimes desirable to refactor these relationships to use a proper artificial key relationships to connect tables, a laborious task depending on the size of your database. This post discusses a convenient trick to populate Primary Keys, a reminder about mismatched data types, and a modular script to help populate foreign keys when refactoring a key relationship.
We had an interesting request on a recent project where the client wanted to navigate two portals on a layout using the keyboard. The portals needed to be setup in a way that makes them appear to be one large portal with a static header row in the middle. The client also wanted the interface design to allow for very fast data entry. We concluded that using the navigational keys to navigate the portal would be the best choice, since it performed similar to navigating a spreadsheet.
Developer’s have been able to run SQL queries against their FileMaker data for many years. In the early days it required a 3rd party plugin, but since version 12 we’ve been able to run SQL Select statements against our FileMaker data with the native Execute SQL function. RazorSQL can be a big help.
