Recording the date/time of a record change

  • We have a simple clickbox field for dues paid by year; it has proven to be very useful for generating pages for current participants.

    We would like to record the date when this field is updated as another hidden field, just as the record updated date is currently recorded by the plugin. I currently have a field that must be manually filled in, and as you’d expect, people forget to do so.

    Can you provide a generic example of how to do this that I can follow?

    Mahalo as always!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author xnau webdesign

    (@xnau)

    The basic mechanism for catching when a particular field is updated and then doing something can be found in the script in this article:

    Sending a User Welcome Email When a Record is Approved

    All you need to do customize this to your purposes is change which field is checked (and what you’re checking for?) and set your hidden field to the current date instead of sending an email.

    Thread Starter Billmel

    (@billmel)

    This new example is very helpful. In the example email, it looks like you can include values from the database, as you can with the other mail options in the plugin. Can HTML be included in the outgoing mail as well? Specifically, I’d like to include a URL.

    • This reply was modified 8 years, 4 months ago by Billmel.
    Thread Starter Billmel

    (@billmel)

    The way I’ve setup my database, the “approval” field is a checkbox in a multi-checkbox array of values, in this case a string of years. There used to be documentation on how to print out an entire record for debugging purposes, so either I need that again, or some clue as to how to reference an array element value in the example code to key off of.

    Mahalo!

    Thread Starter Billmel

    (@billmel)

    One other, odd thing. When I configure the plugin as you describe in your email, it appears to work each time I change the approval field from the admin back end, but it doesn’t work when I use the front end. Likewise, when I use the front end, if I have “Send Record Form Update Notification Email” checked, I get an email when the record is updated, but if I update the same record from the admin back end, no notification is sent.

    Mahalo!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Recording the date/time of a record change’ is closed to new replies.