Other expressions

Expressions may be used in various AppSheet features - app formulas, column constraints (Valid_If, Show_If, Required_If) - to customize app behavior and provide advanced functionality.

The expressions described here cover a range of needs and don't fit into any of the other expression types.

New to expressions and formulas? See also Expressions: The Essentials.

Functions

Conditional

• IF() - Either/or conditional evaluation
• IFS() - First-match conditional evaluation
• SWITCH() - Choose-one conditional evaluation

Hyperlinks & URLs

• HYPERLINK() - New hyperlink
• LINKTEXT() - text component of hyperlink

• LINKURL() - URL component of hyperlink

Informational

• CONTEXT() - Information about the running app
• USEREMAIL() - User's email address
• USERLOCALE() - User's locale
• USERNAME() - User's name
• USERROLE() - Assigned role of approved user
• USERSETTINGS() - Specified user-setting value

LatLong & XY

• DISTANCE() - Distance between two locations
• GETX() - X component of XY value
• GETY()- Y component of XY value
• HERE() - Current location
• LAT() - Latitude component of LatLong value
• LATLONG() - LatLong from components
• LONG() - Longitude component of LatLong value

Utility

• TEXT_ICON() - Icon from text
• UNIQUEID() - Pseudo-unique ID