Script Steps Reference
Table Of Contents
- Chapter 1 Introduction
- Chapter 2 Control script steps
- Chapter 3 Navigation script steps
- Chapter 4 Editing script steps
- 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
- Chapter 7 Found Sets script steps
- Chapter 8 Windows script steps
- Chapter 9 Files script steps
- Chapter 10 Accounts script steps
- Chapter 11 Spelling script steps
- Chapter 12 Open Menu Item script steps
- Chapter 13 Miscellaneous script steps
- Appendix A Glossary
46 FileMaker Script Steps Reference
Example
The following example calculates 7 percent of the Salary field and assigns the result to
the field SDI. Note that Set Field works whether or not the field is on the active layout.
Set Field [Table1::SDI; Salary * .07]
Set Next Serial Value
Format
Set Next Serial Value [<table::field>; <value or formula>]
Options
• Select Specify target field or click Specify to specify the serial number field on
which the script step will operate. The field you specify must be defined as an auto-
entry serial number field.
• Calculated result: Click Specify to enter the next serial value or create a calculation
to determine the next serial value.
Web compatibility
This script step is web-compatible.
Description
Resets the next serial value in an auto-entry serial number field. Set Next Serial Value
allows you to use ScriptMaker™ to update the next auto-enter serial number value. You
can define this script step to use any calculation expression to determine the next serial
value of a field that has been defined as an auto-entry serial number field. The calculation
always evaluates to a text result.
For example, you might want to reset the next serial value after you do one of the following:
• import records into a FileMaker Pro database with an auto-entry serial number field
• delete multiple serialized numbers from a FileMaker Pro database.
Notes
• This script step affects the definition of the field you specify instead of the actual
contents of the field that you specify.
• This script step can operate on multiple files. If you specify a field in another file, then
FileMaker Pro attempts to update the serial number for the specified field in the other
file. To specify a field in another file, define a relationship to that file and use Specify
target field to select a field from that file.
Example
The following example calculates the number of the next available invoice ID. If the
invoice ID contains non-numeric data, then the calculation would need to be more
sophisticated to maintain the numeric and non-numeric data.
Go to Record/Request/Page [Last]
Set Next Serial Value [Table1::Invoice ID; Table1::InvoiceID + 1]