Using File Maker 11’s new Portal Filtering feature, you can now show filtered views of related records in portals without having to define new relationships. How about dynamically filtering your portal data while you’re typing letters into your search field!
With a very simple script (4 steps), a custom function and a script trigger, you can search data in your File Maker portals the same way you search for music in i Tunes! Add portal filtering that uses a custom function you will create.
Waldie For the past couple of columns, we have discussed various ways to store and access data using Apple Script.
Accessing and Opening Databases The first thing we will discuss, is general database interaction.
When scripting File Maker Pro, the first thing you will probably want to do, is make sure that your target database is opened.
This is similar to how most search engines on the web work these days.
Google for example defaults to showing 10 results per page.
A File Maker Pro database, named Super Heroes, is referenced throughout this month's column. You may download a copy of this database from TECH.03.06.
This example database is password protected with an account name of Admin and a password of heroes.
With the File Maker PHP API you use the set Range() method to request only part of the found set of records by passing in 2 paremeters: the first parameter is the number of records to skip past and the second parameter is the maximum number of records to return.
Say you do a search and you find 52 matching records.
During one of my sessions at the recent 2010 File Maker Developer Conference in San Diego I was asked about the pagination/navigation on a search results page that is generated by the File Maker PHP API.
They were referring to the links you might see at the top/bottom of the search results page like this: First | Previous | Record 21 – 40 of 52 Next | Last which are generated dynamically and use the equivalent of conditional formatting in File Maker to display only the necessary elements.
Another column explored methods of storing and accessing data in script properties and property list files.