I have three fields in a table: Status (multiple choice), Previous Status (text), and Status Changed (checkbox). When the Status field changes and is saved, I want it to record that Status in the Previous Status field and check the box Status Changed. This works on my form rules except for the fact that when I change the Status again I want the Previous Status to always reflect what the Status was just before it changed again. This is so I can track what the most recent Previous Status was before the Status changed. For example, in Status initially on save I have "Active" and in Previous Status I have "Active." Then I change the Status to "On Hold" I want Previous Status to still show "Active." Once the first change on the Status field changes the Status Changed checkbox will always be checked). Does this make sense about what I am trying to do?
Any thoughts? Is this possible?