Text functions

This article covers how to use REGEX() to streamline your team's and organization's work. REGEX() in Airtable overview REGEX() overview NOTE Note that our REGEX functions only work with text strings. If you are using either a roll...

Using CONCATENATE() in Airtable  The CONCATENATE() function joins together arguments and/or field values from any number of fields into a single text value, and follows this format: CONCATENATE(Value 1, Value 2, etc...) For example, yo...

This content covers a few ways to change the look of the text string using the LOWER , UPPER , and TRIM functions. LOWER() and UPPER() The LOWER() function takes a text string and makes all the characters lowercase, while the UPPER() ...

This article covers how to extract specified values from fields to streamline your team's and organization's work. Using LEN() in Airtable Using LEN() This is a very straightforward function that simply returns the length of a string. Yo...

This article covers how to find, search for, and replace text within a string to streamline your team's and organization's work. Using FIND() and SEARCH() in Airtable Using FIND() and SEARCH() The FIND and SEARCH functions loc...

Converting numbers to text strings in Airtable If you append &"" to a formula working with numbers, then it will convert that value to a string in Airtable. Additionally, the & operator is equivalent to the CONCATENATE() function. ...