En estos momentos, la página que has solicitado no está disponible en tu idioma. Puedes seleccionar otro idioma en la parte inferior de la página o traducir cualquier página web de forma instantánea al idioma que elijas con la función integrada de traducción de Google Chrome.

Other expressions

Modify text, create unique IDs, and work with location

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

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

Contact us Tell us more and we’ll help you get there

Search

Clear search

Close search

Main menu