AnsweredAssumed Answered

Find and Copy Contents from matched record

Question asked by vars on Nov 8, 2018
Latest reply on Nov 8, 2018 by vars

I have a set of records for each Year.

Each record looks like: Field 1 | Field 2 | Field 3 | Notes | Year |

 

While I import records for 2018,                      //Already implemented

To do: If Field 1, Field 2, Field 3 for 2018 match Field 1, Field 2, Field 3 for 2017,

                  Then, copy Notes of 2017 to Notes of 2018

 

Any suggestions on the best way to do that. Thanks in advance.

 

P.S. Each record in 2018 will match at most 1 record in 2017. This will be implemented in a generic way for every year.

Outcomes