Part V: The Formula Language
Part V: The Formula Language
Overview
The Formula Language
Variables Available in Formulas
Formula Evaluation Order
Indexing
Using Table and Record Control Functions in Formulas
Using .NET Framework Functions in Formulas
Using Custom Functions in Formulas
Formula Error Reporting
Data Validation with Formulas
Dropdown Filtering with Formulas
Cross-site Scripting and SQL Injection Attacks
Formula Run-Time Performance
Common Formula Examples
Conditional Display of Field, Label and Value
Display Multiple Columns in a Dropdown List
Display Row Numbers in a Table Control
Display Row Rank in a Table Control
Display Row Totals in a Table Control
Filter Dropdown List Box Contents
Filter FieldFilter Dropdown Contents
Filter Table Control Contents
Filter Table Control by Logged-In User
Filter Table Control by URL Value
Get Largest Field Value from a Table Column
Get Smallest Field Value from a Table Column
Google Maps Integration
Hide GEN:BUTTON or Tab container
HyperLink URLs, Images and Email Addresses
Invoke a Javascript
Make, Model, Year (Dependent dropdown lists)
Modifying Values before Saving Data
Pre-Select an Item in FieldFilter Dropdown
Pre-Select Multiple Items in a FieldFilter List Box
Remove Please Select from Dropdown List
Retrieve Information from a Cookie
Retrieve Information from a Session Variable
Retrieve Information from the Cache
Save Information in a Cookie
Save Information in a Session Variable
Set Content of FieldFilter Dropdown
Validate Field Value
Validate Related Textbox Fields and Display Custom Error Message
Virtual Calculated Field in Table Record
Operators
IF
Arithmetic operators (*, +, -, %, /, ^)
Boolean operators (AND, OR, XOR, NOT)
Comparison operators (=, <>, >, <, >=, <=)
String Operators (+)
Boolean Functions
AND1
NOT1
OR1
Data Conversion Functions
PARSEDATE
PARSEDECIMAL
PARSEINTEGER
Database Functions
GETCOLUMNVALUE
GETCOLUMNVALUES
LOOKUP
DateTime Functions
ENDOFCURRENTMONTH
ENDOFCURRENTQUARTER
ENDOFCURRENTWEEK
ENDOFCURRENTYEAR
ENDOFLASTMONTH
ENDOFLASTQUARTER
ENDOFLASTWEEK
ENDOFLASTYEAR
ENDOFMONTH
ENDOFQUARTER
ENDOFWEEK
ENDOFYEAR
HOUR
MINUTE
MONTH
NOW
SECOND
STARTOFCURRENTWEEK
STARTOFCURRENTMONTH
STARTOFCURRENTQUARTER
STARTOFCURRENTYEAR
STARTOFLASTMONTH
STARTOFLASTQUARTER
STARTOFLASTWEEK
STARTOFLASTYEAR
STARTOFMONTH
STARTOFQUARTER
STARTOFWEEK
STARTOFYEAR
TIME1
TODAY
YEAR
YESTERDAY
Formatting Functions
CAST
FORMAT
Geocoding Functions
BOUNDINGBOXEDGE
CLEARBROWSERLOCATION
DECIMALTODEGREES
DECIMALTOMINUTES
DECIMALTOSECONDS
DEGREESMINSECTODECIMAL
DISTANCEBETWEEN
GETBROWSERLOCATION
GETDISTANCEUNIT
GOOGLEDIRECTIONS
GOOGLEINTERACTIVEMAP
GOOGLEMAP
GOOGLEMAPWITHDIRECTIONS
GOOGLEINTERACTIVEMAPURL
GOOGLEMAPURL
GOOGLEPOPUPMAPURL
ISWITHINRADIUS
LOCATIONTOADDRESS
LOCATIONTOLATITUDE
LOCATIONTOLONGITUDE
LOCATIONTOOTHER
SETDEFAULTLOCATION
SETDISTANCEUNIT
Information Functions
ISBLANK
ISEVEN
ISLOGICAL
ISNULL
ISNUMBER
ISODD
ISTEXT
Mathematical Functions
ABS
CEILING
EXP
FLOOR
LOG
MAX
MIN
MODULUS
POWER
PI
QUOTIENT
ROUND
SQRT
TRUNC
Session, Cookie, URL and Other Functions
CACHE
COOKIE
DECRYPT
ENCRYPT
DECRYPTDATA
ENCRYPTDATA
RESOURCE
ROLES
SESSION
URL
USERID
USERNAME
USERRECORD
Record Control-Level Functions
RANK
ROWNUM
RUNNINGTOTAL
String Functions
CAPITALIZE
CHARACTER
CONCATENATE
EXACT
FIND
LEFT
LEN
LOWER
MID
REPLACE
REPT
RIGHT
SUBSTRING
TRIM
UPPER
Table Control-Level Functions
AVERAGE
COUNT
COUNTA
MEAN
MEDIAN
MODE
RANGE
SUM
TOTAL