For Windows, Mac, Palm OS, and Pocket PC

FileMaker Mobile 7

Companion for Palm OS and Pocket PC

Users Guide

2000-2004 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries, and ScriptMaker and the file folder logo are trademarks of FileMaker, Inc. FileMaker documentation is copyrighted. You are not authorized to make additional copies or distribute this documentation without written permission from FileMaker. You may use this documentation solely with a valid licensed copy of FileMaker software. All persons and companies listed in the examples are purely fictitious and any resemblance to existing persons and companies is purely coincidental. Credits are listed in the Acknowledgements document provided with this software. For more information, visit our web site at www.filemaker.com <http://www.filemaker.com>. Edition: 01
This page intentionally left blank.

Contents

Chapter 1 Installing FileMaker Mobile Registration and customer support New features Installing FileMaker Mobile System Requirements (Windows) System Requirements (Mac OS) System Requirements (Palm OS) System Requirements (Pocket PC) Installing the FileMaker Mobile application and synchronization module Installing the FileMaker Mobile application on a Palm handheld Installing the FileMaker Mobile application on a Pocket PC handheld Removing FileMaker Mobile Removing the FileMaker Mobile from your Palm handheld Removing FileMaker Mobile components from your Pocket PC handheld Removing FileMaker Mobile from your desktop computer Chapter 2 Setting up FileMaker Mobile Setting up FileMaker Pro databases to work with FileMaker Mobile Chapter 3 Using FileMaker Mobile for Palm OS Loading a FileMaker Pro database onto your handheld Opening a database on the handheld Viewing records Adding records Finding records Sorting records Deleting a record Deleting all records in a found set Deleting a database from your handheld Setting database options Synchronizing information between your handheld and computer Chapter 4 Using FileMaker Mobile for Pocket PC Loading a FileMaker Pro database onto your handheld Opening a database on the handheld Viewing records Adding records
1-1 1-1 1-2 1-2 1-2 1-3 1-3 1-3 1-4 1-5 1-5 1-5 1-6 1-6
3-1 3-1 3-2 3-3 3-3 3-3 3-4 3-4 3-4 3-5 3-5

4-1 4-1 4-2 4-3

FileMaker Mobile Users Guide
Finding records Sorting records Deleting a record Deleting all records in a found set Deleting a database from your handheld Setting database options Synchronizing information between your handheld and computer
4-3 4-3 4-4 4-4 4-4 4-4 4-5
Chapter 5 Tips for using FileMaker Mobile Product information Field contents Field definitions FileMaker Mobile limits Using a different handheld Adding a new handheld device Resetting the handheld identification
5-1 5-1 5-2 5-2 5-3 5-3 5-3
Chapter 1 Installing FileMaker Mobile
With FileMaker Mobile and a Palm OS or Pocket PC handheld you can:
select information from FileMaker Pro databases to load onto your handheld view, add, modify, and delete records in your databases when you are away from the office synchronize changes made to both your desktop databases and handheld databases
If youre new to the Palm OS or Pocket PC, you need to know how to use the HotSync or ActiveSync software to synchronize information on your handheld with information on your computer. If you have not performed a sync operation with your handheld before, see the documentation that came with it.
Registration and customer support
Please take the time to complete the registration for your product, or register online at www.filemaker.com/register/. For information about technical support and customer service, see: www.filemaker.com (North American customers) www.filemaker.com/intl/ (customers outside of North America) On the web site, you will find the FileMaker, Inc. Service Directory, which details the service options available to North American customers, as well as links to FileMaker, Inc. international sites, answers to frequently asked questions, and access to extensive software libraries used by technical support staff. If you do not have access to the Web, please refer to the FileMaker support/service sheet included in the software box. North American customers can also call 1-800-965-9090 to learn about the service options available.

New features

FileMaker Mobile 7 presents new features, such as:
compatibility with FileMaker Pro 7 execute FileMaker Pro 7 scripts before and after synchronization support for multiple handhelds support for hi-resolution screens on Palm OS handhelds support for fractional seconds in time fields
support for people with special needs
1 FileMaker Mobile 7 documentation is provided in tagged Adobe Portable Document Format (PDF). Tagged PDF files work with assistive technology, such as the JAWS for Windows screen reader. For more information about tagged PDF files, see www.adobe.com.
For late-breaking information about FileMaker Mobile, browse the contents of the CD and view the Readme file, or visit www.filemaker.com (North American customers) or www.filemaker.com/intl/ (customers outside of North America).
Installing FileMaker Mobile
You install the FileMaker Mobile application and synchronization module on your computer and then install the FileMaker Mobile application on your handheld. FileMaker Mobile is designed to work with English, French, German, Italian, Japanese, and Spanish operating systems as follows:
This component FileMaker Mobile application FileMaker Mobile Synchronization Module FileMaker Mobile handheld application Displays the language used in Desktop operating system Desktop operating system Palm OS or Pocket PC
System Requirements (Windows)*
Hardware requirements: 1 Intel compatible computer Pentium 300MHz or greater
64MB of RAM Windows 2000, 128MB Windows XP CD-ROM drive Hard disk drive One available serial or USB port
Software requirements: 1 Windows 2000 (Service Pack 4), Windows XP (Service Pack 1)
Palm Desktop 4.1 software with HotSync Manager installed for Palm OS handhelds ActiveSync 3.7.1 installed for Pocket PC handhelds FileMaker Pro 7 or FileMaker Developer 7 software
System Requirements (Mac OS)*
Hardware requirements: 1 Apple G3 computer (excluding G3 upgrade cards)

128MB of RAM

CD-ROM drive Hard disk drive One available serial or USB port
Software requirements: 1 Mac OS X version 10.2.8 and 10.3.1
Palm Desktop 4.1 software with HotSync Manager installed FileMaker Pro 7 or FileMaker Developer 7 software
System Requirements (Palm OS)*
Hardware and software requirements: 1 Palm OS compatible handheld
2MB of storage Palm OS 3.5 - 5.2 HotSync cradle or cable
System Requirements (Pocket PC)*
Hardware and software requirements: 1 Pocket PC 2002 or 2003 ARM compatible handheld
16MB of RAM ActiveSync cradle
Version stated is the minimal requirement. The software will also work with later versions certified by FileMaker.
Installing the FileMaker Mobile application and synchronization module

To install the FileMaker Mobile application and synchronization module:
1. Exit other open programs and turn off virus protection utilities. 2. If you are installing from a CD, insert it into your CD or DVD drive. 3. Do one of the following:
For this system Windows Mac OS Do this Click Install FileMaker Mobile. Double-click FileMaker Mobile X.
4. Follow the instructions that appear on your screen.
1 When the license agreement displays, review the terms. If you accept the terms, click Accept, then click Next. 1 When prompted for an installation code, type the code that comes with the product, then click Next.
5. When the installation is complete, click Finish or Quit.
Installing the FileMaker Mobile application on a Palm handheld
To install the FileMaker Mobile application on your Palm handheld:
1. In Windows or the Mac OS, launch the Palm Desktop application. 2. Click the Install tool (Windows) or choose Hot Sync menu > Install Handheld Files (Mac OS). 3. Click Add (Windows) or Add To List (Mac OS). 4. Navigate to the folder where the FileMaker Mobile application for the handheld was installed. 5. Select FileMaker Mobile 7.prc, then click Open. 6. If you are using the French, German, Italian, Japanese or Spanish version of the Palm OS, click
Add (Windows) or Add To List (Mac OS). Select the corresponding language file, then click Open.
For French German Italian Japanese Spanish Select FileMaker 7 Lang French.prc FileMaker 7 Lang German.prc FileMaker 7 Lang Italian.prc FileMaker 7 Lang Japanese.prc FileMaker 7 Lang Spanish.prc
7. Click Done, then click OK. 8. Perform a HotSync operation to install the application on your handheld. 9. Start the handheld FileMaker Mobile 7 application and enter the handheld license key. 10. Perform a HotSync operation to transfer the user code and the license key to the desktop.
You can check the user identification by starting the desktop FileMaker Mobile 7 application and click User. Chapter 2 tells you how to transfer your databases to your handheld.
Installing the FileMaker Mobile application on a Pocket PC handheld
To install the FileMaker Mobile application on your Pocket PC handheld:
1. Insert your Pocket PC handheld in the cradle. 2. In Windows launch ActiveSync. 3. Choose Tools menu > Add/Remove Programs. 4. Click the FileMaker Mobile 7 application.

5. Click OK. 6. When prompted on the handheld, remove and replace your handheld in the cradle. This enables
ActiveSync to identify the files to download.
7. Click OK in Windows to close the dialog box. 8. In ActiveSync, choose Tools menu > Options. 9. Check the FileMaker Mobile 7 application, then click OK to enable ActiveSync to transfer files

to the handheld.

10. Start the handheld FileMaker Mobile 7 application and enter the handheld license key. 11. Perform an ActiveSync operation to transfer the user code and the license key to the desktop.
You can check the user identification by starting the desktop FileMaker Mobile 7 application and click User. Chapter 4 tells you how to transfer your databases to your handheld.
Removing FileMaker Mobile
Removing the FileMaker Mobile from your Palm handheld
Important This procedure deletes FileMaker Mobile 7 databases from your handheld. Before continuing, be sure to perform a HotSync operation to back up your FileMaker Mobile databases.
1. In the handhelds Applications Launcher, choose App menu > Delete. 2. Tap FileMaker 7, then tap Delete. 3. Tap Yes, then tap Done.
Removing FileMaker Mobile components from your Pocket PC handheld
Important Be sure to perform an ActiveSync operation to back up your FileMaker Mobile 7 databases prior to removing the FileMaker Mobile software.
Removing FileMaker Mobile directly from the Pocket PC To remove the FileMaker Mobile 7 application from your Pocket PC handheld directly from the handheld:
1. On the handheld, choose Start menu > Settings. 2. Click the Systems tab. 3. Click the Remove Programs. 4. Click the FileMaker Mobile 7 application and click Remove. 5. When prompted, restart your handheld, then repeat steps 1 through 4 to remove additional files
that could not be deleted when the FileMaker Mobile 7 system files were still in memory.
Removing FileMaker Mobile from the Pocket PC using ActiveSync on your Windows desktop To remove the FileMaker Mobile 7 application from your Pocket PC handheld using ActiveSync on your Windows desktop:
1. On the Windows desktop, launch ActiveSync. 2. Choose Tools menu > Add/Remove Programs. 3. Uncheck the FileMaker Mobile 7 application and click OK. 4. When prompted on the handheld, restart your handheld, then repeat steps 1 through 3 to remove additional files that could not be deleted when the FileMaker Mobile 7 system files were still in memory.

Note This procedure removes the FileMaker Mobile 7 application from your Pocket PC handheld, but not from the desktop PC. You can reinstall the FileMaker Mobile 7 application to your handheld from your PC at a later date.
Removing FileMaker Mobile from your desktop computer
Removing FileMaker Mobile from your computer (Windows) 1. Close the FileMaker Mobile application if it is open.
2. Click the Start button > Settings > Control Panel. 3. Double-click Add/Remove Programs. 4. Select FileMaker Mobile 7 from the list of applications. 5. Click Remove or Add/Remove. 6. Click Yes to confirm that you want to remove FileMaker Mobile 7. 7. Click Close or OK.
Removing FileMaker Mobile from your computer (Mac OS) 1. Close the FileMaker Mobile application if it is open.
2. Double-click FileMaker Mobile installer. 3. Select Uninstall. 4. Click Uninstall. 5. Click OK.
Chapter 2 Setting up FileMaker Mobile
This chapter tells you how to set up FileMaker Pro databases to work with FileMaker Mobile and how to check which databases are ready to be loaded onto the handheld. Note FileMaker Mobile 7 must be used with FileMaker Pro 7 or FileMaker Developer 7 software. It is not compatible with earlier versions of FileMaker Pro or FileMaker Developer.
Setting up FileMaker Pro databases to work with FileMaker Mobile
Note To set up databases, your access privileges must include Design Layouts. To set up a FileMaker Pro database to work with FileMaker Mobile:
1. Start the FileMaker Mobile 7 application. 2. Click Add. 3. Click Browse and choose the database to download. 4. Click Next. 5. Click Settings to open the Mobile Settings dialog box.
You can choose who has access to the file
Select the fields to transfer
Specify actions performed before or after synchronization
6. In Sharing, specify the handheld access to the file. Click Specify to grant database access by the users privilege set. 7. Click Specify Fields.
8. In the Available Fields list, select the field you want to transfer to the handheld and click Add.
Repeat this step for each field you want to transfer. You can transfer up to 50 fields and their data. Only Text, Number, Date, and Time field types can be transferred and only these will appear in the Available Fields list.
Select the fields to transfer to the handheld Click to specify how fields display on the handheld
To change the order that fields will appear on the handheld, select a field in the Handheld Fields list and click Move Up or Move Down. Arrange the fields now in the order you want them to appear on your handheld.

9. (Optional) To specify how fields display on the handheld, click Properties.
Click to show or hide properties
The available options depend on the field type and selected properties
Setting up FileMaker Mobile
To Select a data entry format
Click a field in the Handheld Fields list, then Choose one of the following from the Format list. See the examples following this table.
1 For text or number fields, choose Standard, Popup Menu, Popup List, Single 1 For date fields, choose Date Picker, Popup Menu, or Popup List. 1 For time fields, choose Time Picker, Popup Menu, or Popup List.
Use a list of values for data entry For Use value list, choose a value list defined in the database. Value lists from related databases arent supported. For a Single Checkbox, only the first value in the value list displays on the handheld. Tip Choose a value list that contains a single value. Allow changes to field data Capitalize the first letter when entering data in an empty field Select Allow entry into field. Select Use auto capitalization. Checkbox, or Notes.
Display a custom label instead of the Select Use custom label. Type the label text. field name
Use popup menus to choose values defined in the associated value list Use popup lists to choose values defined in the associated value list or enter new information in fields Standard field Single Checkbox Click the Notes icon to view or change text in a Notes fields
10. When youre done specifying fields, click OK. 11. Click Synchronization.
12. In Mode, select the record transfer direction. Choose one of the three transfer options:
Choose this option Bi-directional Upload to desktop only To do this Transfer modified records to and from the handheld. Transfer modified records from the handheld database to the desktop database. All records are deleted on the handheld database. Transfer desktop database to the handheld database. All records on the handheld database that are not in the desktop database are deleted.
Download to handheld only
13. In Records, select the set of records you want to transfer to the handheld.
Select the record transfer direction
Select the set of records to transfer to the handheld
Select how to resolve record differences at synchronization Select actions before and after synchronization
If you want to load only a subset of records onto your handheld, select Found set at time of synchronization. In FileMaker Pro 7, create a FileMaker Pro 7 script which selects an appropriate found set. Then choose that script as a before synchronization action described in step 15.
14. In Conflict Resolution, choose how you want to resolve record differences at synchronization.
When you modify the same records in both the handheld database and the desktop database, FileMaker Mobile uses one of the following options to resolve differences at synchronization.
Choose this option Duplicate record To do this Create and place handheld records in the desktop database. See the FileMaker Pro Users Guide for information about finding duplicate records. The handheld record replaces the desktop record. The desktop record replaces the handheld record.

Handheld overwrites desktop Desktop overwrites handheld
15. Click Specify Actions, to choose what actions are performed on the database before and after

synchronization.

Select log in account name and password
Select FileMaker Pro 7 Script to run before synchronization Select FileMaker Pro 7 Script to run after synchronization
Before synchronization, you can choose the log in account to access database records. You can optionally choose to run a FileMaker Pro 7 script before and after synchronization. Check the Perform Script checkbox and select the script from the menu.
16. Click OK, then OK again.
Repeat the steps in this section for each database you want to share with the handheld.
Chapter 3 Using FileMaker Mobile for Palm OS
This chapter explains how to work with data in databases on your Palm OS handheld.
Loading a FileMaker Pro database onto your handheld
Perform a HotSync operation to load one or more databases onto your handheld: Be sure all the databases are shared with FileMaker Mobile. See Setting up FileMaker Pro databases to work with FileMaker Mobile on page 2-1. Warning Do not interact with FileMaker Pro during the HotSync operation.
Opening a database on the handheld
To open a database on the handheld:
1. In the handhelds Applications Launcher, tap the FileMaker 7 icon.
If you do not see the FileMaker 7 icon, change the applications category to All.
2. Tap a database in the list.

Database list

Viewing records
You can look at records one by one or in a list.
Tap anywhere in a line to switch to form view

List View

Form View
To View the list of databases View records in a list View one record at a time In list view, scroll column to column In list view, scroll list up and down In form view, scroll record to record In form view, scroll field to field
You can navigate by pressing the scroll buttons on the front panel of your handheld. You can also use the Jog Dial navigator on Sony handhelds to scroll through databases and records. To go directly to a record, choose Record menu > Go to Record, then enter the record number and tap OK. You can change the way fields display.
To Resize a field Change the field order Allow or prevent resizing or reordering columns, or sorting by column label Change the text width, alignment, or color in a field In this view List List List Do this with the stylus Tap and hold the line between the field labels. Tap and hold a field label, then drag it to a new location. Choose Options menu > List View Options, then select the desired options. Tap OK. Tap the field, choose Options menu > Field Options, then select the desired options. Tap OK. Color options are only available on handhelds that support text colors.

Tip A.pdb file is a Palm database file. Select this option if you perform a HotSync
operation on a computer that doesnt have the FileMaker Mobile conduit installed. You can also select this option if you use a backup utility to back up to an external card. Enable synchronization of the active database. Change the account name and password of the active database. Synchronize database Login > Specify

3. Tap OK.

Synchronizing information between your handheld and computer
Perform a HotSync operation to synchronize information between your handheld and computer: Be sure all the databases are shared with FileMaker Mobile (see Setting up FileMaker Pro databases to work with FileMaker Mobile on page 2-1). Warning Do not interact with FileMaker Pro during the HotSync operation.
Chapter 4 Using FileMaker Mobile for Pocket PC
This chapter explains how to work with data in databases on your Pocket PC handheld.
Perform an ActiveSync operation to load one or more databases onto your handheld: Be sure all the databases are shared with FileMaker Mobile (see Setting up FileMaker Pro databases to work with FileMaker Mobile on page 2-1). Warning Do not interact with FileMaker Pro during the ActiveSync operation. Note All databases downloaded to your Pocket PC are downloaded to the \My Documents\FileMaker directory.
1. In the handhelds Programs folder, tap the FileMaker Mobile 7 icon. 2. Tap a database in the list.
List view To View the list of databases View records in a list View one record at a time View first record View previous record View next record View last record Create new record Sort records Find records Show/hide toolbar Tap

Form view

To go directly to a record, choose Records menu > Go to Record, then enter the record number and tap OK. You can change the way fields display.
To Resize a field Change the field order Enable or prevent resizing or reordering columns, or sorting by column label In this view List List List Do this with the stylus Tap and hold the line between the field labels. Tap and hold a field label, then drag it to a new location. Choose Tools menu > Options menu > List View Options, then select the desired options. Tap OK.
Using FileMaker Mobile for Pocket PC
To Change the column width, alignment, or color in a field Use large fonts Allow/prevent changes to records Allow/prevent changes to records Change the alignment of field labels Use large fonts
In this view List List List Form Form Form
Do this with the stylus Tap the field, choose Tools menu > Options menu > Field, then select the options. Tap OK. Tap the field, choose Tools menu > Options menu > List View, then select the option. Tap OK. Choose Tools menu > Options menu > List View Options, then select/clear Edit in list view. Tap OK. Choose Options menu > Form View Options, then select/clear Edit in form view. Tap OK. Choose Tools menu > Options menu > Form View Options, then choose from the Field Labels pick list. Tap OK. Choose Tools menu > Options menu > Form View Options, then select Use large fonts. Tap OK.

To add a new record, choose Records menu > New Record. Tap a field to select it and start entering information. Use the stylus to write characters in the writing area or use the onscreen keyboard. The new record is added after the last record. To copy an existing record, choose Records menu > Duplicate Record. Tap a field to select it and change the existing information. Use the stylus to write characters in the writing area or use the onscreen keyboard. The new record is added after the last record.
1. Choose Records menu > Find Records. 2. For Field, select the field you want to search in. 3. Enter the word or first few characters of the item you want to find and tap Find.
1. Choose Record menu > Sort Records. 2. For Field, select the field you want to sort by. 3. Select Ascending or Descending and tap Sort.
You can also sort records in list view by tapping a column heading. An arrow next to a column heading indicates that the records are currently sorted by that field. To enable or disable this feature, see Viewing records on page 4-2.
1. Select the record. 2. Choose Records menu > Delete Record.
To also delete the corresponding record in the desktop database the next time you do an ActiveSync, select Delete original(s) on Desktop.
3. Tap Delete to confirm the action.
1. Choose Records menu > Delete All Records.
To also delete all of the corresponding records in the desktop database the next time you do a ActiveSync, select Delete original(s) on Desktop.
2. Tap Delete to confirm the action.
2. Tap-and-hold on the database to delete. 3. Tap Delete. 4. Tap Yes to confirm.
To change database options:
1. Choose Tools menu > Options menu > Synchronization. 2. Set the following options.
To Enable synchronization of the active database. Change the login account and password of the active database. Select Check Synchronize database Edit the Account Name and Password
Perform an ActiveSync operation to synchronize information between your handheld and computer: Be sure all the databases are shared with FileMaker Mobile. See Setting up FileMaker Pro databases to work with FileMaker Mobile on page 2-1. Warning Do not interact with FileMaker Pro during the ActiveSync operation. Note Only databases stored in the \My Documents\FileMaker directory on your Pocket PC handheld will be synchronized.
Chapter 5 Tips for using FileMaker Mobile

Product information

For up-to-date product information, see:
www.filemaker.com (North American customers) www.filemaker.com/intl/ (customers outside of North America)

Field contents

If a database on your handheld doesnt appear to contain any fields, be sure you specify fields on your desktop before loading the database to your handheld. See Setting up FileMaker Pro databases to work with FileMaker Mobile on page 2-1. A fields display is limited to the size of a Palm OS handhelds screen. To view a fields entire contents, tap the last line in the field and drag the stylus downwards. The text that was hidden (up to the limit of approximately 2000 characters) scrolls into view. You can also resize a field in list view. (See Viewing records on page 3-2.) If you cant enter or change data on your handheld, the field or records may be set to display as read-only:
1 Be sure Allow entry into field is selected in the Specify Fields dialog box before you load the database to your handheld. See Setting up FileMaker Pro databases to work with FileMaker Mobile on page 2-1. 1
Be sure Edit in list view and Edit in form view are selected on your handheld. See Viewing records on page 3-2.

Field definitions

If you change a Text field to a Number, Date, or Time field on your desktop, any data after the first 255 characters will be deleted. If you then also make changes to the data in the corresponding field on the handheld, FileMaker Mobile writes the modified records to a comma-separated values file, which is stored in the FileMaker Mobile folder inside the handheld user directory. For example:
Platform Windows File C:<Application Data Folder>FileMaker\ FileMaker Mobile\7.0\ Palm\Users\<PalmUserName>\Asset Management.csv C:<Application Data Folder>FileMaker\FileMaker Mobile\7.0\CE\Users <device_name>\Asset Management.csv <User Home Folder>/Library/Preferences Folder/FileMaker/FileMaker Mobile/ 7.0/Users/<PalmUserName>/Asset Management.csv

Mac OS

Note Please see the documentation that comes with Palm OS for the location of Palm directories and folders. Next, use the Import Records command in FileMaker Pro to import the data into your desktop database. After you have imported the records, delete the comma-separated values file. See the FileMaker Pro Users Guide for more information.

FileMaker Mobile limits

Item Field size Maximum size Up to 2KB of information (approximately 2000 characters). Number, date, and time fields can contain up to 255 characters. If a record contains one or more fields with more than 2KB of information, the record is not loaded onto the handheld. Number of fields per handheld database Number of records per handheld database Number of FileMaker Pro databases per handheld 50
Note Size limits depend on the number of fields and amount of memory available on the handheld.
Tips for using FileMaker Mobile
Using a different handheld
You can install FileMaker Mobile 7 on one or more handheld devices. Each handheld using FileMaker Mobile 7 is identified by the user identification that includes a user code and an unique license key on the handheld. If you add a new handheld device, you create a new user identification for that device. If you replace a handheld device, you can reset the user identification for the old handheld and transfer the license key to the new handheld device.
Adding a new handheld device
To add a new handheld user identification to FileMaker Mobile 7:
1. Install the FileMaker Mobile 7 application on the new handheld.
See Installing FileMaker Mobile on page 1-1 for more information.
2. Start the handheld FileMaker Mobile 7 application and enter the handheld license key. 3. Perform a HotSync or ActiveSync operation to transfer the user code and the license key.
You can check the user identification by starting the desktop FileMaker Mobile 7 application and click User.
4. In the desktop FileMaker Mobile 7 application, select the databases for transfer to the handheld.
See Setting up FileMaker Mobile on page 2-1 for more information.
5. Perform a HotSync or ActiveSync operation to transfer the databases to the new handheld.
Resetting the handheld identification
To reset FileMaker Mobile 7 to remove a handheld device or transfer the license key to a different handheld:
1. Backup your databases by performing a HotSync or ActiveSync operation with your old

handheld.

2. Start the desktop FileMaker Mobile 7 application and click User. 3. In the User Identification dialog box, select the handheld user code to reset.
Note the license key for the selected handheld if it will be transferred to a new handheld.
4. Click Reset User and confirm the reset. 5. Click Done.

Symbols

.pdb files, creating with backup 3-5, 4-4.prc files 1-4, 1-5 inserting phone numbers 3-3, 4-3 labels 2-3, 3-2, 4-2 maximum number 5-2 maximum size 5-2 missing from handheld 5-1 preventing changes 2-3, 5-1 properties 2-3 resizing 3-2, 4-2 specifying for transfer to handheld 2-2 Files comma-separated values 5-2 loading onto Palm handheld 3-1 loading onto Pocket PC handheld 4-1 opening on Palm handheld 3-1 opening on Pocket PC handheld 4-1 setting up to work with FileMaker Mobile 2-1 Finding records Global Find option 3-5, 4-4 on handheld 3-5, 4-3, 4-4 on Palm handheld 3-3 prior to ActiveSync operation 4-1 prior to HotSync operation 2-4, 3-1 Form view described 3-2, 4-2 options 3-2, 4-2

Jog Dial navigator 3-2

Labels, fields 2-3, 3-2, 4-2 Language support 1-2, 1-4, 1-5 Limits field size 5-2 number of databases 5-2 number of fields 5-2 number of records 5-2 List view described 3-2, 4-2 options 3-2, 4-2
ActiveSync 4-5 Adding records 3-3, 4-3 Application enabling 2-1 installing 1-3
Backup option, creating.pdb file 35, 4-4
Mobile application enabling 2-1 Mobile application and synchronization installing 1-3
Capitalizing data 2-3 Checkboxes 2-3 Comma-separated values file 5-2 Customer support 1-1

Notes fields 2-3

Data entry options 2-3 Databases maximum number 5-2 Date fields 2-3 Deleting all records in found set 3-4, 4-4 database from handheld 3-4, 4-4 records 3-4, 4-4
Opening files on Palm handheld 3-1 on Pocket PC handheld 4-1
Global Find option 3-5, 4-4
Phone lookup 3-3, 4-3 Popup lists 2-3 Popup menus 2-3 Product registration 1-1 Properties for fields 2-3
Field definitions, changing 5-2 Field types, changing 5-2 Fields changing definitions 5-2 types 5-2 changing order 3-2, 4-2 data entry options 2-3, 3-2, 4-2 display options 2-3, 3-2, 4-2 hidden contents 5-1 HotSync options for synchronizing 2-4, 35, 4-4 synchronizing data 3-5
Installing FileMaker Mobile application 1-3 application on handheld 1-4, 1-5
Record view. See Form view Records adding 3-3, 4-3 deleting 3-4, 4-4 deleting all in found set 3-4, 4-4
finding on handheld 3-5, 4-3, 4-4 finding on Palm handheld 3-3 maximum number 5-2 preventing changes 3-2, 4-2, 5-1 resolving differences at synchronization 2-5 sorting 3-3, 4-3 viewing 3-2, 4-2 Registering FileMaker Mobile 1-1 Removing FileMaker Mobile 1-5 Resetting FileMaker Mobile 5-3
Web site for registering software 1-1 technical support 1-1
Single checkbox 2-3 Sony Jog Dial navigator 3-2 Sorting records 3-3, 4-3 Standard field format 2-3 Support customer 1-1 technical 1-1 Synchronization, installing 1-3 Synchronizing data 3-5, 4-5 resolving record differences 2-5 System requirements Mac OS 1-2 Palm OS 1-3 Pocket PC 1-3 Windows 1-2
Technical specifications 5-2 Technical support 1-1 Text formats 2-3, 3-2, 4-2 Time fields 2-3 Troubleshooting 5-1
Using multiple handhelds 5-3
Value lists 2-3 Viewing records 3-2, 4-2

For Windows, Mac, Palm OS, and Pocket PC

FileMMobile 8 aker

Companion for Palm OS and Pocket PC

Users Guide

2000 - 2006 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries, and ScriptMaker and the file folder logo are trademarks of FileMaker, Inc. FileMaker documentation is copyrighted. You are not authorized to make additional copies or distribute this documentation without written permission from FileMaker. You may use this documentation solely with a valid licensed copy of FileMaker software. All persons and companies listed in the examples are purely fictitious and any resemblance to existing persons and companies is purely coincidental. Credits are listed in the Acknowledgements document provided with this software. For more information, visit our website at www.filemaker.com. Edition: 01
This page intentionally left blank.

Contents

Chapter 1 Overview of FileMaker Mobile Registration and customer support New features Overview of FileMaker Mobile software System requirements Desktop Requirements* Handheld Requirements* Supported languages Chapter 2 Installing FileMaker Mobile Installing the FileMaker Mobile application on your desktop computer Installing the FileMaker Mobile application on a Palm handheld Installing the FileMaker Mobile application on a Pocket PC handheld Chapter 3 Setting up FileMaker Mobile Adding FileMaker Pro databases to share with the handheld Add Starter Solution Add local database Add hosted database Making FileMaker Pro databases available for synchronization Setting up FileMaker Pro databases to work with FileMaker Mobile Configuring mobile settings for hosted databases Chapter 4 Using FileMaker Mobile for Palm OS Loading a FileMaker Pro database onto your handheld Opening a database on the handheld Viewing records Adding records Finding records Sorting records Deleting a record Deleting all records in a found set Deleting a database from your handheld Setting database options Synchronizing information between your handheld and computer
1-1 1-1 1-2 1-3 1-3 1-3 1-4

2-1 2-1 2-3

3-1 3-2 3-2 3-3 3-3 3-4 3-8
4-1 4-1 4-1 4-3 4-3 4-3 4-3 4-4 4-4 4-4 4-5
FileMaker Mobile Users Guide
Chapter 5 Using FileMaker Mobile for Pocket PC Loading a FileMaker Pro database onto your handheld Opening a database on the handheld Viewing records Adding records Finding records Sorting records Deleting a record Deleting all records in a found set Deleting a database from your handheld Setting database options Synchronizing information between your handheld and computer Chapter 6 Administering FileMaker Mobile solutions Product information Field contents Field definitions FileMaker Mobile database limits FileMaker Mobile field types Using a different handheld Adding a new handheld device Resetting the handheld identification Removing FileMaker Mobile Removing FileMaker Mobile from your Palm handheld Removing FileMaker Mobile components from your Pocket PC handheld Removing FileMaker Mobile from your desktop computer FileMaker Pro scripts supported in FileMaker Mobile Index
5-1 5-1 5-2 5-3 5-3 5-4 5-4 5-4 5-4 5-5 5-5
6-1 6-1 6-1 6-2 6-2 6-2 6-2 6-3 6-3 6-3 6-4 6-4 6-5 I-1
Chapter 1 Overview of FileMaker Mobile

With FileMaker Mobile and a Palm OS or Windows Mobile-based Pocket PC handheld you can:
select information from FileMaker Pro databases to load onto your handheld view, add, modify, and delete records in your databases when you are away from the office synchronize changes made to both your desktop databases and handheld databases
If youre new to the Palm OS or Pocket PC, you need to know how to use the HotSync or ActiveSync software to synchronize information on your handheld with information on your computer. If you have not performed a sync operation with your handheld before, see the documentation that came with it.
Registration and customer support
Please take the time to complete the registration for your product, or register online at www.filemaker.com/register/. For information about technical support and customer service, see: www.filemaker.com (North American customers) www.filemaker.com/intl/ (customers outside of North America) On the web site, you will find the FileMaker, Inc. Service Directory, which details the service options available to North American customers, as well as links to FileMaker, Inc. international sites, answers to frequently asked questions, and access to extensive software libraries used by technical support staff. If you do not have access to the Web, please refer to the FileMaker support/service sheet included in the software box. North American customers can also call 1-800-965-9090 to learn about the service options available.

New features

FileMaker Mobile 8 presents new features, such as:
1 Compatibility with FileMaker Pro 8, FileMaker Pro 8 Advanced, FileMaker Server 8, FileMaker

Server 8 Advanced

Synchronize with hosted FileMaker Pro databases 6 pre-designed FileMaker Starter Solutions
Support for people with special needs FileMaker Mobile 8 documentation is provided in tagged Adobe Portable Document Format (PDF). Tagged PDF files work with assistive technology, such as the JAWS for Windows screen reader. For more information about tagged PDF files, see www.adobe.com.
For late-breaking information about FileMaker Mobile, browse the contents of the CD and view the Readme file, or visit www.filemaker.com (North American customers) or www.filemaker.com/intl/ (customers outside of North America).

Overview of FileMaker Mobile software
FileMaker Mobile synchronizes FileMaker Pro databases with many handheld devices. The following table shows the software components that you need to install in order to run FileMaker Mobile, and where the software components are installed.
Palm or Pocket PC Handheld Installed Software

Mac or Windows Computer

1 FileMaker Mobile application
1 FileMaker Mobile desktop 1 FileMaker synchronization module 1 Palm Desktop/HotSync or ActiveSync

software

Data Storage Database Management Software

1 Palm or Windows Mobile

handheld databases
1 FileMaker databases (.fp7) 1 FileMaker Pro or 1 FileMaker Pro Advanced
The software components perform the following functions:
On handheld 1 FileMaker Mobile handheld application is installed on the handheld and provides the user interface for viewing, editing, and managing FileMaker data on your handheld. On desktop computer 1 FileMaker Mobile desktop application is used on your desktop computer for adding and configuring FileMaker database files (.fp7) for use with FileMaker Mobile.
FileMaker synchronization module is installed along with the FileMaker Mobile desktop software, and provides the synchronization capability between local or hosted FileMaker databases and your handheld device. Palm Desktop/HotSync or ActiveSync software is used during installation to upload the FileMaker Mobile application to your handheld device and is used for synchronization. FileMaker Pro or FileMaker Pro Advanced is used to create or modify your FileMaker Pro databases for use with FileMaker Mobile 8.
Overview of FileMaker Mobile
On hosted computer 1 (optional) FileMaker Server or FileMaker Server Advanced can be used to host FileMaker databases for remote access by the FileMaker Mobile application.
Note You need to synchronize your handheld device with a desktop computer in order to establish a connection to the remote host. You cannot synchronize the handheld directly to FileMaker Server.

System requirements

Desktop Requirements*
FileMaker Mobile 8 works with:
1 FileMaker Pro 8; FileMaker Pro 8 Advanced; FileMaker Server 8; FileMaker Server 8 Advanced 1 FileMaker Pro 7; FileMaker Developer 7
Windows 1 Pentium III 500 MHz or higher, 256MB of RAM; CD or DVD drive
Windows 2000 (Service Pack 4), Windows XP (Service Pack 2) Palm Desktop 4.1.4 software with HotSync Manager installed for Palm OS handhelds ActiveSync 3.8 installed for Pocket PC handhelds
Mac OS X 1 Macintosh computer with G3, G4, or G5 processor; 256MB of RAM; CD or DVD drive
Mac OS X 10.3.9, 10.4 Palm Desktop 4.2 software with HotSync Manager installed

Handheld Requirements*

Palm OS (Windows and Mac) 1 Palm OS compatible handheld; 2MB of storage
Palm OS 4.1 - 5.4 HotSync cradle and/or cable
Pocket PC (Windows Only) 1 ARM-based Windows Mobile 2003 (Second Edition included), and 5.0-based Pocket PCcompatible handheld
16MB of RAM ActiveSync cradle
Version stated is the minimal requirement. The software will also work with later versions certified by FileMaker.

Supported languages

FileMaker Mobile is designed to work with the following languages: English, French, German, Italian, Japanese, and Spanish. The FileMaker Mobile software interacts with the operating systems as follows:
This component FileMaker Mobile application FileMaker Mobile Synchronization Module FileMaker Mobile handheld application Displays the language used in Desktop operating system Desktop operating system Palm OS or Pocket PC
Chapter 2 Installing FileMaker Mobile
The following sections explain how to install FileMaker Mobile software on your desktop computer and handheld device. You install the FileMaker Mobile application and synchronization module on your computer and then install the FileMaker Mobile application on your handheld.
Installing the FileMaker Mobile application on your desktop computer
Important If you have FileMaker Mobile 7 installed, perform an ActiveSync or HotSync before proceeding. This will back up your handheld databases. The FileMaker Mobile 8 installation will replace your FileMaker Mobile 7 installation on your desktop PC. To install the FileMaker Mobile application and synchronization module:
1. Exit other open programs and turn off virus protection utilities. 2. If you are installing from a CD, insert it into your CD or DVD drive. 3. Do one of the following:
For this system Windows Mac OS Do this Click Install FileMaker Mobile. Double-click FileMaker Mobile 8.
4. Follow the instructions of the installation wizard. 5. Follow the instructions that appear on your screen.
When the license agreement displays, review the terms. If you accept the terms, click Accept, then click Next.
When prompted for an installation code, type the code that comes with the product, then click Next.
6. When the installation is complete, click Finish or Quit.
Installing the FileMaker Mobile application on a Palm handheld
Important If you have FileMaker Mobile 7 installed on your Palm handheld, you must remove it before installing FileMaker Mobile 8. For more information, see Removing FileMaker Mobile from your Palm handheld on page 6-3.
The following steps install three files:
Filename FileMaker Mobile 8.prc FileMaker Mobile Inf.pdb FileMaker 8 Lang [Language].prc Description FileMaker Mobile application file License key information file FileMaker Mobile application resource file for each of the languages

To install the FileMaker Mobile application on your Palm handheld:
1. In Windows or the Mac OS, launch the Palm Desktop application. 2. Click the Install tool (Windows) or choose Hot Sync menu > Install Handheld Files (Mac OS). 3. Click Add (Windows) or Add To List (Mac OS). 4. Navigate to the folder where the FileMaker Mobile application for the handheld was installed. 5. Select FileMaker Mobile 8.prc, then click Open (Windows) or Add To List (Mac OS). 6. Click Add (Windows) or Add to List (Mac OS). 7. Select the corresponding language file, then click Open (Windows) or Add To List (Mac OS).
For English French German Italian Japanese Spanish Select FileMaker 8 Lang English.prc FileMaker 8 Lang French.prc FileMaker 8 Lang German.prc FileMaker 8 Lang Italian.prc FileMaker 8 Lang Japanese.prc FileMaker 8 Lang Spanish.prc
8. Click Add (Windows) or Add to List (Mac OS) 9. Select FileMaker Mobile Inf.pdb, then click Open (Windows) or Add To List (Mac OS). 10. Perform a HotSync operation to install the application on your handheld.
You can confirm the successful installation of FileMaker Mobile by locating the icon in the list of available applications on your Palm handheld.
11. Perform a HotSync operation to transfer the user code and the license key to the desktop.
You can check the user identification by starting the desktop FileMaker Mobile 8 application and clicking User. Chapter 3 tells you how to transfer your databases to your handheld.
Installing FileMaker Mobile
Installing the FileMaker Mobile application on a Pocket PC handheld
Important If you have FileMaker Mobile 7 installed on your Pocket PC handheld, you must remove it before installing FileMaker Mobile 8. For more information, see Removing FileMaker Mobile components from your Pocket PC handheld on page 6-4. To install the FileMaker Mobile application on your Pocket PC handheld:
1. Insert your Pocket PC handheld in the cradle. 2. In Windows launch ActiveSync. 3. Choose Tools menu > Add/Remove Programs. 4. Click the FileMaker Mobile 8 application. 5. Click OK.
If a warning states that the program is from an unknown publisher, click Yes to continue the installation.
6. When prompted, enter the handheld license key. 7. When prompted on the handheld, remove and replace your handheld in the cradle. This enables

ActiveSync to identify the files to download.
8. Click OK in Windows to close the dialog box. 9. In ActiveSync, choose Tools menu > Options. 10. Check the FileMaker Mobile 8 application, then click OK to enable ActiveSync to transfer files to the handheld. 11. Perform an ActiveSync operation to transfer the user code and the license key to the desktop.
You can confirm the successful installation of FileMaker Mobile by locating the icon in the list of icons on your Pocket PC handheld. You can check the user identification by starting the desktop FileMaker Mobile 8 application and clicking User. Chapter 3 tells you how to transfer your databases to your handheld.
Chapter 3 Setting up FileMaker Mobile
This chapter tells you how to set up FileMaker Pro databases to work with FileMaker Mobile and how to check which databases are ready to be loaded onto the handheld. Note FileMaker Mobile 8 works with FileMaker Pro 7 and FileMaker Pro 8 databases. FileMaker Mobile 8 does not work with earlier versions of FileMaker Pro databases.
Adding FileMaker Pro databases to share with the handheld
To share FileMaker Pro databases with the handheld:
1. Start the FileMaker Mobile 8 application. 2. If no databases are currently shared, the Add Database dialog will appear automatically.
Otherwise, click Add in the main FileMaker Mobile window.
Select to add FileMaker Starter Solutions
Select to add a FileMaker Pro database on a local disk Select to add a hosted FileMaker Pro database
You can add databases using one of three methods:
1 Add Starter Solutions add one or more of the ready-to-use FileMaker Starter Solutions included with FileMaker Mobile 8. 1
Add local database add any local database on your desktop computer. Note For each database selected you will need to specify mobile settings. For more information, see Setting up FileMaker Pro databases to work with FileMaker Mobile on page 3-4.
1 Add hosted database add any remote, hosted database on your network that is already configured with mobile settings. For more information, see Configuring mobile settings for hosted databases on page 3-8. Add Starter Solution
1. In the Add Database dialog box, select Add Starter Solution. 2. Specify one or more of the Starter Solutions that you want to share with the handheld. 3. Click OK.
The Starter Solutions are FileMaker Pro databases that are pre-configured with the mobile settings that you need. These solutions can be used on your handheld device immediately following your first synchronization. If you want to modify any of the default settings, see Setting up FileMaker Pro databases to work with FileMaker Mobile on page 3-4. In addition, if you would like to view or modify these FileMaker Pro databases, you can open the files using FileMaker Pro 8 or FileMaker Pro 8 Advanced. These files are in the following locations:

Important Be sure to close the hosted database on FileMaker Server 8 or FileMaker Pro 8 before configuring the mobile settings. In addition, your access privileges must include the Design Layouts privilege. To configure mobile settings for a hosted database:
1. Start the FileMaker Mobile 8 application. 2. From the main FileMaker Mobile 8 window, click Configure. 3. When prompted, go to the FileMaker Pro database that you want to configure mobile settings for. 4. Define mobile settings for the database.
1 For Mobile Sharing, specify the handheld access to the file by allowing all users access, or by allowing access by the correct extended privilege. 1
For Mobile Fields, specify the fields you want to transfer to the handheld. For more information, see Setting up FileMaker Pro databases to work with FileMaker Mobile on page 3-4.
5. After hosting the file, use the Add hosted database command in FileMaker Mobile 8 to locate the
hosted file on the network. For more information on adding databases, see Adding FileMaker Pro databases to share with the handheld on page 3-1.
6. After the Network File Path is established in your local copy of FileMaker Mobile 8, you will be able to synchronize your handheld device successfully with the remotely hosted database file.
For more information on hosting database files with FileMaker Pro 8 or FileMaker Server 8, see the FileMaker Pro Users Guide and the FileMaker Server Administrators Guide.
Chapter 4 Using FileMaker Mobile for Palm OS
This chapter explains how to work with data in databases on your Palm OS handheld.
Loading a FileMaker Pro database onto your handheld
Perform a HotSync operation to load one or more databases onto your handheld: Be sure all the databases are shared with FileMaker Mobile. See Setting up FileMaker Pro databases to work with FileMaker Mobile on page 3-4. Warning Do not interact with FileMaker Pro during the HotSync operation.
Opening a database on the handheld
To open a database on the handheld:
1. In the handhelds Applications Launcher, tap the FileMaker 8 icon. 2. Tap a database in the list.

Viewing records

You can look at records one by one or in a list.
Tap anywhere in a line to switch to form view

List View

Form View

To View the list of databases View records in a list View one record at a time In list view, scroll column to column In list view, scroll list up and down In form view, scroll record to record In form view, scroll field to field
You can navigate by pressing the scroll buttons on the front panel of your handheld. You can also use the Jog Dial navigator on Sony handhelds to scroll through databases and records. To go directly to a record, choose Record menu > Go to Record, then enter the record number and tap OK. You can change the way fields display.
To Resize a field Change the field order Allow or prevent resizing or reordering columns, or sorting by column label Change the text width, alignment, or color in a field In this view List List List Do this with the stylus Tap and hold the line between the field labels. Tap and hold a field label, then drag it to a new location. Choose Options menu > List View Options, then select the desired options. Tap OK. Tap the field, choose Options menu > Field Options, then select the desired options. Tap OK. Color options are only available on handhelds that support text colors. Change the alignment of field labels Allow changes to records Prevent changes to records (read-only display) Form List Form Choose Options menu > Form View Options, then choose from the Field Labels pick list. Tap OK. Choose Options menu > List View Options, then select Edit in list view. Tap OK. Choose Options menu > Form View Options, then clear Edit in form view. Tap OK.
Using FileMaker Mobile for Palm OS

Adding records

To add a record, tap New. Tap a field to select it and start entering information. Use the stylus to write Graffiti characters in the writing area or use the onscreen keyboard. The new record is added after the last record. In form view, you can insert a phone number from your Palm OS Address list into a field formatted as Standard, Popup List, or Notes. Display the record, tap the field that contains the name you want to look up, then choose Options menu > Phone Lookup.

Finding records

To find records:
1. Tap Find. 2. For Field, select the field you want to search in. 3. Enter the word or first few characters of the item you want to find and tap OK.

Sorting records

To sort records:
1. Choose Record menu > Sort Records. 2. For Field, select the field you want to sort by. 3. Select Ascending Order or Descending Order and tap OK.
You can also sort records in list view by tapping a column heading. The underlined column heading indicates that the records are currently sorted by that field. To enable or disable this feature, see Viewing records on page 4-1.

Deleting a record

To delete a record from a database on the handheld:
1. Select the record. 2. Choose Record menu > Delete Record.
To also delete the corresponding record in the desktop database the next time you do a HotSync, select Delete original on PC.
3. Tap OK to confirm the action.
Deleting all records in a found set
To delete all of the records in the current found set:
1. Choose Record menu > Delete All Records.
To also delete all of the corresponding records in the desktop database the next time you do a HotSync, select Delete originals on PC.
2. Tap OK to confirm the action.
Deleting a database from your handheld
To delete a database from your handheld:

1. Tap

to display the list of databases.
2. Choose Database menu > Delete Database. 3. Select a database and tap Delete, then tap Yes to confirm the action. 4. Tap Done.

Setting database options

To set database options:
1. Choose Options menu > Database Options. 2. Set the following options.
To Allow the active FileMaker Mobile database to be searched when you use the Palm OS Global Find command Select Include in Global Find
Create a backup of the FileMaker Mobile.pdb file during a HotSync operation. The Backup at HotSync file is located in the backup directory of the Palm user directory, for example: C:\Palm\username\Backup. Tip A.pdb file is a Palm database file. Select this option if you perform a HotSync operation on a computer that doesnt have the FileMaker Mobile conduit installed. You can also select this option if you use a backup utility to back up to an external card. Enable synchronization of the active database. Change the login account to access database records during synchronization. Synchronize database Login > Specify

3. Tap OK.

Synchronizing information between your handheld and computer
Perform a HotSync operation to synchronize information between your handheld and computer: Be sure all the databases are shared with FileMaker Mobile (see Setting up FileMaker Pro databases to work with FileMaker Mobile on page 2-1). Warning Do not interact with FileMaker Pro during the HotSync operation.
Chapter 5 Using FileMaker Mobile for Pocket PC

This chapter explains how to work with data in databases on your Pocket PC handheld.
Perform an ActiveSync operation to load one or more databases onto your handheld: Be sure all the databases are shared with FileMaker Mobile (see Setting up FileMaker Pro databases to work with FileMaker Mobile on page 3-4). Warning Do not interact with FileMaker Pro during the ActiveSync operation. Note All databases downloaded to your Pocket PC are downloaded to the \My Documents\FileMaker directory.
1. In the handhelds Programs folder, tap the FileMaker Mobile 8 icon. 2. Tap a database in the list.
List view To View the list of databases View records in a list View one record at a time View first record View previous record View next record View last record Create new record Sort records Find records Show/hide toolbar Tap

Form view

To go directly to a record, choose Records menu > Go to Record, then enter the record number and tap OK.
Using FileMaker Mobile for Pocket PC
You can change the way fields display.
To Resize a field Change the field order Enable or prevent resizing or reordering columns, or sorting by column label Change the column width, alignment, or color in a field Use large fonts Allow/prevent changes to records Allow/prevent changes to records Change the alignment of field labels Use large fonts In this view List List List Do this with the stylus Tap and hold the line between the field labels. Tap and hold a field label, then drag it to a new location. Choose Tools menu > Options menu > List View Options, then select the desired options. Tap OK. Tap the field, choose Tools menu > Options menu > Field, then select the options. Tap OK. Tap the field, choose Tools menu > Options menu > List View, then select the option. Tap OK. Choose Tools menu > Options menu > List View Options, then select/clear Edit in list view. Tap OK. Choose Options menu > Form View Options, then select/clear Edit in form view. Tap OK. Choose Tools menu > Options menu > Form View Options, then choose from the Field Labels pick list. Tap OK. Choose Tools menu > Options menu > Form View Options, then select Use large fonts. Tap OK.
List List List Form Form Form
To add a new record, choose Records menu > New Record. Tap a field to select it and start entering information. Use the stylus to write characters in the writing area or use the onscreen keyboard. The new record is added after the last record. To copy an existing record, choose Records menu > Duplicate Record. Tap a field to select it and change the existing information. Use the stylus to write characters in the writing area or use the onscreen keyboard. The new record is added after the last record.

1. Choose Records menu > Find Records. 2. For Field, select the field you want to search in. 3. Enter the word or first few characters of the item you want to find and tap Find.
1. Choose Record menu > Sort Records. 2. For Field, select the field you want to sort by. 3. Select Ascending or Descending and tap Sort.
You can also sort records in list view by tapping a column heading. An arrow next to a column heading indicates that the records are currently sorted by that field. To enable or disable this feature, see Viewing records on page 5-2.
1. Select the record. 2. Choose Records menu > Delete Record.
To also delete the corresponding record in the desktop database the next time you do an ActiveSync, select Delete original(s) on Desktop.
3. Tap Delete to confirm the action.
1. Choose Records menu > Delete All Records.
To also delete all of the corresponding records in the desktop database the next time you do a ActiveSync, select Delete original(s) on Desktop.
2. Tap Delete to confirm the action.
2. Tap-and-hold on the database to delete. 3. Tap Delete. 4. Tap Yes to confirm.
To change database options:
1. Choose Tools menu > Options menu > Synchronization. 2. Set the following options.
To Enable synchronization of the active database. Change the login account to access database records during synchronization. Select Check Synchronize database Choose one of the login account options.
Perform an ActiveSync operation to synchronize information between your handheld and computer: Be sure all the databases are shared with FileMaker Mobile. See Setting up FileMaker Pro databases to work with FileMaker Mobile on page 3-4. Warning Do not interact with FileMaker Pro during the ActiveSync operation. Note Only databases stored in the \My Documents\FileMaker directory on your Pocket PC handheld will be synchronized.
Chapter 6 Administering FileMaker Mobile solutions

Product information

For up-to-date product information, see:
www.filemaker.com (North American customers) www.filemaker.com/intl/ (customers outside of North America)

Field contents

If a database on your handheld doesnt appear to contain any fields, be sure you specify fields on your desktop before loading the database to your handheld. See Setting up FileMaker Pro databases to work with FileMaker Mobile on page 3-4. A fields display is limited to the size of a Palm OS handhelds screen. To view a fields entire contents, tap the last line in the field and drag the stylus downwards. The text that was hidden (up to the limit of approximately 2000 characters) scrolls into view. You can also resize a field in list view. (See Viewing records on page 4-1.) If you cant enter or change data on your handheld, the field or records may be set to display as read-only:

Comments *Perform without Dialog option must be selected.

Records

*Perform without Dialog option must be selected.

Found Sets

Accounts

Miscellaneous

Symbols
.pdb files 2-2 creating with backup 4-4.prc files 2-2 Fields changing definitions 6-1 types 6-1 changing order 4-2, 5-3 data entry options 3-6, 4-2, 5-3 display options 3-6, 4-2, 5-3 hidden contents 6-1 inserting phone numbers 4-3, 5-3 labels 3-6, 4-2, 5-3 maximum number 6-2 maximum size 6-2 missing from handheld 6-1 preventing changes 3-6, 6-1 properties 3-6 resizing 4-2, 5-3 specifying for transfer to handheld 3-5 FileMaker Server, synchronizing hosted files for 1-3 Files comma-separated values 6-1 hosted 1-3, 3-8 loading onto Palm handheld 4-1 loading onto Pocket PC handheld 5-1 opening on Palm handheld 4-1 opening on Pocket PC handheld 5-1 setting up to work with FileMaker Mobile 3-4 sharing with handheld 3-2 Finding records Global Find option 4-4 on handheld 4-4, 5-3 on Palm handheld 4-3 prior to ActiveSync operation 5-1 prior to HotSync operation 3-7, 4-1 Form view described 4-1, 5-2 options 4-2, 5-3 Found sets, transferring to handheld 3-7

Global Find option 4-4

Hosting databases 1-3, 3-2 configuring 3-8 HotSync options for synchronizing 3-7, 4-4 synchronizing data 1-2, 4-5
ActiveSync 1-2, 5-5 options for synchronizing 5-5 Adding records 4-3, 5-3 Application enabling 3-4 installing 2-1
Installing FileMaker Mobile application 2-1 application on handheld 2-1, 2-3
Backup option, creating.pdb file 4-4
Capitalizing data 3-6 Checkboxes 3-6 Comma-separated values file 6-1 Customer support 1-1

Jog Dial navigator 4-2

Labels, fields 3-6, 4-2, 5-3 Language support 1-4, 2-2 Limits field size 6-2 number of databases 6-2 number of fields 6-2 number of records 6-2 List view described 4-1, 5-2 options 4-2, 5-3 Local databases 3-2
Data entry options 3-6 Databases maximum number 6-2 options 4-4, 5-5 Date fields 3-6 Deleting all records in found set 4-4, 5-4 database from handheld 4-4, 5-4 records 4-3, 5-4 Desktop application, described 1-2
Mobile application described 1-2 enabling 3-4 Mobile application and synchronization installing 2-1
Field definitions, changing 6-1 Field types, changing 6-1

Notes fields 3-6

Opening files on Palm handheld 4-1 on Pocket PC handheld 5-1 Overview, FileMaker Mobile 1-2

Registering FileMaker Mobile 1-1 Remote databases 3-2 configuring 3-8 Removing FileMaker Mobile 6-3 Resetting FileMaker Mobile 6-3
Technical specifications 6-2 Technical support 1-1 Text formats 3-6, 4-2, 5-3 Time fields 3-6 Troubleshooting 6-1
Script steps allowed in synchronization scripts 6-5 Sharing files 3-2 Single checkbox 3-6 Sony Jog Dial navigator 4-2 Sorting records 4-3, 5-4 Standard field format 3-6 Starter Solutions 3-2 Support customer 1-1 technical 1-1 Synchronization module, described 1-2 Synchronization scripts, steps allowed 6-5 Synchronization, installing 2-1 Synchronizing data 4-5, 5-5 resolving record differences 3-8 with remote files 1-3, 3-9 System requirements Windows 1-3
Using multiple handhelds 6-2
Phone lookup 4-3, 5-3 Popup lists 3-6 Popup menus 3-6 Product registration 1-1 Properties for fields 3-6
Value lists 3-6 Viewing records 4-1, 5-2
Web site for registering software 1-1 technical support 1-1
Record view. See Form view Records adding 4-3, 5-3 deleting 4-3, 5-4 deleting all in found set 4-4, 5-4 finding on handheld 4-4, 5-3 finding on Palm handheld 4-3 maximum number 6-2 preventing changes 4-2, 5-3, 6-1 resolving differences at synchronization 3-8 sorting 4-3, 5-4 viewing 4-1, 5-2