2.0
Table Of Contents
- Introduction
- Installation and Setup
- Tutorials
- Views and Form Usage
- OmniForm Procedures
- Designing a Form
- The Design Process
- The Design View Toolbars
- Creating Objects
- General Creation Guidelines
- Creating a Text Object
- Creating a Line Object
- Creating an Oval Object
- Creating a Rectangle Object
- Creating a Graphic Object
- Creating a Fill Text Object
- Creating a Comb Object
- Creating a Check Box Object
- Creating a Circle Text Object
- Creating a Table Object
- Creating a Fill Graphic Object
- Defining Objects
- Changing Object Appearance
- Redesigning Your Form
- Using the Scrapbook
- Inserting OLE Objects in a Form
- Filling a Form
- Managing an OmniForm Database
- Using Calculations
- Calculation Overview
- Operators
- Functions
- Abs (Absolute Value)
- Avg (Average)
- Date (Current Date)
- DayName
- DayOfMonth
- DayOfWeek
- DayOfYear
- Exp (Exponentiation)
- FV (Future Value)
- Hour
- If
- Int (Integer)
- Left
- Length
- Ln (Natural Logarithm)
- Log (Base 10 Logarithm)
- Lower
- Max (Maximum)
- Middle
- Min (Minimum)
- Minute
- Mod (Modulus (Remainder))
- Month
- MonthName
- Pi
- PMT (Payment)
- Position
- Proper
- PV (Present Value)
- RecordCount
- Replace
- Replicate
- Right
- Round
- Second
- Sign
- Sqrt (Square Root)
- Sum
- Time
- Trim
- Trunc (Truncate)
- Upper
- Year
- Functions — Quick Reference
- Functions Sorted by Type
- Technical Information
- Glossary
Filling Fields
Filling a Form - 187
Fields Defined by a Calculation
The only time you would notice a calculation in fill view is when a field
fills in automatically.
In the example below, the
TOTAL
field automatically added the
amounts entered in the first and second fields. The
TOTAL
would
increase if the third and fourth fields were filled as well.
You define a calculation on a field in design view. See Chapter 8, Using
Calculations, for detailed information on calculations.
Field Validation
Fill text fields can be configured by the creator to:
• Require that you enter information in a field and do not leave it
blank.
• Require that you enter specific information in a field.
• Require both of the above.
This is
field validation
and ensures that information entered in a form is
consistent. For example, you may be required to enter a date in a
validated
Date
field. You would receive a reminder prompt from
OmniForm if you attempted to enter anything other than a date.
• Click
No
to return to the field and enter the expected information.
• Click
Yes
to override field validation.
See “Set Validation Options” on page 141 for detailed information on
field validation.