Kuovonne's Guide to Airtable

Explore

Kuovonne's Guide to Airtable

Formatting Formulas

Basic Rules
Basic Rules

⁠

⁠ Tip Jar ⁠ Thank Kuovonne for creating this content! ⁠ ⁠ ⁠

⁠

Grammar Rules

Spacing and punctuation

No space between a function name and its opening parenthesis.

Use a comma between parameters in a function.

Do not use a trailing comma after the last parameter in a function.

White space (spaces and new lines) between parameter values is neither required nor limited.

White space (spaces and new lines) between the parenthesis of a function and its parameters is neither required nor limited.

Quotes

Enclose hardcoded text in straight quotes (' or " ), not curly quotes ( ‘ ’ or “ ” ).

Emoji are text and need to be encased in quotes.

Do not put quotes around numbers that you want treated as numbers.

Alternate the quote style: "I've got a single quote" or 'She said, "Hi!"'

Use curly quotes in the hardcoded text instead of straight quotes. You may need to copy/paste in the curly quotes, as the editor will straighten any quotes that are typed directly.

Use \ to escape the quote: 'I\'ve got a single quote' or "She said, \"Hi!\""

Stylistic Guidelines

Writing field names:

Always use curly braces around field names, even when field names do not need curly braces

Deciding when to use a multi-line format

If a line would wrap after you have comfortably expanded the editor, you need a multi-line function.

If a parameter is a function that takes its own parameters, use a multi-line format for all parameters.

Basic rules for writing multi-line functions

Function name and opening parenthesis on line by itself.

One parameter per line with a comma at the end (except after the last parameter)

Indent parameters indented from opening function

Use the same indent level for all parameters of the same function

When nesting functions as parameters, nest the indent

Closing parenthesis on line by itself, at same indent level as function name.

Exception: Functions that no Parameter:

When using a function that takes no parameters, treat the function the same as you would a single field when deciding if you should use a multi-line syntax. This lets you use a single-line format in some cases.

"https://example.com/" & RECORD_ID()

Exception: Functions that take a Single Parameter:

When nesting a function inside a function that takes a single parameter, such as TRIM() or VALUE(), you may combine the two functions on a single line and stack the closing parenthesis on the same ending line.

TRIM(CONCATENATE(

{field 1} & "\n",

{field 2} & "\n",

{field 3} & "\n"

))

⁠

⁠ ⁠ Thank Kuovonne for creating this content! ⁠ Give Kuovonne a sandwich ⁠ Signup for Coda w/ referral link ⁠ ⁠ ⁠Buy from my Gumroad Store ⁠ ⁠ ⁠ ⁠ ⁠

⁠

Gallery

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.