Seesaw fix idea Add a time component to the formula to make the row being entered an exception, e.g. Column [timestamp] has an initial value of NOW() Validation has, in addition to the existing condition, something like: [timestamp] < NOW() Maybe with some time subtraction on it as well like - 000:02:00 I've not tried this, but it works in other places. It may fall down if the form isn't filled out quick enough though.
That's a good idea! But I've encountered the situation you described, where the time wasn't long enough for the person to complete the form before the restriction kicked in. - Best thing about AppSheet is there's 4 ways to do any 1 thing!
Seesaw fix idea
Add a time component to the formula to make the row being entered an exception, e.g.
Column [timestamp] has an initial value of NOW()
Validation has, in addition to the existing condition, something like:
[timestamp] < NOW()
Maybe with some time subtraction on it as well like
- 000:02:00
I've not tried this, but it works in other places. It may fall down if the form isn't filled out quick enough though.
That's a good idea! But I've encountered the situation you described, where the time wasn't long enough for the person to complete the form before the restriction kicked in.
- Best thing about AppSheet is there's 4 ways to do any 1 thing!