Data-driven iOS Apps for iPad and iPhone with FileMaker Pro, Bento by FileMaker, and FileMaker Go

Jesse Feiler is a developer,web designer, trainer, and author.He has worked with mobile devices starting with Apple’s Newton and continuing with the iOS products (iPhone, iPod touch, and iPad). His books include Using FileMaker Bento (Sams/Pearson), Sams Teach Yourself Drupal in 24 Hours (Sams/Pearson), Get Rich with Apps! Your Guide to Reaching More Customers and Making Money NOW (McGraw-Hill), Database-Driven Web Sites (Harcourt), How to Do Everything with Web 2.0 Mashups (McGraw-Hill), iWork ‘09 For Dummies (Wiley), The Bento Book (Sams/Pearson), and FileMaker Pro in Depth (Sams/Pearson). He has developed software on a range of platforms ranging from Mac OS X, iOS,Windows, and mainframe computers. His clients represent a variety of organizations, including nonprofits and governments, production management, publishing, and banking. He is the author of MinutesMachine, the meeting management software for iPad.There are more details at champlainarts.com. A native of Washington, DC, he has lived in New York City and currently lives in Plattsburgh, NY. He can be reached at northcountryconsulting.com.

Introduction



 

Part I: Data to Go

 

1 Making Data Mobile

Introducing the FileMaker Products for Mobile Computing

    FileMaker

    FileMaker Go

    Bento

What Mobile Data Means

Introducing the Reservations Example

    Entering Events

    Entering Reservations

    Processing Reservations

Looking at Reservations on FileMaker Pro

Looking at Reservations on FileMaker Go

    FileMaker Go on iPad

    FileMaker Go on iPhone

Looking at Reservations on Bento

    Bento on iPad

    Bento on iPhone

Looking at Reservations on a Mobile Browser

Further Steps

 

2 Introducing the FileMaker Architecture

Talking Databases

    Using the Relational Database Vocabulary

    Looking at SQL

Talking FileMaker

    Working with the Interface Tools

    Working with the GUI Development Tools

    Talking Security

Working with the Interface Tools

    Using Layout Mode

    Introducing the Layout Mode Tools

How to Standardize Layout Objects

    Scripts

How to Use a Script to Automatically Switch to a Mobile Layout

Working with the GUI Database Development Tools

    Tables and Fields

    Relationships Graph

Putting Together Layouts, Relationships, and Files

Creating a Layout

How to Create a Layout with the Layout/Report Assistant

Structuring Solutions and Sub-Solutions

Further Steps

 

3 Managing Data on the Move

Synchronizing, Copying, and Sharing Data

    Synchronization

    Copying

    Sharing

Managing FileMaker Pro

    Accessing Databases

    Sharing Your Databases

Managing FileMaker Server

How to Manage Databases on FileMaker Server

Managing FileMaker Go

    Accessing Local Databases

    Accessing Shared Databases

Managing Bento

How to Set Up Synchronization Between a Mac and an iPad or iPhone

Further Steps

 

4 Working with Mobile Devices

Working with Your Fingers

What to Do Without a Keyboard

What to Do About Text

What to Do About Graphics

Integrating Without a Visible File System

    Moving FileMaker Databases to Your Mobile Device

    Inserting Files and File References into FileMaker Databases

    Using Signature Capture

Using Multiple Files in FileMaker Solutions

Printing

How to Print with a PDF File

How to Print to a Printer for FileMaker Web Publishing

Further Steps

 

5 Preparing FileMaker for Mobile Use

Understanding the Mobile Difference

    Working with a Limited Keyboard

    Managing Your New Look-and-Feel

How to Use Autosizing to Change an Object’s Size

    Working Around Menu Commands

Data Entry Without Typing

    Using Auto-Enter Options

    Working with Value Lists

Using Conditional Formatting

Using Self-Labeling Fields

Further Steps

 

6 Introducing FileMaker Server

About FileMaker Server

    The FileMaker Server Product Line

    FileMaker Server Versus Peer-to-Peer Database Hosting

    FileMaker Server Capabilities

    FileMaker Server Requirements

Installing and Deploying FileMaker Server

    The Installation Process

    The Deployment Process

Running FileMaker Server

    Starting and Stopping FileMaker Server

    Hosting Databases

Using Admin Console

    FileMaker Server Overview

    Administration

    Configuration

Automatically Updating Plug-Ins

    Preparing FileMaker Server

    Preparing FileMaker Pro

    Performing the Auto Update

    Putting It All Together

Further Steps

 

Part II: FileMaker Go

 

7 Using FileMaker Go

About the Examples in This Chapter

    Inventory

    Reservations

Hosting Reservations on a Mobile Device

Starting Out by Sharing Inventory

    Creating the Database

    Sharing the Database with FileMaker Pro

    Sharing the Database with FileMaker Server

How to Install a Database on FileMaker Server

Opening and Closing Files

    Opening Files on iPhone

    Opening Files on iPad

Reviewing FileMaker Go Settings

Using FileMaker Go Help

Working with a FileMaker Go Database

    Working with Views

    Working with Additional Commands

Working with Records

    Navigating Through the Database

    Managing and Editing Records

Adding a Photo to a Database

Searching for Data

    Using Quick Find

    Using Find Mode

Sorting Data

Further Steps

 

8 Optimizing FileMaker Databases for FileMaker Go

Understanding the Relationship Between FileMaker Pro and FileMaker Go

    Dealing with Old-Version Issues

    Starting from Scratch for FileMaker Go

Refining Your Database Field Types

Reviewing Calculations

    Get ( SystemPlatform )

    Get ( ApplicationVersion )

Working with Preview Mode

Using Dynamic Subsummary Reporting on FileMaker Go

How to Convert a Preview Mode Layout to a Dynamic

Reporting Layout

Working with Custom Menus

    Reviewing the Existing Menu Commands

    Customizing Menus

How to Customize a Menu Command for FileMaker Go

Managing Script Issues

    Get ( LastError )

    Allow User Abort On/Off

    Set Error Capture On/Off

Further Steps

 

9 Designing a FileMaker Go Solution

Introducing the Handheld Estimator and the Catalog

    Introducing the Estimator

    Introducing the Catalog

Building a Handheld Estimator for iPhone

    Creating the Database

How to Set Up the Database

    Building the Front Layout

How to Create a Basic iPhone Layout

    Building the Back Layout

    Implementing the Info Button

    Setting Up Security and Default Behavior

How to Implement Customized Security

    Testing and Revising the Project

Building a Catalog for iPad

    Working with an Existing Database

    Building the Layout Header Part

How to Create a Common Header Part

    Building the List Layout

    Building the Form Layout

    Testing and Revising

Further Steps

 

10 Using Printing and Charting with FileMaker Go

Adding More Features to Reservations

How to Add a Joins Table to Reservations

How to Build an Event (or Attendee) List

Implementing Printing Features

How to Hide Interactive Elements

How to Set Moving and Sliding

Adding Charting to Your Database

Further Steps

 

Part III: FileMaker by Bento

 

11 Using Bento and Bento Libraries

Working with a Personal Database

Talking Bento

    Database

    Libraries

    Records

    Fields

    Collections

    Smart Collections

Working with the Bento Window on Mac

Working with Bento on iPhone

Working with Bento on iPad

Working with Libraries

    Working with Libraries on Mac OS X

    Working with Libraries on iPhone

    Working with Libraries on iPad

Further Steps

 

12 Using Bento Records, Fields, Forms, and Tables

Taking Advantage of Bento’s Built-In Tools for Mobility

Looking at Fields

    Using Bento Field Types

    Editing Fields on Mac OS X

    Editing Fields on iPad

    Editing Fields on iPhone

How to Add a New Field with Bento for iPhone

Introducing the View Types on Mac OS X

    Using Table Views

    Using Grid Views

    Using Form Views

    Using Split Views

Working with Views on Bento for iPhone

Working with Views on Bento for iPad

Working with Related Data

Further Steps

 

13 Working with Location and Media Fields

Introducing Location Fields

    Reviewing Geolocation Basics

    Finding Your Location: The Operating System Side

    Creating Location Fields

    Using Location Fields

    Working with Location Fields in Forms,Tables, and Grid Views on Mac OS X

    Working with Location Fields with Bento for iPad or iPhone

Looking at Media Fields

Further Steps

 

14 Importing and Exporting Bento and FileMaker Data

Sharing Data with FileMaker and Bento

Importing and Exporting Records in Bento and FileMaker

How To Import Data into Bento

    Exporting Data from Bento for Mac

How to Export Data from Bento

    Importing Data into FileMaker Pro

How To Import Data into FileMaker Pro

How to Export Data from FileMaker Pro

Importing and Exporting Data with Bento Templates with Bento for Mac

Further Steps

 

Part IV: FileMaker Web Publishing: Instant Web Publishing (IWP) and Custom Web

Publishing (CWP)

 

15 Deploying FileMaker/IWP with FileMaker Server Advanced

An Overview of Instant Web Publishing

The IWP Story So Far

    Getting Started with IWP

Enabling and Configuring IWP

    Configuring FileMaker Pro for IWP

    Configuring FileMaker Server Advanced for IWP

    Sharing and Securing Files via IWP

Designing for IWP Deployment on iPad

    Constraints of IWP

    Scripting for IWP

    Layout Design

    Container Fields

    Application Flow

Using an IWP Solution

    Browse Mode

    Edit Mode

    Find Mode

Further Steps

 

16 Deploying FileMaker/CWP with FileMaker Server

Preparing for Custom Web Publishing (CWP) with PHP

    Getting Your Databases Ready for Custom Web Publishing with PHP

    Getting FileMaker Server Ready for Custom Web Publishing with PHP

    Placing Files on the Web Server

Using the PHP Site Assistant

    Building the Site with the PHP Site Assistant

Further Steps

 

A Using a Wireless Keyboard

Pairing and Connecting Bluetooth Devices

FileMaker Go External Keyboard Conventions

Pairing a Bluetooth Keyboard with an iOS Device

Unpairing a Bluetooth Keyboard from a Computer

 

Index