Example backup script
You can use the following
script to save automated backup copies of a FileMaker Pro database.
This script saves a copy of your database on the fifth close and every fifth close thereafter. To make the script work, you need to define a global field called Count Field in one of the tables in your database. If you do not define a global number field, FileMaker Pro may increment a different record each time you close the application. You should define this script in all solution files that require backups.
To create the script:
1. Choose Scripts menu > Script Workspace. Or, choose File menu > Manage > Scripts.
2. In the Script Workspace, click
.
For details on creating scripts, see
Creating and editing scripts.
3. Name the script Backup, then press Enter.
4. Enter the following script steps:
Set Field [<table name>::Count Field; <table name>::Count Field + 1]
If [<table name>::Count Field > 4]
Save a copy as ["Backup Copy.fmp12"; copy]
Set Field [<table name>::Count Field; 0]
End if
5. When you are finished, close the tab in the script editing pane, then click Save.
6. Close the Script Workspace.
7. Choose File menu > File Options, and click the Script Triggers tab.
9. Select the Backup script.
10. Click OK.
11. Close the solution file.
This script will create a backup of your file every fifth time you close the file.