How to store previous value of the field in the database


I have fields called "Current Status" and "Previous Status"... and trying to use conditional rules to automate "Previous Status". But no luck so far. Any idea how to accomplish this? On the database level. I am not able to do so on app front end.



In Builder, make a Task to set Previous Status to equal the Current Status, similar to what I did below. Essentially just copying over current value before I update the system. You can set it to run on a schedule or on demand, whichever works best.

Probably another way to do it, but this one seems to work.