Photo by Sandy Hechtman
December 11, 2008: Agnes Riley presented a FileMaker-made-mobile solution to the members of the New York Motion Picture Collective and the New York FileMaker Developer Group. The presentation demonstrated bringing a database from FileMaker to the iPhone through the use of FMTouch.
Click the images below to get a closer look:
Click the image below to see the video:
Now, let’s look at how this is done. To get started with porting your own database to the iPhone or iPod Touch, you will need the following:
- FileMaker Pro or Advanced 8-9;
- An IPhone or iPod Touch (2.0 firmware);
- A Database Developer Report (DDR) of the file you intend to use. If you don?t have FileMaker Advanced, you can use this solution;
- The sync plug-in;
- The FMTouch User Guide;
- FMTouch Style Guide and starter database for reference;
- A pinch of patience.
It may seem daunting at first, but these simple steps will allow you to begin:
- Design your layouts you would like to use on the iPhone according to the style guide;
- Buy FMTouch form the iTunes Store;
- Download the synch plug-in and place it in your FileMaker?s extension folder, then restart FileMaker.
- Make sure the plug-in is enabled.
- Set up synching to your database on the iPhone (check the User?s Guide for more on this);
- Transfer DDR to iPhone;
- Name your Database;
- Initialize DDR;
- Choose the layouts you want to see;
- Synch your database to get the data from the computer;
- Open your database.
Congratulations! Now that you have a FileMaker database working on an iPhone or iPod Touch, here is a list of tips and tricks that might be helpful to you, as well as observations to be mindful of as you move forward in your own development.
* You can design the layouts based on the example DB and provided style guide. Make sure you pay attention to scrolling with fingers. If you don?t want editable fields to get in the way of scrolling, make sure to lock them down.
* With FMTouch you can show layouts in ?portrait? (vertical), ?landscape? (horizontal) or ?both? modes. The iPhone is not able to differentiate between layouts whether they are designed for portrait or landscape modes. So you cannot simply rotate the phone in the hope that it will switch to a different layout. So, at this point you?re better off locking FMTouch to either vertical or horizontal mode, which you can do if you go to ?Settings? after you click on the little ?i? on the bottom right.
* Every time you change the layouts you would like to show, you have to reinitialize your solution.
FMTouch is currently unable to show more than one line in a label showing text on the layout. You can, however, use two different workarounds:
- You can type every line of text into a new label;
- Or you can create a calculation field with the text you would like to show and place that on the layout.
You can use container fields in layouts, but they can only show a reference to an image. Only import the reference when you import an image; it will not show in FMTouch otherwise.
You can use the following script steps attached to a button on a layout:
- Go to Layout*
- Go to Record
- New Record
- Delete Record
- Set Field
- Go to related record.
* Note: You can use the ?GoToLayout? script step directly from a button, but you cannot use this script step as part of a script, because ?Perform Script? is not a supported script step.
Special thanks to Christina Tsao for her help with the database layouts.
I hope this has been helpful.