History Log

[grumbachr]

I'd like to keep track of the totals, which seems easy by using a simple script to set a few fields like Date, Report Name, and total, in a Log Table.

As I think about it more I kind of like to know a little more than how the Total changes. I like to be able to capture all the Contact_IDs and store them in a field along with the total and date. (Can I avoid creating some kind of record for each Contact ID?)

I imagine someone has done something similar, if so I like to get your input on making this work and maybe even a few tips for going beyond what I've considered so far.