Merge two "Link to another record..." fields

[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!

[Chen_Pro]

Hello,
If I understand right - you want to create a new record every time the date/location is updated?
In such case, I think that a simple automation can help - you can see an example here
This won’t create a long text field but a list of changes in another table,
which you can link back if needed.

[David_Solimini]

Just a note to endorse @Chen_Pro’s approach. I do this in a few places and it works well. Specifically, I have a number of automations that each watch a particular field. When that field is changed, it creates a new record in a table called Changes with columns:

• Name. Formula for Created Date
• Field Changed. Text. Automation just writes the name of field its watching.
• New value. The value of the watched field.

[Chris_Messina1]

Thanks for the response! I’m attaching some screenshots of how I would like it to work, I’m sure there’s a prettier way to do it but this is what I’m looking for. The first screenshot is just showing what fields I’m talking about and the second is showing how I’d like the data to look in the long text field. You’ll see that Item 1 went to Kevin’s on the 1st, Jeff’s on the 5th, and the Rock Hall on the 8th. That information would be copied to the long text field as it is changed.

[Chris_Messina1]

Thanks for the response. Replying to you as well so you can see the info I added above.

[David_Solimini]

I think you could use an automation that watches either field for a change and on any change grabs the out-to-history field, concatenates the other two values, and saves it back.

Note I bet you will have some difficulty getting the line break you want.

[Rebecca_Elam]

commenting to flag so that i can come back to this after putting some more thought into it.
How did you get it into the field in your screenshot did you just type that in for examples sake?
i also agree with automation but it will have to be set up sort of specifically. happy to help just need some time to play with it.

[Chris_Messina1]

Awesome. I just typed that in for example, yes. I’m fairly new to automatons, so all help will be appreciated. Thanks.

[Rebecca_Elam · Accepted solution]

Example Base Link
Video Of How i Built the Automation
I recommend watching that video on mute and 2x speed lol.

[Rebecca_Elam]

use that button and it should give it to you