Skip to main content
Question

Turning Long Text to Multiple Linked Records

  • October 14, 2025
  • 4 replies
  • 48 views
Kelly_Vorrasi1
Forum|alt.badge.img+9

Hi! I’ve tried a few different ways of doing this and can’t seem to figure it out. I’m importing some data into a new base and there’s a field that has update notes on different lines all formatted the same. I’d love to figure out an automation to add each line to a linked table as separate updates connected to the parent field. Has anyone attempted this before?

Sample long text:

6/24/2025: PB approves DM
7/8/2025: revised draft sent to client
7/10/2025: sent revised draft to sales/CST's
7/14/2025: sent revised draft to client
7/15/2025: final draft  
7/24/2025: final approvals + sent execution copy
7/29/2025: f/u w/ client + PE + email FE PDF to client

 

4 replies

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • October 14, 2025

I’ve done that before with the help of ChatGPT. I had it convert the text into a CSV file for me, and then I imported the CSV file into the linked table.

- ScottWorld, Expert Airtable Consultant

TheTimeSavingCo
Forum|alt.badge.img+31

Does this look right?  If so I’ve set it up here for you to check out!

The idea is to split each line in the “Notes” field into its own quoted string, separated by commas, so you can paste the result into a linked record field

'"' &
SUBSTITUTE(
  Notes,'\n', '","'
) & 
'"'

 

Adam, Airtable Consultant - thetimesaving.company
Kelly_Vorrasi1
Forum|alt.badge.img+9
  • Kelly_Vorrasi1
  • Author
  • Known Participant
  • November 5, 2025

So sorry it took me almost a month to see this! This is exactly what I was trying to do but for some reason when I copy/paste nothing happens! 

TheTimeSavingCo
Forum|alt.badge.img+31

Ah, is the primary field of the linked table a formula field / date field?  That might be the issue

If that’s not the case, if you could private message me a link to your base I could take a look for you!

Adam, Airtable Consultant - thetimesaving.company
Terms & ConditionsAccessibility statement