Save the last change value


Is there a way to save the previous status of a record in a specific field? For instance, if the status of a record is changed from PENDING to DONE, we want to store the previous status (PENDING) in a separate field that only saves the last change value.


If you want to record different status of an entry, you can consider putting the status information in a subtable.

And further more, you can use LAST() formulas in an independent field to retrieve the latest status value stored in subtable field.