Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 09, 2021 02:13 PM
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!
Solved! Go to Solution.
Sep 11, 2021 07:09 PM
Example Base Link
Video Of How i Built the Automation
I recommend watching that video on mute and 2x speed lol.
Sep 10, 2021 07:43 AM
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.
Sep 10, 2021 07:50 AM
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:
Sep 10, 2021 08:22 AM
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.
Sep 10, 2021 08:23 AM
Thanks for the response. Replying to you as well so you can see the info I added above.
Sep 10, 2021 12:26 PM
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.
Sep 10, 2021 01:51 PM
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.
Sep 10, 2021 02:03 PM
Awesome. I just typed that in for example, yes. I’m fairly new to automatons, so all help will be appreciated. Thanks.
Sep 11, 2021 07:09 PM
Example Base Link
Video Of How i Built the Automation
I recommend watching that video on mute and 2x speed lol.
Sep 11, 2021 07:10 PM
use that button and it should give it to you