Announcement

Collapse
No announcement yet.

DB Value (insert) DB Value (Update)

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    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.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      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

      Comment

      Working...
      X