Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How do you create a comma separated list from linked fields?

Topic Labels: Formulas
Solved
Jump to Solution
580 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I want to list each linked entry in the “facts copy” column as a separate bullet point in a bulleted list in another column.
Here is the table:
Screen Shot 2022-05-24 at 3.15.52 PM

Here is the formula I tried to use unsuccessfully:
REGEX_REPLACE(CONCATENATE({Facts copy}), “, “, “<br>⦁“)

I am not a programmer so apologies for my lack of knowledge.

1 Solution

Accepted Solutions

Instead, use a Rollup field using the “Facts copy” table’s name field. The following aggregation will make a list:

IF(values, "⦁" & ARRAYJOIN(values, "\n⦁"))

^ Array join will only put the bullet in front of each item after the first, which is why its necessary to add one at the start.

See Solution in Thread

1 Reply 1

Instead, use a Rollup field using the “Facts copy” table’s name field. The following aggregation will make a list:

IF(values, "⦁" & ARRAYJOIN(values, "\n⦁"))

^ Array join will only put the bullet in front of each item after the first, which is why its necessary to add one at the start.