Offline Supported Operators and Functions in Field with the Formula Type

Math Operators

Operator iOS Windows

+ (Add)

Yes

Yes

Field types

  • Number + Number

  • Date + Number

  • Date/Time+ Number

  • Time + Number

  • String + String

- (Subtract)

Yes

Yes

Field types since CT Mobile Windows 1.1

  • NUMBER - NUMBER

  • DATE - NUMBER

  • DATETIME - NUMBER

  • DATETIME - DATETIME

Field types since CT Mobile Windows 1.2

  • TIME - NUMBER

  • DATE - DATE

* (Multiply)

Yes

Yes

Field types

  • Number* Number

/ (Divide)

Yes

Yes

Field types

  • Number / Number

^ (Exponentiation)

Yes

() (Open Parenthesis and Close Parenthesis)

Yes

Yes

Logical Operators

Operator iOS Windows

= and == (Equal)

Yes

Yes

<> and != (Not Equal)

Yes

Yes

< (Less Than)

Yes

Yes

> (Greater Than)

Yes

Yes

⇐ (Less Than or Equal)

Yes

Yes

>= (Greater Than or Equal)

Yes

Yes

&& (AND)

Yes

Yes

|| (OR)

Yes

Yes

Text Operators

Operator iOS Windows

& (Concatenate)

Yes

Yes

Date and Time Functions

Function iOS Windows

ADDMONTHS

No

DATE

Yes

Yes

DATEVALUE

Yes

Yes

DATETIMEVALUE

Yes

Yes

DAY

Yes

Yes

HOUR

Yes

MILLISECOND

Yes

MINUTE

Yes

MONTH

Yes

Yes

NOW

Yes

Yes

SECOND

Yes

TIMENOW

No

TIMEVALUE

Yes

TODAY

Yes

Yes

WEEKDAY

Yes

Since CT Mobile 2.7

Yes

YEAR

Yes

Yes

Logical Functions

Function iOS Windows

AND

Yes

Yes

BLANKVALUE

Yes

Yes

CASE

Yes

Yes

IF

Yes

Yes

ISBLANK

Yes

Yes

ISCLONE

No

ISNEW

Synced records: returns True.

Unsynced records: returns False.

ISNULL

Yes

Yes

ISNUMBER

Yes

Yes

NOT

Yes

Yes

NULLVALUE

Yes

Yes

OR

Yes

Yes

PRIORVALUE

  • Synced records: returns the value after the last successful synchronization.

  • Unsynced records: returns the current value.

  • Trigger: after tapping a field, even if the value will not be changed.

Yes

Math Functions

Function iOS Windows

ABS

Yes

CEILING

Yes

Yes

DISTANCE

Yes

Yes

EXP

Yes

FLOOR

Yes

GEOLOCATION

Yes (since CT Mobile 2.7.)

Yes

LN

Yes

LOG

Yes

MAX

Yes

MCEILING

No

No

MFLOOR

No

MIN

Yes

MOD

Yes

ROUND

Yes

Yes

SQRT

Yes

Text Functions

Function iOS Windows

BEGINS

Yes

Yes

BR

Yes

Yes

CASESAFEID

Yes

Yes

CONTAINS

Yes

Yes

FIND

Yes

Yes

GETSESSIONID

Blank value.

HTMLENCODE

Yes

HYPERLINK

Yes (since CT Mobile 2.7.)

Yes

IMAGE

Yes

Yes

INCLUDES

Yes

Yes

ISPICKVAL

Yes

Yes

JSENCODE

Yes

JSINHTMLENCODE

Yes

LEFT

Yes

Yes

LEN

Yes

Yes

LOWER

Yes

Yes

LPAD

Yes

MID

Yes

Yes

RIGHT

Yes

Yes

RPAD

Yes

SUBSTITUTE

Yes

Yes

TEXT

Yes

Yes

TRIM

Yes

UPPER

Yes

Yes

URLENCODE

Yes

VALUE

Yes

Yes

Summary Functions

Function iOS Windows

PARENTGROUPVAL

No

PREVGROUPVAL

No

Advanced Functions

Function iOS Windows

CURRENCYRATE

No

GETRECORDIDS

No

IMAGEPROXYURL

No

INCLUDE

No

ISCHANGED

Unsynced records: returns False.

Yes

JUNCTIONIDLIST

No

LINKTO

No

REGEX

No

REQUIRESCRIPT

No

URLFOR

No

VLOOKUP

No

Global Constants

Function iOS Windows Comments

$Api

No

$CustomMetadata

Yes

Records of custom metadata types.

$Label

Yes

$Organization

No

Yes

Owner: Queue

Yes

Owner: User

Yes

$Profile

Yes

Yes

$recordtype

Yes

$Setup

Yes

Yes

Records of custom settings.

$System

No

$User

Yes

Yes

$UserRole

Yes

Yes
``