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
Calculation Overview
Using Calculations - 227
• If you change a field name and that field is part of a calculation,
you must change the field name in the calculation as well.
OmniForm cannot perform the calculation otherwise.
• Calculations are performed in tabbing order.
• If a calculation contains another field that has a calculation, the
other field’s calculation is performed first.
Usage Conventions
Substitute the appropriate field name where you see
num
and
str
in the
function examples. Parentheses are required where indicated. Below is
a list of conventions showing operator and function usage.
date
date value: the expression must evaluate to a valid date
time
time value: the expression must evaluate to a valid time
num
number or numeric expression; num1, num2, etc. indicate
additional number values
str
text string: str1, str2, etc. indicate additional string values
...
additional repeating values of the given type may be entered
[ ]
brackets inserted around field names
log exp
logical expression
true exp
true expression
false exp
false expression