Skip to main content

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

 

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

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', '","'
) & 
'"'

 

Terms & ConditionsAccessibility statement