2.0

vii
Chapter 8 Managing an OmniForm Database
What is a Database? ........................................................................................................................8-2
Managing Database Records .........................................................................................................8-3
Creating New Records ............................................................................................................8-3
Duplicating Records ................................................................................................................8-5
Moving Through a Database..................................................................................................8-6
Searching Records for Information........................................................................................8-7
Sorting Records.......................................................................................................................8-12
Recalculating Records............................................................................................................8-13
Deleting Records ....................................................................................................................8-15
Exporting Information...........................................................................................................8-16
Exported Data and Shared Forms........................................................................................8-20
Importing Information ..........................................................................................................8-21
Protecting Your Database.............................................................................................................8-26
OmniForm Filler............................................................................................................................8-27
Chapter 9 Using Calculations
Calculation Overview.....................................................................................................................9-2
Creating a Calculation.............................................................................................................9-2
Using the
Recalculate...
Command .........................................................................................9-7
Calculation Guidelines............................................................................................................9-7
Usage Conventions ..................................................................................................................9-8
Operators..........................................................................................................................................9-9
Operator Buttons......................................................................................................................9-9
Operators — Quick Reference..............................................................................................9-10
Functions ........................................................................................................................................9-11
Abs (Absolute Value).............................................................................................................9-11
Avg (Average) ........................................................................................................................9-12
Date (Current Date) ...............................................................................................................9-12
DayName.................................................................................................................................9-13
DayOfMonth...........................................................................................................................9-13
DayOfWeek.............................................................................................................................9-14
DayOfYear...............................................................................................................................9-14
Exp (Exponentiation).............................................................................................................9-15
FV (Future Value)...................................................................................................................9-15
Hour .........................................................................................................................................9-16
If................................................................................................................................................9-16
Int (Integer) .............................................................................................................................9-17
Left............................................................................................................................................9-17
Length......................................................................................................................................9-18
Ln (Natural Logarithm).........................................................................................................9-18
Log (Base 10 Logarithm) .......................................................................................................9-19