EXPRESSIONS

How to use expressions to change the behavior of your apps.

Santiago Uribe Montoya avatar Tony Fader avatar Praveen Seshadri avatar +4
153 articles in this collection
Written by Santiago Uribe Montoya, Tony Fader, Praveen Seshadri and 4 others
Functions

ABS()

Arithmetic absolute value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

AND()

Are all true?
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

ANY()

One arbitrary list item
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

APP()

Steve Coile avatar
Written by Steve Coile
Updated over a week ago

AVERAGE()

Arithmetic average of list items
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

CEILING()

Nearest higher integer
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

CONCATENATE()

Merged text from parts
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

CONTAINS()

Does text contain fragment?
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

CONTEXT()

Information about the running app.
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

COUNT()

Number of list items
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

DATE()

Date from Date, DateTime, or Time
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

DATETIME()

DateTime from Date, DateTime, or Time
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

DAY()

Day of month from Date, DateTime, or Time
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

DECIMAL()

Decimal from any value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

DISTANCE()

Distance between locations
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

ENCODEURL()

Encode text for use in URL
Steve Coile avatar
Written by Steve Coile
Updated this week

ENDSWITH()

Does text end with fragment?
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EOMONTH()

Date of last day of a month from Date or DateTime
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EOWEEK()

Date of last day of a week from Date or DateTime
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EWOMONTH()

Date of last weekday of a month from Date or DateTime
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EXTRACT()

Extract values from text.
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EXTRACTCHOICE()

Extract one Yes/No value within textual value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EXTRACTDATES()

Extract list of dates within textual value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EXTRACTDATETIMES()

Extract list of DateTime values within textual value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EXTRACTDOMAINS()

Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EXTRACTDURATIONS()

Extract list of Duration values within textual value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EXTRACTEMAILS()

Extract list of Email values within textual value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EXTRACTHASHTAGS()

Extract list of hashtags within textual value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EXTRACTMENTIONS()

Extract list of mentions within textual value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

EXTRACTNUMBERS()

Extract list of numeric values within text value
Jennifer Cadence avatar
Written by Jennifer Cadence
Updated over a week ago

EXTRACTPHONENUMBERS()

Extract list of phone numbers within text value
Jennifer Cadence avatar
Written by Jennifer Cadence
Updated over a week ago

EXTRACTPRICES()

Extract list of Price values within text value
Jennifer Cadence avatar
Written by Jennifer Cadence
Updated over a week ago

EXTRACTTIMES()

Extract list of Time values within text value
Jennifer Cadence avatar
Written by Jennifer Cadence
Updated over a week ago

FILTER()

Select rows of table or slice
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

FIND()

Position of fragment in text
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

FLOOR()

Nearest lower integer
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

GCAL_MEETINGS_AT()

Steve Coile avatar
Written by Steve Coile
Updated over a week ago

GCAL_MEETINGS_FROM()

Steve Coile avatar
Written by Steve Coile
Updated over a week ago

GCAL_MEETINGS_WITH()

Steve Coile avatar
Written by Steve Coile
Updated over a week ago

GETX()

Steve Coile avatar
Written by Steve Coile
Updated over a week ago

GETY()

Steve Coile avatar
Written by Steve Coile
Updated over a week ago

HERE()

Current location
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

HYPERLINK()

New hyperlink
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

HOUR()

Hour of day from Duration
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

IF()

Either/or conditional evaluation
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

IFS()

First-match conditional evaluation
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

IN()

Is item in list?
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

INDEX()

One specific list item
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

INITIALS()

First character of each word
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

INPUT()

Specify a dynamic input that is assigned by the user or an action
Praveen Seshadri avatar
Written by Praveen Seshadri
Updated over a week ago

INTERSECT()

Items common to two lists
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

ISBLANK()

Is value absent?
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

ISNOTBLANK()

Is value present?
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

ISOWEEKNUM()

Number of the ISO week of the year for the specified date
Steve Coile avatar
Written by Steve Coile
Updated this week

LAT()

Latitude component of location
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LATLONG()

LatLong from components
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LEFT()

Left-most characters of text
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LEN()

Number of characters in textual value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LINKTEXT()

Text component of hyperlink
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LINKTOAPP()

Constructed deep link to app
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LINKTOFILTEREDVIEW()

Constructed deep link to filtered view
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LINKTOFORM()

Constructed deep link to form
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LINKTOPARENTVIEW()

Constructs a deep link to parent view.
L
Written by Liz Lynch
Updated over a week ago

LINKTOROW()

Constructed deep link to row
Steve Coile avatar
Written by Steve Coile
Updated this week

LINKTOVIEW()

Constructed deep link to view
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LINKURL()

URL component of hyperlink
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LIST()

New list
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LN()

Natural logarithm of a numeric value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LOG()

Logarithm of a numeric value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LOG2()

Base 2 logarithm of a numeric value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LOG10()

Base 10 logarithm of a numeric value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LONG()

Longitude component of location
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LOOKUP()

Get column value from row in table or slice
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

LOWER()

Convert text to lowercase.
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

MAX()

Highest item in list
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

MAXROW()

Row with greatest value in column
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

MID()

Characters from text
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

MIN()

Lowest item in list
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

MINROW()

Row with lowest value in column
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

MINUTE()

Minute of hour from Duration
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

MOD()

Arithmetic remainder from integer division
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

MONTH()

Month of year from Date, DateTime, or Time
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

NOT()

Is it false?
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

NOW()

Current date & time
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

NUMBER()

Number from any value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

OCRTEXT()

Extract all text from an image
Tony Fader avatar
Written by Tony Fader
Updated over a week ago

OR()

Are any true?
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

ORDERBY()

Sort row references
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

POWER()

Arithmetic exponentiation
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

RANDBETWEEN()

Random integer from range
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

REF_ROWS()

Gather related rows from table or slice
Steve Coile avatar
Written by Steve Coile
Updated this week

RIGHT()

Rightmost characters of text
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

ROUND()

Nearest integer
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

SECOND()

Second of minute from Duration
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

SELECT()

Gather column values from row in table or slice
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

SNAPSHOT()

Screenshot a view and embed in documents.
J
Written by Joshua Aldrich
Updated over a week ago

SPLIT()

List from text
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

SORT()

Sorted list items
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

SQRT()

Arithmetic square root
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

STARTSWITH()

Does text begin with fragment?
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

STDEVP()

Arithmetic standard deviation of list items
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

SUBSTITUTE()

Text with replacements
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

SUM()

Arithmetic sum of list items
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

SWITCH()

Chose-one conditional evaluation
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

TEXT()

Format as text
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

TEXT_ICON()

Icon from text
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

TIME()

Time from Date, DateTime, or Time
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

TIMENOW()

Current time
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

TODAY()

Current date
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

TOTALHOURS()

Count of hours in Duration
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

TOP()

Initial list items
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

TOTALMINUTES()

Count of minutes in Duration
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

TOTALSECONDS()

Count of seconds in Duration
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

TRIM()

Text with extraneous spaces removed
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

UNIQUE()

Unique items in list
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

UNIQUEID()

Pseudo-unique ID
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

UPPER()

Convert text to uppercase.
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

USEREMAIL()

User's email address
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

USERLOCALE()

User's locale
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

USERNAME()

User's name
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

USERROLE()

Get assigned role of approved user
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

USERSETTINGS()

Specified user setting value
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

UTCNOW()

Current date & time in UTC
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

WEEKDAY()

Day of week from Date or DateTime
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

WEEKNUM()

Week of year from Date or DateTime
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

WORKDAY()

Computed date excluding non-work days
Steve Coile avatar
Written by Steve Coile
Updated over a week ago

XY()

Steve Coile avatar
Written by Steve Coile
Updated over a week ago

YEAR()

Year from Date, DateTime, or Time
Steve Coile avatar
Written by Steve Coile
Updated over a week ago