Skip to main content
Solved

Formula help for display options for a field with multiple linked records

  • April 16, 2025
  • 3 replies
  • 62 views

Forum|alt.badge.img+2

I’m exporting data to a pdf via Typeflow. One of the fields is a Link to multiple records, which happen to be street addresses.  When I export the data to a pdf, the default view is to separate each linked record by a comma.  I’m trying to create a line break instead of a comma.  

 

I created a formula field with SUBSTITUTE(Addresses,”,”,”\n), however the street addresses contain commas, so this didn’t work. 

Any ideas for another work around?   Huge thanks in advance. 

 

Current format:

Record 1, Record 2, Record 3

 

Desired format:

Record 1

Record 2

Record 3

etc

Best answer by ScottWorld

Instead of creating a formula field, create a rollup field (based on that linked record field), and point to the field that you’d like to see in your final results.

Then, for your rollup field’s formula, use this formula:

ARRAYJOIN(values, "\n")

.Hope this helps!

- ScottWorld, Expert Airtable Consultant

3 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • Answer
  • April 16, 2025

Instead of creating a formula field, create a rollup field (based on that linked record field), and point to the field that you’d like to see in your final results.

Then, for your rollup field’s formula, use this formula:

ARRAYJOIN(values, "\n")

.Hope this helps!

- ScottWorld, Expert Airtable Consultant


Forum|alt.badge.img+2
  • Author
  • New Participant
  • April 17, 2025

@ScottWorld That completely solved the problem!  Thank you so much for the suggestion.  


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • April 17, 2025

@warandco That’s great to hear! You’re welcome! :)