AnsweredAssumed Answered

Transferring Fields from Once Table to Another

Question asked by thilleary on Mar 28, 2018
Latest reply on Mar 29, 2018 by beverly

I have a large database containing contact information - about 900 records. I have another table with most of the same fields that contains updated data that I want to move into the master db table. There are many ways to do this automatically, but I need to be careful that I do not overwrite master data that should stay intact.

 

So I created a layout that provide a comparison of the pertinent data in the two tables. I want to see these records side-by-side to verify which should be moved fro the update table to the master table.

 

It looks like this currently:

FMTransfer.jpeg

 

I can conditionally format the fields so that differences are highlighted (I just set that up on the Zipcode to test it).

If the data looks OK and needs to be transferred into the master table, what kind of script would the "Transfer Fields..." button need to trigger? All the fields for a particular record can be transferred, no need to do so individually, although that would be cool to be able to do.

Outcomes