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
5282 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

Well this is fantastic and working great in the test base! Thank you so much. However, when I try to set it up in the actual Base I’ll be using it in, I keep getting an error on the Actions part of the automation. The error is ‘“Fields” could not be converted to a string.’

Any ideas?

6 - Interface Innovator
6 - Interface Innovator

Can you post please a screenshot of this error?
btw, I have a similar question - I need to get a list of dates from two colmns, like so:
(I want to update the “note” column only the amount of days from “start” to “end”)
is it possible?

Screen Shot 2021-09-13 at 9.09.16 AM

Forgot to reply directly to you earlier. Let me know if you have any thoughts on the error I’m receiving. Thanks so much!


you can insert script step inside (after trigger) and use output for step 3
i don’t learn yet how to work with date in JS, so i found some function, reconstructed and tested, and it worked, but for “ISO” format, YYYY-MM-DD , so you should change your field, or adjust the code.


regarding variables for input config(), i tried just “insert” field, but it wprked with zero arraay lenght, then did some fixes yet and it worked OK
sometimes “continue” - “uppercase(or capitalize)” works where “insert” - not.
but i’m not sure, maybe insert will work for you

p.s. for (let dt=date1; dt<=date2; dt.setDate(dt.getDate()+1))

Maybe the formatting of the calculation field is set to date, and that why it can’t get a string?

Thanks a lot!
-I’ll try it…

Here’s what the formatting says?

Screen Shot 2021-09-13 at 1.12.30 PM

ok not a date formatting… what is your formula then?

Screen Shot 2021-09-13 at 1.14.40 PM