How Do You Concatenate in Airtable

Concatenate text values into a single text value. To concatenate static text, surround it with double quotation marks. To concatenate double quotation marks, you need to use a backslash (\) as an escape character. Equivalent to CONCATENATE().

Can you sum in Airtable?

Airtable can calculate sums in the summary bar, but it cannot include summary bar information in formula fields. New records added using a form are automatically included in summary bar calculations. … (Although you can’t use those summary values in formula fields, which would be nice.)

How do I link two columns in Airtable?

Once you’re ready, go to the field customization menu and select the Customize field type option. Then choose Link to another record, and select the table you’d like to link records from. In our case, we want to pick the Albums table. Once you’ve selected the Albums table, click the Save button.