Tracking history without logging
I have a text field that I want to keep one "previous" value for, in a separate field (not logging). This text field has an automation that updates it when a field in a connected table in QB Online changes. Or, a human could update it directly from a form. When the text field is updated, by the human or the automation, I want the current value to be moved into the "previous" field. It seems like this should be easy but I can't see how to do it for both update ways. ------------------------------ Charlotte ------------------------------