Group 65
Go to AppSheet
All Collections
Expressions
Expressions
How to use expressions to change the behavior of your apps.
+3
150 articles in this collection
Written by
Santiago Uribe Montoya,
Tony Fader,
Praveen Seshadri (CEO AppSheet)
and 3 others
Expressions: The Essentials
Learn how expressions can be used in AppSheet and get started with your own.
Written by
Santiago Uribe Montoya
Updated over a week ago
Expression Assistant
Tool to help construct and test expressions.
Written by
Steve Coile
Updated over a week ago
Expression Types
Column Value Expressions
Write an expression to get a value from a specific column and row.
Written by
Steve Coile
Updated over a week ago
Conditional Expressions
How to use expressions so that behavior depends on a set of conditions.
Written by
Santiago Uribe Montoya
Updated over a week ago
Date and Time Expressions
Incorporate dates and times into the behavior of your app.
Written by
Steve Coile
Updated over a week ago
Dereference Expressions
Use a dereference expression to get a column value from the referenced row.
Written by
Steve Coile
Updated over a week ago
Math Expressions
Calculate numeric values from other numeric values.
Written by
Steve Coile
Updated over a week ago
List Expressions
List expressions use and/or produce lists of values.
Written by
Steve Coile
Updated over a week ago
Text Expressions
Text expressions use and/or produce textual values.
Written by
Steve Coile
Updated over a week ago
Yes/No Expressions
Write expressions where the result is either TRUE or FALSE.
Written by
Santiago Uribe Montoya
Updated over a week ago
Other Expressions
Expressions to modify text, create unique IDs, and work with location.
Written by
Steve Coile
Updated over a week ago
Backward Compatibility Expressions
Learn about obsolete expressions and what we still support.
Written by
Steve Coile
Updated over a week ago
Using Expressions
Column Constraints
Control inputs using column constraints.
Written by
Santiago Uribe Montoya
Updated over a week ago
Valid_If Column Constraint
How to check if a given form input is valid based on its type.
Written by
Santiago Uribe Montoya
Updated over a week ago
Required_If Column Constraint
Conditionally require a column value.
Written by
Steve Coile
Updated over a week ago
Suggested Values for a Column
How to suggest a dynamic list of values for a column
Written by
Praveen Seshadri (CEO AppSheet)
Updated over a week ago
Show_If Column Constraint
Conditionally show or hide a column value.
Written by
Santiago Uribe Montoya
Updated over a week ago
Editable_If Column Constraint
Conditionally allow the user to edit a column value.
Written by
Steve Coile
Updated over a week ago
Using Lists
List Addition
Add lists together to produce another containing all items in the originals.
Written by
Steve Coile
Updated over a week ago
List Dereference
Dereference the items of a list in bulk to produce a list of the resulting values.
Written by
Steve Coile
Updated over a week ago
List from Expressions
Create a list from the results of expressions.
Written by
Steve Coile
Updated over a week ago
List from Table-Column Reference
Create a list from the values in a column of a table.
Written by
Steve Coile
Updated over a week ago
List from Values
Create a list from raw values.
Written by
Steve Coile
Updated over a week ago
List Functions
Create lists using functions.
Written by
Steve Coile
Updated over a week ago
List Subtraction
Subtract lists to produce another containing only the unique items of the first list that aren't also in the second.
Written by
Steve Coile
Updated over a week ago
Functions
ABS()
Arithmetic absolute value
Written by
Steve Coile
Updated over a week ago
AND()
Are all true?
Written by
Steve Coile
Updated over a week ago
ANY()
One arbitrary list item
Written by
Steve Coile
Updated over a week ago
APP()
Written by
Steve Coile
Updated over a week ago
AVERAGE()
Arithmetic average of list items
Written by
Steve Coile
Updated over a week ago
CEILING()
Nearest higher integer
Written by
Steve Coile
Updated over a week ago
CONCATENATE()
Merged text from parts
Written by
Steve Coile
Updated over a week ago
CONTAINS()
Does text contain fragment?
Written by
Steve Coile
Updated over a week ago
CONTEXT()
Information about the running app.
Written by
Steve Coile
Updated over a week ago
COUNT()
Number of list items
Written by
Steve Coile
Updated over a week ago
DATE()
Date from Date, DateTime, or Time
Written by
Steve Coile
Updated over a week ago
DATETIME()
DateTime from Date, DateTime, or Time
Written by
Steve Coile
Updated over a week ago
DAY()
Day of month from Date, DateTime, or Time
Written by
Steve Coile
Updated over a week ago
DECIMAL()
Decimal from any value
Written by
Steve Coile
Updated over a week ago
DISTANCE()
Distance between locations
Written by
Steve Coile
Updated over a week ago
ENDSWITH()
Does text end with fragment?
Written by
Steve Coile
Updated over a week ago
EOMONTH()
Date of last day of a month from Date or DateTime
Written by
Steve Coile
Updated over a week ago
EOWEEK()
Date of last day of a week from Date or DateTime
Written by
Steve Coile
Updated over a week ago
EWOMONTH()
Date of last weekday of a month from Date or DateTime
Written by
Steve Coile
Updated over a week ago
ENCODEURL()
Text encoded for use in URL
Written by
Steve Coile
Updated over a week ago
EXTRACT()
Extract values from text.
Written by
Steve Coile
Updated over a week ago
EXTRACTCHOICE()
Extract one Yes/No value within textual value
Written by
Steve Coile
Updated over a week ago
EXTRACTDATES()
Extract list of dates within textual value
Written by
Steve Coile
Updated over a week ago
EXTRACTDATETIMES()
Extract list of DateTime values within textual value
Written by
Steve Coile
Updated over a week ago
EXTRACTDOMAINS()
Written by
Steve Coile
Updated over a week ago
EXTRACTDURATIONS()
Extract list of Duration values within textual value
Written by
Steve Coile
Updated over a week ago
EXTRACTEMAILS()
Extract list of Email values within textual value
Written by
Steve Coile
Updated over a week ago
EXTRACTHASHTAGS()
Extract list of hashtags within textual value
Written by
Steve Coile
Updated over a week ago
EXTRACTMENTIONS()
Extract list of mentions within textual value
Written by
Steve Coile
Updated over a week ago
EXTRACTNUMBERS()
Extract list of numeric values within text value
Written by
Jennifer Cadence
Updated over a week ago
EXTRACTPHONENUMBERS()
Extract list of phone numbers within text value
Written by
Jennifer Cadence
Updated over a week ago
EXTRACTPRICES()
Extract list of Price values within text value
Written by
Jennifer Cadence
Updated over a week ago
EXTRACTTIMES()
Extract list of Time values within text value
Written by
Jennifer Cadence
Updated over a week ago
FILTER()
Select rows of table or slice
Written by
Steve Coile
Updated over a week ago
FIND()
Position of fragment in text
Written by
Steve Coile
Updated over a week ago
FLOOR()
Nearest lower integer
Written by
Steve Coile
Updated over a week ago
GCAL_MEETINGS_AT()
Written by
Steve Coile
Updated over a week ago
GCAL_MEETINGS_FROM()
Written by
Steve Coile
Updated over a week ago
GCAL_MEETINGS_WITH()
Written by
Steve Coile
Updated over a week ago
GETX()
Written by
Steve Coile
Updated over a week ago
GETY()
Written by
Steve Coile
Updated over a week ago
HERE()
Current location
Written by
Steve Coile
Updated over a week ago
HYPERLINK()
New hyperlink
Written by
Steve Coile
Updated over a week ago
HOUR()
Hour of day from Duration
Written by
Steve Coile
Updated over a week ago
IF()
Either/or conditional evaluation
Written by
Steve Coile
Updated over a week ago
IFS()
First-match conditional evaluation
Written by
Steve Coile
Updated over a week ago
IN()
Is item in list?
Written by
Steve Coile
Updated over a week ago
INDEX()
One specific list item
Written by
Steve Coile
Updated over a week ago
INITIALS()
First character of each word
Written by
Steve Coile
Updated over a week ago
ISBLANK()
Is value absent?
Written by
Steve Coile
Updated over a week ago
ISNOTBLANK()
Is value present?
Written by
Steve Coile
Updated over a week ago
INTERSECT()
Items common to two lists
Written by
Steve Coile
Updated over a week ago
LATLONG()
LatLong from components
Written by
Steve Coile
Updated over a week ago
LAT()
Latitude component of location
Written by
Steve Coile
Updated over a week ago
LEFT()
Left-most characters of text
Written by
Steve Coile
Updated over a week ago
LINKTEXT()
Text component of hyperlink
Written by
Steve Coile
Updated over a week ago
LINKTOAPP()
Constructed deep link to app
Written by
Steve Coile
Updated over a week ago
LINKTOFILTEREDVIEW()
Constructed deep link to filtered view
Written by
Steve Coile
Updated over a week ago
LINKTOFORM()
Constructed deep link to form
Written by
Steve Coile
Updated over a week ago
LINKTOROW()
Constructed deep link to row
Written by
Steve Coile
Updated over a week ago
LINKTOVIEW()
Constructed deep link to view
Written by
Steve Coile
Updated over a week ago
LINKURL()
URL component of hyperlink
Written by
Steve Coile
Updated over a week ago
LEN()
Number of characters in textual value
Written by
Steve Coile
Updated over a week ago
LIST()
New list
Written by
Steve Coile
Updated over a week ago
LN()
Natural logarithm of a numeric value
Written by
Steve Coile
Updated over a week ago
LOG()
Logarithm of a numeric value
Written by
Steve Coile
Updated over a week ago
LOG2()
Base 2 logarithm of a numeric value
Written by
Steve Coile
Updated over a week ago
LOG10()
Base 10 logarithm of a numeric value
Written by
Steve Coile
Updated over a week ago
LONG()
Longitude component of location
Written by
Steve Coile
Updated over a week ago
LOOKUP()
Get column value from row in table or slice
Written by
Steve Coile
Updated over a week ago
LOWER()
Convert text to lowercase.
Written by
Steve Coile
Updated over a week ago
MAX()
Highest item in list
Written by
Steve Coile
Updated over a week ago
MAXROW()
Row with greatest value in column
Written by
Steve Coile
Updated over a week ago
MID()
Characters from text
Written by
Steve Coile
Updated over a week ago
MIN()
Lowest item in list
Written by
Steve Coile
Updated over a week ago
MINROW()
Row with lowest value in column
Written by
Steve Coile
Updated over a week ago
MINUTE()
Minute of hour from Duration
Written by
Steve Coile
Updated over a week ago
MOD()
Arithmetic remainder from integer division
Written by
Steve Coile
Updated over a week ago
MONTH()
Month of year from Date, DateTime, or Time
Written by
Steve Coile
Updated over a week ago
NOT()
Is it false?
Written by
Steve Coile
Updated over a week ago
NOW()
Current date & time
Written by
Steve Coile
Updated over a week ago
NUMBER()
Number from any value
Written by
Steve Coile
Updated over a week ago
OCRTEXT()
Extract all text from an image
Written by
Tony Fader
Updated over a week ago
OR()
Are any true?
Written by
Steve Coile
Updated over a week ago
ORDERBY()
Sort row references
Written by
Steve Coile
Updated over a week ago
POWER()
Arithmetic exponentiation
Written by
Steve Coile
Updated over a week ago
RANDBETWEEN()
Random integer from range
Written by
Steve Coile
Updated over a week ago
REF_ROWS()
Gather related rows from table or slice
Written by
Steve Coile
Updated over a week ago
RIGHT()
Rightmost characters of text
Written by
Steve Coile
Updated over a week ago
ROUND()
Nearest integer
Written by
Steve Coile
Updated over a week ago
SECOND()
Second of minute from Duration
Written by
Steve Coile
Updated over a week ago
SELECT()
Gather column values from row in table or slice
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
Written by
Steve Coile
Updated over a week ago
SORT()
Sorted list items
Written by
Steve Coile
Updated over a week ago
SQRT()
Arithmetic square root
Written by
Steve Coile
Updated over a week ago
STARTSWITH()
Does text begin with fragment?
Written by
Steve Coile
Updated over a week ago
STDEVP()
Arithmetic standard deviation of list items
Written by
Steve Coile
Updated over a week ago
SUBSTITUTE()
Text with replacements
Written by
Steve Coile
Updated over a week ago
SUM()
Arithmetic sum of list items
Written by
Steve Coile
Updated over a week ago
SWITCH()
Chose-one conditional evaluation
Written by
Steve Coile
Updated over a week ago
TEXT()
Format as text
Written by
Steve Coile
Updated over a week ago
TEXT_ICON()
Icon from text
Written by
Steve Coile
Updated yesterday
TIME()
Time from Date, DateTime, or Time
Written by
Steve Coile
Updated over a week ago
TIMENOW()
Current time
Written by
Steve Coile
Updated over a week ago
TODAY()
Current date
Written by
Steve Coile
Updated over a week ago
TOTALHOURS()
Count of hours in Duration
Written by
Steve Coile
Updated over a week ago
TOP()
Initial list items
Written by
Steve Coile
Updated over a week ago
TOTALMINUTES()
Count of minutes in Duration
Written by
Steve Coile
Updated over a week ago
TOTALSECONDS()
Count of seconds in Duration
Written by
Steve Coile
Updated over a week ago
TRIM()
Text with extraneous spaces removed
Written by
Steve Coile
Updated over a week ago
UNIQUE()
Unique items in list
Written by
Steve Coile
Updated over a week ago
UNIQUEID()
Pseudo-unique ID
Written by
Steve Coile
Updated over a week ago
UPPER()
Convert text to uppercase.
Written by
Steve Coile
Updated over a week ago
USERNAME()
User's name
Written by
Steve Coile
Updated over a week ago
USEREMAIL()
User's email address
Written by
Steve Coile
Updated over a week ago
USERLOCALE()
User's locale
Written by
Steve Coile
Updated over a week ago
USERROLE()
Get assigned role of approved user
Written by
Steve Coile
Updated over a week ago
UTCNOW()
Current date & time in UTC
Written by
Steve Coile
Updated over a week ago
USERSETTINGS()
Specified user setting value
Written by
Steve Coile
Updated over a week ago
WEEKDAY()
Day of week from Date or DateTime
Written by
Steve Coile
Updated over a week ago
WEEKNUM()
Week of year from Date or DateTime
Written by
Steve Coile
Updated over a week ago
WORKDAY()
Computed date excluding non-work days
Written by
Steve Coile
Updated over a week ago
XY()
Written by
Steve Coile
Updated over a week ago
YEAR()
Year from Date, DateTime, or Time
Written by
Steve Coile
Updated over a week ago