9 FileMaker Pro Tips using the Set Variable script step to make your scripts more efficient, portable and easier to maintain.
Use variables instead of global fields. Variables are stored in active system memory while fields are stored on disk. Therefore, accessing a variable is much faster than accessing fields. So, use global variables instead of [...]
Continue reading ...This article describes a script-less technique for using dynamic relationships and portals to search values in a related table using a single global field. It is a part of a series on Advanced Search Interfaces.
This technique produces an interface similar to the Google-like Search described in previous articles in this series, but instead of using [...]
This article is a part of a series on Advanced Search Interfaces.
In my article, Google-Like Searches In FileMaker, I described a method for creating a search-engine-like interface for searching the contents of a FileMaker Pro database. This article expands on that method by eliminating one of it’s shortcomings: it would only find records containing all [...]
This article is a part of a series on Advanced Search Interfaces.
Using a single, global field and a fairly simple script, you can create a search-engine-like interface for searching the contents of a FileMaker Pro database.
Step One: Create a Global Search Field
Create a text field in any table. In the field options, set the new [...]
FileMaker Pro’s built in Find Mode is great for those of us who know FileMaker well and understand the data structure of our databases well enough to know which fields to search in. But a more elegant, user friendly search mechanism is often needed.
There are a number of techniques that I recommend for making user [...]
This article, reprinted from one I submitted to Ezine Articles, discusses the creation of a Search and Replace function similar to the built-in Substitute function. When this article was written, the Substitute function did not exist. However, the article still serves as a learning tool for creating recursive custom functions in FileMaker Pro Advanced.
The introduction [...]
Previous Versions of FileMaker Pro and ODBC
Filemaker Pro has had the ability to connect to and use ODBC as early as version 7. Using the Execute SQL script step, you could specify a ODBC DSN (Database Source Name) and execute any SQL statement that you can build with a FileMaker Pro calculation which could include [...]
FileMaker Inspirations is a blog for FileMaker users and developers looking for FileMaker tips, tricks and techniques.
Danny Kohn of Inspirations Software Design developed and maintains this site and content. He is a FileMaker 9 Certified Developer with nearly a decade of FileMaker development experience.
©2007 Inspirations Software Design.
All rights reserved.
For topic requests, questions, feedback, or to contribute a guest post feel free to contact us.
Powered by WordPress.
