Skip to main content

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

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

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

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

Reply


Terms & Conditions