Forum Discussion

Lee_SGilmore's avatar
Lee_SGilmore
Qrew Cadet
7 years ago

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...
Formulas and functions
roles and permissions
JustinTorrence1's avatar
JustinTorrence1
Qrew Member
7 years ago
Lee,
Could something like this work?
You could create a formula checkbox called IsEditable, and then create a custom rule for editing where this checkbox must be checked.

If(
    [Time Card Date] <= Today(),
        If(
            Now() > ToTimestamp(FirstDayOfWeek([Time Card Date]) + Days(8), ToTimeOfDay("11:00")), false,
            true
        ),
    true
)


"FirstDayOfWeek([Time Card Date]) + Days(8)" should return the Monday that follows every "time card"