Portage Bay
Solutions
Portage Bay

Modular Filemaker Database Export

Modular Filemaker Database Export

    Recently, we had a client request to export their FileMaker solution into CSV files with field names. The solution had a sizable number of tables, though doable manually, it inspired me to look for a more automated method. Much to my dismay, a script or module that fit our needs did not present itself. But I learned quite a bit about FileMaker exporting in the process.

Updating FileMaker Files in iOS

Updating FileMaker Files in iOS

The process of updating FileMaker files in iOS has always been sort of a question mark, with multiple ideas for how to best accomplish it, each with their own limitations. At PBS, we developed a process to update files in iOS a number of years ago, but we’ve updated the process with some of the newer FileMaker 18 features that make the process more seamless, while altogether giving it a more native look and feel.

Refactoring Primary Key/Foreign Key Relationships in FileMaker Pro

Refactoring Primary Key/Foreign Key Relationships in FileMaker Pro

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.

Navigating Portals Like a Spreadsheet

Navigating Portals Like a Spreadsheet

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.

Master Detail Slide Control

Master Detail Slide Control

FileMaker 17’s new ‘Master Detail’ interface object allows the user to see and interact with a portal of the current found set and the detail of a single record at the same time. It can be very helpful in allowing the user to work with their data in a detail view, while staying in the context of a list of records. It’s easy to implement and even easier for users to navigate. Though the portal is handy when it’s being used, it’s often taking up valuable real estate when not in use. So, we’ve developed a helpful enhancement on the basic Master Detail implementation that utilizes the slide-control panel to show and hide the Master Detail portal when not in use, while still allowing quick access when it’s needed.

Sharing FileMaker Variables in Multi-file Solutions

Sharing FileMaker Variables in Multi-file Solutions

When working with multi-file solutions in FileMaker, sharing variables can be a stumbling block. In this blog, I will explain the process we chose when we built the Button Bar Sort Headers solution. It is one of my favorite techniques for sharing variables when they are needed for field calculations.

Aggravating Differences with Aggregate Functions

Aggravating Differences with Aggregate Functions

Aggregate Functions are the lifeblood of data analysis. However, aggregate functions can often be a little confusing. Things like variable field references, single constant values, or calculating empty values can all cause confusion if you are not familiar with the nuances of aggregate functions.

Simple Javascript Tasks

Simple Javascript Tasks

FileMaker’s web viewer is often referred to as a “black box” within the FileMaker framework. There are seemingly endless uses hidden within it’s confines, from simply displaying a webpage to integrating Google calendar into a FileMaker solution.