Home > Store

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

Register your product to gain access to bonus material or receive a coupon.

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


  • Sorry, this book is no longer in print.
Not for Sale


  • Copyright 2011
  • Dimensions: 7" x 9-1/8"
  • Pages: 400
  • Edition: 1st
  • Book
  • ISBN-10: 0-7897-4786-3
  • ISBN-13: 978-0-7897-4786-0

Use FileMaker® technologies to create powerful mobile data apps for iPhone®, iPod® touch, and iPad™

Apple’s FileMaker technologies make it easy to create powerful, data-driven apps for iPhone, iPod touch, iPad, and any mobile device’s web browser. In this book, leading FileMaker and iOS expert Jesse Feiler teaches you all the skills and techniques you’ll need, whether you’re a developer, knowledge worker, or manager.

Feiler thoroughly reviews each strategy for delivering mobile data using FileMaker Pro, FileMaker Server, FileMaker Go, and Bento. You’ll learn how mobile data-driven apps are different from traditional desktop-driven apps, and how to create highly usable interfaces for them. Step by step, Feiler demonstrates how to extend existing databases to mobile devices and the web, and how to create and optimize brand-new databases for iPad and iPhone.

This book brings together core principles, practical development techniques, and proven tips and shortcuts. You’ll discover the best ways to incorporate printing, touch interface elements, and location-based features into your apps; integrate data from multiple FileMaker and non-FileMaker sources; and much more.

   •        Use FileMaker Go apps to access FileMaker databases hosted on FileMaker Server or FileMaker Pro, or databases resident on a mobile device

   •        Move FileMaker Pro databases, scripts, and layouts to mobile environments

   •        Develop easy-to-use interfaces for mobile data apps

   •        Design FileMaker Go solutions for iPhone, iPad, or both

   •        Optimize FileMaker databases for FileMaker Go

   •        Integrate printing and charting features into your mobile database apps

   •        Use Bento to share data and synchronize libraries

   •        Work effectively with Bento records, fields, forms, and tables

   •        Build location-aware database apps for iOS mobile devices

   •        Import/export data from Bento, FileMaker, spreadsheets, and other sources

   •        Move FileMaker databases to the web with IWP, CWP, and FileMaker Server

Jesse Feiler is a developer, web designer, trainer, and author. He has worked with Apple mobile devices from Newton through iPad and has worked with FileMaker technologies since 1984. Feiler created ChamplainArts.com’s powerful iPad meeting management app MinutesMachine. His books include Using FileMaker Bento, Sams Teach Yourself Drupal in 24 Hours, The Bento Book, and FileMaker Pro 10 in Depth.


Sample Content

Online Sample Chapter

Working with Mobile Devices When Designing Data-Driven Applications

Sample Pages

Download the sample pages (includes Chapter 4 and Index)

Table of Contents



Part I: Data to Go


1 Making Data Mobile

Introducing the FileMaker Products for Mobile Computing


    FileMaker Go


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


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




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


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



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



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






    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



Submit Errata

More Information

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information

To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.


Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.


If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information

Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.


This site is not directed to children under the age of 13.


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information

If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information

Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents

California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure

Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact

Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice

We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020