Forum Discussion

Jan-WillemSpeck's avatar
Jan-WillemSpeck
Qrew Assistant Captain
8 years ago

Overwrite [update] a timestamp field / control a timestamp from multiple checkboxes

Hi all, I have a timestamp field that's is controlled by a checkbox-field and filled by the dynamic-rules "When checkbox is equal to checked than action change timestamp to current date/time" qui...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
JWS

How about trying this single Rule

When the record is saved
And any of the following

Checkbox 1 has changed
Checkbox 2 has changed

...

Checkbox 10 has changed

Action:
Change the value of [Last checkbox change date] to the current date /time

The only flaw in this is that it presumed your checkboxes advance to completion, as unchecking a box will also trigger the form rule.

But in typing this, I didn�t text bu5 it may also allow the rule

When checkbox 1 has changed to checked. (As opposed to simply changed)