DB Value (insert) DB Value (Update)

Hi

I have a STATUS field on my form that I want to have the date recorded when the status fields is changed.

STATUS will be changed manually.
Capture date change when status changes.

Currently the Status date updates when I change any field on the form

Thanks

The most easy way is to set the statusdate read-only (set label property to true) or move it out of the screen (bad for testing, you won’t see what’s happening)
Create an ajax event on the status
When the status changes set the statusdate to the system date.
Then updating will work as expected.
Only issue to solve is to test if the status hasn’t reverted back to it’s original, then you would have to restore the old date.

Another option would be the sc_changed macro. Call it in the onValidate/onValidateSuccess event and if it returns true, set your date and you are fine.

jsb