I have a customer that is working with tests, each test have a confidentiality date. When that date accrues then the its possible to use the test again, the test gets unlocked.
So i am wondering how I can get this functionality, i have a date column and a "Locked" yes or no column. When the date column is equal or later then [Today] then i want to change the "Locked" to "No" ("Locked" column starts on "Yes"). I want this to happen automatically.
I would appreciate a example if its possible.