I am working on building in some functionality that will allow us to track when items are changed from one status to another with a Sharepoint list. What I want to happen is that it writes to another list the previous status and the new updated status along with the date start for new status and date end of the old status and some other important info from the initial list. I am almost positive this can be accomplished via Workflow automations, but I have only built simple ones that email people based on new items being generated.
What is the best way to accomplish this? I know I can keep version histories, but as we have a limit this would quickly be reached where we would lost important information.