Merge 2 fields to another to keep a record of changes

[Chris_Messina1]

Hello!

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!

[Chris_Messina1]

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?

[Chen_Pro]

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?
Thanks!

[Chris_Messina1]

[Chris_Messina1]

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

[Alexey_Gusev]

Hi,

Yes.
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))

[Chen_Pro]

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

[Chen_Pro]

Thanks a lot!
-I’ll try it…

[Chris_Messina1]

Here’s what the formatting says?

[Chen_Pro]

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

[Chris_Messina1]