home home process process skills skills customers customers sensible IT sensible IT pricing pricing products products downloads downloads people people press room press room contact us contact us
downloads
Free Sample Downloads
FM8 Value Lists
An example file to show you how to use the new value list capabilities in FileMaker Pro 8.
fm8_valuelists.zip
FM8 Paths with variables
An example file to show you how to use the new set variable script step to specify a path on the user's machine to export pdf or excel file to.
path_w_variable.zip
FM Advisor Article sample file: Teleporting
An example file to show you how to use the "go to related records" script step to jump from one relational context to another within your FM7/8 solution.
teleport.zip
DevCon 2005 Session: Understanding Data Context
Includes the latest powerpoint slides and example files to show you how to understand data context in FileMaker 7 and 8.
context.zip
DevCon 2005 Session: User-Centric Database Design
Includes the latest powerpoint slides which explain simple Use Case Analysis in FileMaker Pro development.
user_centric.zip
Check Box Control
Use a field with a checkbox value list to act in a tightly controlled fashion like a cross between a radio button and a checkbox list. Uses an auto-enter calculation trick to simulate a SQL trigger's use of before change and after change values.
checkbox_control.zip
Calendar
A small popup calendar using FM7 style scripting and functions. Feel free to use this, change the look, and include it in your own solutions, to save time.
calendar.zip
Shell Scripts
A very simple file showing how to perform shell scripts in OS X from FM7. Also shows how to set a field in FM from the result of a shell script. Thanks to Matt Petrowski for this idea.
shell_example.zip
Filtered Portals
Using FM7's new relationship range operators, you can now give your users filtered portals without having a calculation field in the data table.
filter.zip
Data/Presentation Separation Demo
FMP7 now allows a complete separation of data and presentation. This small contact manager shows how selected portals can be hilited without including a hilite calculation field in the data tables.
separation.zip
Text Formatting (New Improved Method with Custom Function!)
Now you can change text formatting like color, style, font, and size with a calculation. This file shows an example of this using a handy custom function which references the standard 88 FMP colors.
text_format.zip
Create a Text File with a Custom Function
Using a custom function (which you are free to steal!), this sample solution creates an applescript, shell script, or dos command on the fly to create a text file and write to its contents from FM fields.
text-write.zip
Window Tricks
FMP7 allows full control over window sizing and placement. This file demonstrates some of what can be done with windows in FMP7.
window_tricks.zip
Horizontal Portals
Here is something you couldn't do before! Portals can go across now as well as down, if you learn this simple trick.
horiz_portal.zip
Field Behavior Options
Now you can specify the return or the enter key to navigate from field to field. You can also prevent fields from being entered in find or browse mode.
field_bhvr.zip
Multi-relational Hops
FMP7 allows you to access records directly that are several tables away relationally. This file shows a simple example of how the new relationships work.
gtrr_multi_hop.zip
Technical Information
Foundations of the FileMaker Pro 7 Relational Model
By NCD's Jim McNeely. A straightforward explanation of the way that the relational model works in FileMaker Pro 7. Read this short paper in 5 minutes and be up to speed on the new relational model.
fm7_rel_1.pdf
Key Concepts in FileMaker Pro 7
By Michael Harris, Senior Partner, Cerne Systems Inc. A great and lucid introduction to FileMaker Pro 7's relational model.
FM7_key_concepts.pdf
Migration strategy from FMP 5,6 to 7
fm7_converting.pdf
FMP 7's new security model
techbrief_security.pdf
whitepaper_fm7_security.pdf