Save the last change value

Support
1

Hello,

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.

2

Hi,

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

3

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