Kuovonne's Guide to Airtable
Share
Explore
Kuovonne's Guide to Airtable
Specific Formulas

Comma Separated List of Fields Values with Optional Fields

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

Inspiration

You want to combine text from multiple fields into a comma separated list. But some fields are optional, and you do not want any extra commas.

Discussion

You can combine text from multiple fields into a comma separated list, without extra commas when optional fields are empty.
⁠
image.png
⁠
⁠
REGEX_REPLACE(
CONCATENATE(
IF({City}, {City} & ", "),
IF({State}, {State} & ", "),
IF({Country}, {Country})
),
", $",
""
)


⁠
⁠
⁠
Thank Kuovonne for creating this content!
⁠
Give Kuovonne a sandwich
⁠
Signup for Coda w/ referral link
⁠
⁠
⁠
Buy from my Gumroad Store
⁠
⁠
⁠
⁠
⁠
⁠
⁠
Gallery
Share
 
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.