Combining field values in Airtable

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, you can join together the values of two fields by using this formula:

• Example formula: CONCATENATE({Field A}, " - ", {Field B})

• Result:
  

Notice the addition of " - " as a separator between the fields.

You can use concatenate to join together any number of fields and text. One of the most common uses of this function is to make the primary field in a table a unique identifier by combing several values together.

Let’s use a hiring process as an example workflow for using this same type of formula. In this case, you would create a formula in the primary field to see the candidate name and the stage of the process they're in.

This could assist someone managing the process to quickly view upcoming interviews in a calendar.

Note

Blank fields are silently ignored. If a field included in a CONCATENATE() or & expression is empty, it simply contributes nothing to the result — no error, no placeholder text. This means you can safely concatenate optional fields without needing to check for blanks first, though you may want to handle separators carefully if an optional field could be missing.

CONCATENATE() alternatives in Airtable

As an equivalent to CONCATENATE(), using an ampersand (&) as a separating character between values is a more simple approach to combining values.

Using the same example as the previous section, you could re-write the formula as {Candidate} & " - " & {Type}

When working with either function, remember that you may be combining different types of data - for example, a numeric value, a date string, and plain text - into a single field. See the result when we mix in a date field into the concatenated primary field using this formula: {Date} & ": " & {Candidate} & " - " & {Type}

You'll need to adjust this with the DATETIME_FORMAT function to be more human readable using a formula like this: DATETIME_FORMAT({Date},'L') & ": " & {Candidate} & " - " & {Type}

Note that when combining field types, it won't be possible to format that field type as a numeric value or a formatted date.

Note

If you concatenate a checkbox field or a formula that returns a true/false value, it will display as the literal text "TRUE" or "FALSE". To control how it appears, wrap the field in an IF statement first — for example: IF({Approved}, "Approved", "Pending")

Line breaks in Airtable

When working with formulas - especially when combining several fields of information - it can often be helpful to program in line breaks and other formatting features to better display the result of a formula. By using "\n" in a formula, you can program in line breaks as needed. For example, you may want to combine the fields shown below to produce a paragraph of text for a job description.

• Example formula: {Role / Title} & " " & {Department} & " " & {Experience Required} & " " & {Description}

• Example base setup:
  

For a more readable job description field, we can adjust the formula to use "\n" to insert line breaks in the right places.

• Example formula: {Role} & "\n" & {Department} & "\n" & {Experience Required} & "\n \n" & {Description}

• Result:
  
  

With the added line breaks, the job description becomes easier to read, and to copy and paste into other places like an online job board. To go one step further, you can even add custom text to the job description to add more context.

• Example formula: "Job Title: " & {Role} & "\n" & "Department: " & {Department} & "\n" & "Number of years experience required: " & {Experience Required} & "\n \n" & "Job Description: " & "\n" & {Description}

• Result:
  

Joining values with ARRAYJOIN() in rollup fields

The ARRAYJOIN() function is used in the aggregation formula of a rollup field to combine values from a linked field across multiple records into a single string. It takes two arguments: the array of values (values) and a separator string. For example:

• To list all linked project names separated by a comma and space:
  ARRAYJOIN(values, ", ")

• To display each value on its own line:
  ARRAYJOIN(values, "\n")

If the linked field can be empty, blank entries will appear as gaps in the output. Use ARRAYCOMPACT() to strip them out first:

ARRAYJOIN(ARRAYCOMPACT(values), ", ")

Note that ARRAYJOIN() is only available as an aggregation formula inside rollup fields — it cannot be used in a standalone formula field.