Part IV: Formulas
Part IV: Formulas
Formulas
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
Customize Dropdown List Sort Order
Customize Table Control Sort Order
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
Mathematical Functions
ABS
CEILING
EXP
FLOOR
LOG
MAX
MIN
MODULUS
POWER
PI
QUOTIENT
ROUND
SQRT
TRUNC
Boolean Functions
AND1
NOT1
OR1
String Functions
CAPITALIZE
CHARACTER
CONCATENATE
EXACT
FIND
LEFT
LEN
LOWER
MID
REPLACE
REPT
RIGHT
SUBSTRING
TRIM
UPPER
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
Data Conversion Functions
PARSEDATE
PARSEDECIMAL
PARSEINTEGER
Information Functions
ISBLANK
ISEVEN
ISLOGICAL
ISNULL
ISNUMBER
ISODD
ISTEXT
Session, Cookie, URL and Other Functions
CACHE
COOKIE
DECRYPT
ENCRYPT
RESOURCE
ROLES
SESSION
URL
USERID
USERNAME
USERRECORD
Database Functions
GETCOLUMNVALUE
GETCOLUMNVALUES
LOOKUP
Operators
IF
Arithmetic operators (*, +, -, %, /, ^)
Boolean operators (AND, OR, XOR, NOT)
Comparison operators (=, <>, >, <, >=, <=)
String Operators (+)
Table Control-Level Functions
AVERAGE
COUNT
COUNTA
MEAN
MEDIAN
MODE
RANGE
SUM
TOTAL
Record Control-Level Functions
RANK
ROWNUM
RUNNINGTOTAL
GEOCODING Functions
CONFIGURING GEOCODING FUCNTIONALITY
CONFIGURING DEFAULT LOCATION
GETBROWSERLOCATION
CLEARBROWSERLOCATION
SETDEFAULTLOCATION
GOOGLEDIRECTIONS
GOOGLEINTERACTIVEMAP
GOOGLEMAP
GOOGLEMAPWITHDIRECTIONS
GOOGLEINTERACTIVEMAPURL
GOOGLEMAPURL
GOOGLEPOPUPMAPURL
DECIMALTODEGREES
DECIMALTOMINUTES
DECIMALTOSECONDS
DEGREESMINSECTODECIMAL
LOCATIONTOADDRESS
LOCATIONTOLATITUDE
LOCATIONTOLONGITUDE
LOCATIONTOOTHER
GETDISTANCEUNIT
SETDISTANCEUNIT
DISTANCEBETWEEN
ISWITHINRADIUS
BOUNDINGBOXEDGE