U.M. (Windows)
Table Of Contents
- Preface: Getting help
- Chapter 1: FileMakerPro basics
- Chapter 2: Creating a database file
- Chapter 3: Laying out and arranging information
- Understanding layouts
- Working with predefined layout types
- Arranging records in columns
- Managing layouts
- Working with layout parts
- Changing layout parts
- Working with all object types
- Working with graphic objects
- Working with fields in a layout
- Adding fields to a layout
- Adding merge fields
- Deleting a field from a layout
- Defining display formats for fields
- Determining data entry in fields
- Setting the tab order for data entry
- Adding scroll bars to fields
- Formatting repeating fields
- Adding borders, fill, and baselines to fields
- Defining value lists
- Formatting fields with value lists
- Working with text
- Chapter 4: Working with information in records
- Working in Browse mode
- Adding data to a file
- Selecting a field for data entry
- Adding and duplicating records
- Entering and changing data in fields
- Working with container fields
- Entering data from a value list
- Viewing and inserting data from another source
- Copying and moving values and records
- Using drag and drop to move information
- Replacing field values
- Working with records
- Finding information
- Deleting records
- Sorting records
- Chapter 5: Using ScriptMaker and buttons
- Chapter 6: Previewing and printing information
- Chapter 7: Networking and access privileges
- Chapter 8: Importing and exporting data
- Chapter 9: Customizing FileMakerPro
- Chapter 10: Using data from related files
- Chapter 11: Publishing files on the Web
- About the World Wide Web
- About FileMaker Pro Web Companion
- Publishing your database on the Web—an overview
- Getting ready to publish your files on the Web
- Setting up FileMaker Pro Web Companion
- Configuring FileMaker Pro Web Companion
- Setting up Instant Web Publishing
- Database security
- Helping Web users find your database
- Custom Web Publishing
- Appendix A: Recovering damaged files
- Appendix B: Working with international files
- Appendix C: Summary of functions
- Appendix D: Linking and embedding objects
- Index
Using ScriptMaker and buttons 5-27
Example step 2: Add two fields
Define these fields in the Seminar file:
1 A text field, called Mark. When the script finds a duplicate record, it
places an x in this field to mark the record.
1 A global field, called Global, to store the unique identification while
comparing records. Global should be the same data type as the Client
ID field.
Example step 3: Display the Mark field
Create a layout that displays the Mark field, or add the field to an
existing layout. You’ll use this layout to store Find settings in the
following step.
Example step 4: Store settings
Store Sort and Find settings for the script.
Example step 5: Define the script
In ScriptMaker, define the Find Duplicates script.
To store this setting Do this
Sort In Browse mode, choose Sort from the Mode menu. If fields
appear in the Sort Order list, click Clear All. Click ClientID,
choose Ascending order, click Move, and then click Done.
Find Choose a layout that displays the Mark field. In Find mode,
type x into the Mark field, and then switch to Browse mode.
(You don’t have to perform the find request.)