U.M. (Mac OS)
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
- Index
Summary of functions C-15
The following example shows how the If function returns a different
result based on a true or false condition.
Choose FileMaker Help Index from the or Help menu, and then type:
E logical functions
SYNTAX:
If (Test,ResultIfTrue,ResultIfFalse)
BASIC EXAMPLE (Not Nested):
If(Signal="Green",Go,Stop)
When test is True When test is False
If(Signal="Green",Go,Stop) If(Signal="Green",Go,Stop)
ADVANCED EXAMPLE (Nested If’s):
If (Signal="Green",Go, If(Signal="Yellow",Slow down,Stop))
When first test is True
If (Signal="Green",Go, If(Signal="Yellow",Slow down,Stop))
When first test is False
If (Signal="Green",Go, If(Signal="Yellow",Slow down,Stop))
When second test is True
If (Signal="Green",Go, If(Signal="Yellow",Slow down,Stop))
When second test is False
If (Signal="Green",Go, If(Signal="Yellow",Slow down,Stop))