Hi guys, I am looking how to capture the information from a record before it is going to be updated.
Scenario:
I have two columns 1) {Current location} 2) {Last time location}. Column {Current location} is 3 times per week updated by CSV import.
I’m looking how to capture in {Last time location} the values from {Current location} before those are updated so by this to analyze difference between {Current location} and {Last time location}.
Real case: Today {current location} is Monaco so {Last time, location} should become empty.
Tomorrow {current location} is going to be Paris so {Last time, location} should became Monaco.
I saw before on the forum that there is a solution for that and it was used to record Notes like: Column {Comments} and {Global comments} for each line.
- So the script was working like:
When values as text are inserted in {Comments} - those are automatically moved in {Global comments} and merge {Comments} values with existing {Global comments}.
In my case I’m looking for a script or other solution that will just overwrite instead of merging data with the existed one.
Many thanks in advance for your time and help!