Export Just What You Need in FileMaker

The Lesson of Context

One of the first lessons I learned with FileMaker is that of context! Layouts, reports, calculations, scripts, and so on all act from the perspective of a single Table Occurrence (TO) — the “context” — pulling in data from related tables as needed.

Generally, the record set being acted on is the set of records in that context table occurrence or a found subset thereof. There are a few exceptions to this, however, and today we’re going to explore one of those.

Continue reading “Export Just What You Need in FileMaker”

Recycle Your Data | Save Space and Money

A few years ago, I worked on a FileMaker project where the client told us that every week they need to import about 7,000 rows of data that represent some information that this company uses. And every week there might be some modified records, some records that don’t show up any longer, and some new records that hadn’t already existed. For this example, let’s just call it this data “Products”.

Continue reading “Recycle Your Data | Save Space and Money”

Fun with FileMaker Button Bars, Part 2: Expert Panel

Fun with Button Bars, Part 2: Expert Panel

Have you ever had a FileMaker design conundrum for which you wished you could convene an Expert Panel to help guide you? If you’re thinking “panel of experts,” I can’t help you, but if you’re looking for a more flexible and visually engaging alternative to FileMaker Tab Panels, this combination of a slide-panel control and a button bar just might be your “Expert Panel.”

Continue reading “Fun with FileMaker Button Bars, Part 2: Expert Panel”

FileMaker Client installers with FileMaker Cloud

If you purchased your FileMaker Cloud server with user connection licenses,  you may well wonder “Where do I get the client software to connect to my server?”.

A fair chance you’ll initially land on the screen below. This seems relevant, but there’s still no indication here how you can download the FileMaker Pro clients you have licenses for.

Continue reading “FileMaker Client installers with FileMaker Cloud”

Use Amazon OpenID authentication with FileMaker Cloud

Here we’ll list the steps you’ll need to enable authentication using Amazon accounts with FileMaker Cloud.

If you’ll be having more than a few different people logging in to the Admin Console of your FileMaker Cloud server, it’s generally good practive to avoid having everyone use the same credentials. By enablling an additional authentication mechanism, you can easily add or remove administrative access to a server,  and user’s get to use their own own credentials.

Continue reading “Use Amazon OpenID authentication with FileMaker Cloud”

What’s this "Sign in to FileMaker Server" dialog?

If you’ve installed the FileMaker Pro client using a “For Teams” license, or as part of your FileMaker Cloud server usage, you may see a new dialog in FileMaker Pro.

In version 15, FileMaker has introduced a a new user-based licensing model. With FileMaker for Teams and FileMaker Cloud, a license allows use of Server and Client software based on the number of subscribed users.

Continue reading “What’s this "Sign in to FileMaker Server" dialog?”

Using an AWS Reserved Instance with FileMaker Cloud

We’ll discuss how you can use a one or three year reserved instance for your FileMaker Cloud instance. This can shave 30% or more off your AWS instance charges.

Determine Usage

When you spin up any new AWS based VM you will by default be using an hourly instance. This can be perfect for short-term usage or where your usage may fluctuate frequently.

Continue reading “Using an AWS Reserved Instance with FileMaker Cloud”

Restart interrupted FileMaker Cloud deployment

If you had started a FileMaker Cloud deployment, but lost access, accidentally closed the page, or had some other issue that caused the process to stop, you may be able to restart your deployment easily by going to the AWS Marketplace and checking your history.

Continue reading “Restart interrupted FileMaker Cloud deployment”

Step-by-step for FileMaker Cloud

Introduction

Although setting up your AWS account and creating a new FileMaker Cloud instance is a fairly easy process, it does have dozens of steps, and a few places where you could easily take a wrong turn. On this post we’ll go through each step in the configuration of your Amazon AWS account and requesting your first server.
Continue reading “Step-by-step for FileMaker Cloud”

1 2 3 4 16