Arrayjoin separator doesn't apply on linked records

[Thierry_Gattlen]

Hello to the AT community,

I need to list some related records with arrayjoin(linked field,"\n") in a formula field.
Unfortunately, this is not working on linked records as it is on lookup records. (See picture below).

I would d like to avoid creating 28+ additional lookup fields in the table (this is a person table linked with 28 project tasks table) to get the proper list with carriage return.

I will use this in automatic SendGrid mail blocks.

Does anyone knows how to arrajoin linked records instead of lookup records.

Thanks a lot.

Thierry

[DanielAssayag]

ive been using airtable for a while now and i start to see how limited it is.

[Mike_Laufer]

Hello Theirry,
I don’t know if you ever resolved this or if AT updated behind the scenes, but this formula is what works for me in both lookup and linked fields:
SUBSTITUTE(ARRAYJOIN({Linked_or_Lookup_Field)}),", ","\n")
Trying to put the “\n” inside the ARRAYJOIN function only works on rollup fields.
If you have a ", " already inside your {field}, then unfortunately, the substitute will also change that to a new line, too.