How to use time for limited editing

AppSheet AppSheet Q&A
1

I would like to use function “Now()” for the limited Editable status.

I try to use Formula [Booking time] <= now() + (1/24)*4,

the intended behavior is to disable editing 4 hours before the scheduled time, but it is not working.

How to let it working?

Thanks.

2

Is [Booking Time] the same as “Scheduled Time”?

Assuming that [Booking Time] is a DateTime field, the expression should be:

NOW() <= [Booking Time] - "004:00:00"

Basically, the current DateTime is 4 hours or more BEFORE the [Booking Time]. This is a DateTime based version.

You can achieve the same thing basing it on Duration. That expression would be

[Booking Time] - Now() >= "004:00:00"

The duration between current time and the Booking time is 4 hours or more.

Use whichever make most sense to you.

1 Like