Blog Recap For March 2008

From Dwayne Wright
Certified FileMaker 9 Developer

Here is a wrapup of the FileMaker blog posts that I published for March 2008.



Scripted Imports And The Target Table
Finding Duplicates Not Working
Other Import Options We Didn’t Cover
The Basics Of Exporting Data
The FileMaker Supported Export Formats
A Before You Export To Do List
Working With Found Sets

The DatabaseNames Function
The FieldBounds Function
The FieldComment Function
The FieldIDs Function
The FieldNames Function
The FieldRepetitions Function
The FieldStyle Function
The FieldType Function
The GetNextSerialValue Function
The LayoutIDs Function
The LayoutNames Function
The Relationinfo Function
The ScriptIDs Function
The ScriptNames Function
The TableIDs Function
The TableNames Function
The ValueListIDs Function
The ValueListItems Function
The ValueListNames Function
Age In The Future

Introducing GTRR
EXAMPLE: Go To Related Record (GTRR)
Portals Swapping Data With Each Other
Performing Finds In Portals
EXAMPLE: Finds In Portals ( unstored parent keys )
Found Set Of Child Records Showing Up In Portal


FileMaker Server Mentality
Windows Script Steps Listed
DYK: FileMaker Email Lists and Newsgroups
A READER ASKS: How can I get this field filled in?
Merge Data To The Clipboard
Do you have a solution for "format telephone number" for FMP 6.0?
Hiding The Left Side
Help In FileMaker 6 Conversion
The Hyperactive Layout
Over 350 FileMaker 6 Training Videos Added Online
Documenting Privilege Sets On FileMaker Fever
Software Publishing: Professional Services
Software Publishing: Contract Employees
DYK: The Active Script Area In Script Debugger

The New Lookup Functions
Data Entry - Existing Values Only
You Cannot Lookup A Field Without Access To It
Pass Global Data Sans A Relationship
Layout Setup Allows You To Back Out
A Couple Relationship Design Tips
Broken Relationships

The Delete All Records Script Step
Open Record / Request Script Step
The Revert Record / Request Script Step
The Commit Records / Requests Script Step
The Copy Record / Request Script Step
The Copy All Records / Requests Script Step
EXAMPLE: Copy All Records
The Import Records Script Step
The Export Records Script Step
Save Records As Excel Script Step
Save Records As PDF Script Step
The New Window Script Step
The Select Window Script Step
The Close Window Script Step
Adjust Window Script Step
Arrange All Windows Script Step

How Does The Password Get Out Or Discovered?
Cascading Delete Breakdown
Password Rotation
Launcher Files With Embedded Account Settings
EXAMPLE: Enter Into A Field If ...

Self Relationship
Field Borders Dialog Box
Send To Back Command
Modularizing Scripts
Tools Palette
Leading Sub Summaries
IP Address
Fill Tool
Data Access
FileMaker Runtime Versions
Repeating Functions
Options For Summary Fields
Ranged Relationships
Validation Feedback Option
Record Locking
Verifying Processes
Client Server Architectures
Sort Records Dialog
Worker Machines
Arithmetic Operations
Automatically Create Indexes
Conditional Privileges
Data Viewer
Current Found Set
Update Matching Records
More info about the author and FileMaker in general, contact me at

© 2008 - Dwayne Wright -

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.