Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Merge 2 fields to another to keep a record of changes

Topic Labels: Base design
Jump to Solution
5302 32
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


I’m trying to merge the data from 2 separate fields whenever they are updated into another field to keep a history of those changes.

The first field is date and time, the second field is a single select of location. Ideally, this information would just automatically copy to the next line down of a long text field whenever it’s changed.

I have no idea the best way to go about this. Thanks for your help in advance!

32 Replies 32

also try retesting your trigger

And it’s working! Looks like it was the population issue.

Rich text is turned off, but it is working as planned. Should I turn it on or just leave it be?

as long as all youre using is line breaks you should be able to leave it off but if you use any other rich text or markdown you need to turn it on. i don’t think line breaks count as ‘rich text’ per se.