Hi All,
Im looking to automatically change the status based on time elapsed.
eg.
Daily Clean Status changes to Expired after 24hours from when it was logged.
To expand… we would have a table listing all the room IDs, Current Status etc.
But the current status would need to update automatically when the “Valid” status times out.