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