I have a Button that Changes Color after the Data is Collected. I'd Also Like to Know How Many of these Records have Been touched or Updated. No Clue
It would probably be best to put a field in your table that gets updated when a record's value get changed. Then you can count those. Like a Flag_Updated field that gets set to 1 when the record is updated.
How will records get updated? And how does the button change color? What conditional formatting are you using?
Folks also put in a zz_ModifiedTS, and make it an auto-enter timestamp field. This captures the last time a record was updated.
You could use this to count the # of records that have been updated in a given day or time period.
Retrieving data ...