Lee_SGilmore
7 years agoQrew Cadet
Formula Checkbox to Turn On at 11:00am on Monday
I'm currently building in some time sheet data protections and I wanted to turn off the ability to edit a time sheet record anytime after Monday at 11am.
Users submit time each week, due end of day Friday. The grace period is available until 11am the following Monday morning. After that, I'd like the record to be view only and require the user to contact the payroll department if they need to make any changes.
My sketch for a Check Box formula field went something like this:
If(Now) > TimeofDay(FirstDayOfWeek([Date])+Days(1) + Hours(11))
I understand this formula is riddled with issues but it's sketching out my thought process. Any way to achieve this? I can build in permissions that make the record view only once I have the field functioning.
Users submit time each week, due end of day Friday. The grace period is available until 11am the following Monday morning. After that, I'd like the record to be view only and require the user to contact the payroll department if they need to make any changes.
My sketch for a Check Box formula field went something like this:
If(Now) > TimeofDay(FirstDayOfWeek([Date])+Days(1) + Hours(11))
I understand this formula is riddled with issues but it's sketching out my thought process. Any way to achieve this? I can build in permissions that make the record view only once I have the field functioning.