AnsweredAssumed Answered

How to automatically record an old data from a field to another field when I updated it?

Question asked by Angelus81 on May 18, 2016
Latest reply on May 18, 2016 by bigtom

I have an inventory database that contains the costs of my products and every certain period of time I will have to update my cost. So, I am thinking if it is possible for me to automatically record an old price from a filed to another when I update the cost?

 

For example, when I update my "cost" filed (number-filed), the old dollar amount will be copied and pasted to a "old cost" filed (text-field)?

 

Please help!!!

Outcomes