Manage the record of days off

I’m making a website to keep track of monthly days off. I already have a database with the start date and end date of that leave, I have another personnel database that is connected to the date database. I have to change the state if it is free or not in the database since a record must be kept of the previous states, I have seen a lot about creating states but these are only visual and I could not save it to have the history

1 Like

States are stored temporarily on client side. You want to set a field in the db for whether off or not