After extensive research I think I know what I need to do, but I don’t know how to get there
basically, I need to create a trigger to determine when a field was last populated.
I know this can be done via workflow and using the now() function for eg, if field is changed populate with date. However I have over 50 fields per object so don’t want to great 50 new date/time fields.
Now my idea is to Create a new object called “Analysis” and have the following three fields “Object Name”, “field” , “Last Populated ”. (Not sure whether to use api name or field name)
For eg (If this field was last populated four days ago and trigger run today) Object Name = Account Field Name = Agent Code Api Name = Agent_Code__c Last Populated = 01/06/2014
For eg (If this field was last today and trigger run today) Object Name = Account Field Name = Agent Code Api Name = Agent_Code__c Last Populated = 05/06/2014