Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Arrayjoin separator doesn't apply on linked records

Topic Labels: Formulas
2113 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Thierry_Gattlen
6 - Interface Innovator
6 - Interface Innovator

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).Capture d’écran 2020-05-06 à 10.44.21

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

2 Replies 2
DanielAssayag
6 - Interface Innovator
6 - Interface Innovator

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

Mike_Laufer
5 - Automation Enthusiast
5 - Automation Enthusiast

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.