FMPro Flash 
With QuickTime 4 or greater installed, users can view Macromedia Flash 3 movies that have been imported into container fields. This example shows a splash screen, and includes some tips. (Not sure how well this works on Windows yet. Drop me an e-mail and let me know!) |
 FMPFlash.hqx
 fmpflash.zip
|
Low Scores
A question was raised how to find the lowest 10 scores among the 20 most recently posted golf scores. Here's a flexible solution that demonstrates two approaches: one using a many-to-many relationship and the “Go to Related Record” script step, the other a simpler Find. |
LowScore.hqx
lowscore.zip |
Title Jump
Shows how to scroll to, or isolate records beginning with a specified letter in a list of alphabetized titles. |
TitleJmp.hqx
titlejmp.zip |
Assorted Graphics
Various buttons, icons, patterns, palettes, etc. I've created over the years. Some useful, some not, marginally organized. About 400K compressed. |
Graphics.hqx
graphics.zip |
ClipSave Routine
This shows how to store and retrieve the contents of the clipboard when using scripts that require copying and pasting, such as, in this example, storing the current found set. It's even polite enough to clear the clipboard if it was empty. |
ClipSave.hqx
clipsave.zip |
Speaker Dialing
This example dials the phone through the speaker using sound container global fields instead of FileMaker's Modem/Connection Preference. This lets you to customize the dial sounds (e.g., quicker, louder), and to quickly toggle between dialing via modem vs. speaker. It also implements dialing preferences using global fields. |
DialPhon.hqx
dialphon.zip |
Phone Format Phun
This auto-formats US phone numbers in any pattern of ###-###-#### that is selected by the user, and adds a default area code if none is entered. Uses an overlaying calc field that also acts as a button to "correct" the phone number entry field with the formatted number. |
PhnFrmat.hqx
phnfrmat.zip |
Group E-mailing
This example is primarily of interest to FileMaker 3 for Mac users. If it detects you are using that version, it uses an AppleScript to send mail via the mailto: helper application of your preferred browser, otherwise it uses the Send Mail script step. The user can choose to send email to the current record, or the found set of records. |
GrpEmail.hqx
grpemail.zip |
Dynamic Printing (Skipping Blank Fields)
Three approaches to limiting a printout to only the fields that have data: The first uses calculated field labels that slide up, the second uses a calculated field that includes the field labels, and the final uses merge fields to retain the text formatting, using calculated tabs and returns. |
DynaPrnt.hqx
dynaprnt.zip |
Dynamic Field Formatting
This changes the field formatting (font, bold, etc.) based on a calculation, then allows you to edit the formatted instance of the field (and tab to the next field). Works best if the formatted field is first on the layout, since because entry is a scripted button, it cannot be included in the tab order. |
BldFrmat.hqx
bldfrmat.zip |
Toggle Field Display
Let’s say you have room in a layout for either a home or a work address, but not both. Here’s one solution: Create a third field—a “primary address”—whose label changes to indicate whether it’s the home or work address, while automatically updating the actual home address or work address fields (and vice versa). |
TogglFld.hqx
togglfld.zip |
Looping Close Script
Here is an example of a closing script that won’t allow the file to close until specific conditions have been met, e.g., if you have a field that can’t be left blank. |
EndLoop.hqx
endloop.zip |
