Portage Bay
Solutions
Portage Bay

Tips

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.

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.

Tips for Previewing PDF in Windows

Tips for Previewing PDF in Windows

Working with PDFs in FileMaker can be tricky on different platforms since the behavior is not entirely consistent. One issue we’ve come across is the ability to preview PDFs directly in FileMaker Pro on Windows machines. Unlike on the Mac, where the PDF rendering library is built in, Windows does not have this library so the ability to automatically display PDFs in container fields is not available.  We’ve come up with three possible workarounds to solve this issue. Look for a demo file in an upcoming post to fully demonstrate these options.

Stories of Internet Cons

Stories of Internet Cons

As with most people who work in technology, I sometimes find myself in a tech support role during the holiday seasons (well, all the time really). I feel it's extremely important to encourage family members to think critically when sharing information or computer access with anyone out on the internet. There are two scams that I’ve recently had to deal with, and there are lessons to be learned from both of them. Hopefully by sharing these experiences, you can avoid having to deal with the negative consequences yourself.

A Perfect Pair - ExecuteSQL and PSOS

A Perfect Pair - ExecuteSQL and PSOS

This is a quick tip about how PSOS can vastly improve performance of the ExecuteSQL script step.  Recently we received feedback on one of our solutions that uses Execute SQL to build a virtual list used in a picker window. The feedback had to do with the slow performance of loading the picker window. The user complained of the window sometimes taking up to 30 minutes to load. Obviously this design was not ideal!

Impossible Spaces in Virtual Reality

Impossible Spaces in Virtual Reality

I have been fascinated with impossible places. Things like the Doctor Who Tardis, Hypercubes, and M.C. Escher’s impossible objects, lead me to happy daydreams. Lately I have been wondering, would it be possible to create some of these physically impossible spaces. Could I create them in Virtual Reality (VR), and if so, what would they feel like?

fmreauthenticate Refresher

fmreauthenticate Refresher

Have you ever needed a user to quickly pop into their FileMaker solution and not become disconnected when switching networks or putting the device to sleep? This is a common request for FileMaker Go users, but can also be useful for desktop users who keep their solution open all day. There are a couple different ways to make this work, but as I found out recently, there are also some things to keep in mind when you are troubleshooting.