Portage Bay
Solutions
Portage Bay

FileMaker

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.

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.

Portage Bay FileMaker Demos

Portage Bay FileMaker Demos

The current incarnation of our Blog was first published 6 years ago. During that time we’ve posted a lot of blog articles, included a number that include sample files that demonstrate a variety of techniques and ideas for features in FileMaker.

FileMaker 17 Default Fields

FileMaker 17 Default Fields

In one of our previous FileMaker 17 videos on YouTube, I touched briefly on the new “Default Fields” functionality introduced in FileMaker 17. In this post, I’ll be diving more into this feature, explaining how it works and how to customize it for your own use.

Modular Date Range Chooser

Modular Date Range Chooser

Are you looking for a reusable tool to be integrated with your FileMaker solution that provides an easy to use date range chooser popup window? Look no further! Portage Bay has created the Modular Date Range Chooser which can easily be added to your solution, either by copying and pasting the components into your existing solution, or linking the file as an external widget file. I am currently in the process of uploading this to modularfilemaker.org so it will be available to any FileMaker developer.

Introducing the Map Widget

Introducing the Map Widget

We are pleased to announce the release of our Map Widget v.1.0 product. This is a new tool built natively with FileMaker which can be easily integrated into your existing FileMaker solution. The Map Widget provides you with the ability to display your FileMaker data as locations on a Google Map, using the Google Maps clustering functionality. You can easily interact with the Google Map, click on each pin, display details about the location, and even click a link to return you to that specific record in your FileMaker solution.

FileMaker Devcon 2018 Recap

FileMaker Devcon 2018 Recap

Grapevine, Texas in August may not be the first place most people would choose to spend a week in August. It's pretty warm. On the positive side, the parks and public places are pretty quiet. I visited Dealey Plaza, the site of John F Kennedy’s assassination as well as a Trinity Audubon center south of Dallas and both were pleasantly uncrowded. For FileMaker Devcon 2018, Grapevine was a pretty great location! The Gaylord Texan hotel is huge. I easily walked 2 to 3 miles a day just getting around the conference center and hotel. Good Exercise :)

Web Forms and FileMaker Integration Options

Web Forms and FileMaker Integration Options

Need to do some data collection from users who don’t have FileMaker? A survey, application, or registration? As with most things FileMaker, there are multiple solutions to this requirement. In this short blog post, I’ll be going over the option of using a web form (such as Google Forms) so that data can be collected on a website, then automatically pushed into the FileMaker database.

Top New Features in FileMaker 17

Top New Features in FileMaker 17

With the release of FileMaker 17, we’ve gone over some of the top new features in a video. Check it out to see the ability to send multiple attachments, enhanced development features allowing for quicker development time, and sensors and notifications in iOS. We will also release overviews of FileMaker Server 17 and Developer Tools in FileMaker 17 in subsequent blog posts, so look for those coming out soon.

Diagrams with Draw.io

Diagrams with Draw.io

We recently had a client request that we put together a high-level overview diagram of their application, including all the hardware/software used in hosting the solution, all external 3rd party integrations, and all the methods used to access the database. Despite being a long-time user of Microsoft Visio, I decided to start out on a search for a newer diagramming application.