>I'd like to write a little script that will log all changes to the name and >address fields in the memo field, so that volunteers don't have to remember >to document changes themselves. (An example: Don Smith signed up for our >newsletter in 1998, but we just received a check from him and his wife Donna >that was signed by Donna, implying that she's interested, so we add her name >to his record rather than doing all that fooling around with householding. >We want a record that Donna wasn't in the database for the past four years.) > >I feel like I ought to be able to piggyback this script on whatever action >updates the Contact Info Edit Date field, since that field changes whenever >the record is modified, but I can't figure out what that action is. Who can >tell me?
That action isn't driven by a script. The field Contact Info Edit Date is calculated. It's updated whenever the field Contact Info (just name, address, email, phone, concatenated) isn't equal to itself, which happens after the data is entered, but before it's committed. There isn't a trigger to start a script there. >On a related note, I'd like to make the Contact Info Edit Date field *only* >update itself when the Names table info is modified, *not* when contacts or >payments are added. It's a real pain to send out a mailing that generates >contact records and then find that all the edit dates for those hundreds of >people have been obliterated -- that's useful information; we need to know >which volunteer last modified the record. That's how I understand it works. The field Contact Info is a concatenation of name, address, phone, email, and the date is updated only when one of the contact info fields is changed. -- -- Dave Shaw H4 Consulting tel: 206-954-7526 fax: 206-625-1338 ------------------ Reminder to each recipient: To change your list account preferences, go to http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address you used to subscribe to the ebase support list:: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] --------------------------------------------------------------------- ebase - Relationship Management for Nonprofits, http://www.ebase.org ---------------------------------------------------------------------
