FileMaker 8.
© 2006 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries, and ScriptMaker and the file folder logo are trademarks of FileMaker, Inc. All persons and companies listed in the examples are purely fictitious and any resemblance to existing persons and companies is purely coincidental. FileMaker documentation is copyrighted.
Contents Chapter 1 Introduction About script steps Using this script steps reference Script steps reference (alphabetical list) Chapter 2 Control script steps Perform Script Pause/Resume Script Exit Script Halt Script If Else If Else End If Loop Exit Loop If End Loop Allow User Abort Set Error Capture Set Variable Chapter 3 Navigation script steps Go to Layout Go to Record/Request/Page Go to Related Record Go to Portal Row Go to Object Go to Field Go to Next Field Go to Previous Field Enter Browse Mode En
FileMaker Script Steps Reference Cut Copy Paste Clear Set Selection Select All Perform Find/Replace Chapter 5 Fields script steps Set Field Set Next Serial Value Insert Text Insert Calculated Result Insert From Index Insert From Last Visited Insert Current Date Insert Current Time Insert Current User Name Insert Picture Insert QuickTime Insert Object (Windows) Insert File Update Link (Windows) Replace Field Contents Relookup Field Contents Export Field Contents Chapter 6 Records script steps New Recor
| Save Records As Excel Save Records As PDF Chapter 7 Found Sets script steps Perform Find Constrain Found Set Extend Found Set Modify Last Find Show All Records Show Omitted Only Omit Record Omit Multiple Records Sort Records Unsort Records Chapter 8 Windows script steps New Window Select Window Close Window Adjust Window Move/Resize Window Arrange All Windows Freeze Window Refresh Window Scroll Window Show/Hide Status Area Show/Hide Text Ruler Set Window Title Set Zoom Level View As Chapter 9 Files sc
FileMaker Script Steps Reference Recover File Print Setup Print Chapter 10 Accounts script steps Add Account Delete Account Reset Account Password Change Password Enable Account Re-Login Chapter 11 Spelling script steps Check Selection Check Record Check Found Set Correct Word Spelling Options Select Dictionaries Edit User Dictionary Chapter 12 Open Menu Item script steps Open Preferences Open File Options Open Define Database Open Define File References Open Define Value Lists Open Find/Replace Open
| Contents Dial Phone Install Menu Set Set Web Viewer Open URL Send Mail Send DDE Execute (Windows) Perform AppleScript (Mac OS) Execute SQL Send Event (Mac OS) Send Event (Windows) Comment Flush Cache to Disk Exit Application 140 141 142 143 144 146 147 148 150 151 152 153 153 Appendix A Glossary 155 7
FileMaker Script Steps Reference
Chapter 1 Introduction About script steps Scripts can do simple tasks like setting print orientation or complex tasks like preparing a customized mailing to each client. For example, you could define a complex set of scripts that creates a thank you letter to clients in your Client database who have made a purchase in the last week. The script composes a letter tailored to each client. The script switches to Preview mode and pauses so you can see what the letter looks like before it prints.
FileMaker Script Steps Reference Script steps reference (alphabetical list) This section lists the script steps in alphabetical order.
Chapter 1 F Flush Cache to Disk Freeze Window 153 97 G Go to Field Go to Layout Go to Next Field Go to Object Go to Portal Row Go to Previous Field Go to Record/Request/Page Go to Related Record 37 32 38 36 35 38 33 34 H, I, J, K Halt Script If Import Records Insert Calculated Result Insert Current Date Insert Current Time Insert Current User Name Insert File Insert From Index Insert From Last Visited Insert Object (Windows) Insert Picture Insert QuickTime Insert Text Install Menu Set 20 21 75 55 57 5
FileMaker Script Steps Reference Open URL 143 P Paste Pause/Resume Script Perform AppleScript (Mac OS) Perform Find Perform Find/Replace Perform Script Print Setup Print 46 18 147 82 49 16 110 111 Q, R Recover File Refresh Window Re-Login Relookup Field Contents Replace Field Contents Reset Account Password Revert Record/Request 109 98 118 64 63 115 72 S, T Save a Copy as Save Records As Excel Save Records As PDF Scroll Window Select All Select Dictionaries Select Window Send DDE Execute (Windows
Chapter 1 Unsort Records Update Link (Windows) View As 88 62 102 | Introduction 13
FileMaker Script Steps Reference
Chapter 2 Control script steps Control script steps control the progression of the script by letting you tell FileMaker Pro exactly what to do when and if specific conditions occur.
FileMaker Script Steps Reference Perform Script Format Perform Script [“