You need to sign in to do that
Don't have an account?
Pannar
Message Edited by Pannar on 11-27-2008 03:21 AM
Question on Field Level Updates
Dear all,
I would like to know if it is possible to determine what fields were modified by a user when saving an object in Salesforce. For example, a user accesses the Account object and updates the Description and Customer Group values. When they click Save, can that action be captured and those 2 fields identified as modified for further processing in an easy fashion?
Thanks in advance
Pannar
Message Edited by Pannar on 11-27-2008 03:21 AM
Please anyone can respond to my query.
Click Set History Tracking in the field list for the object - this will allow you to specify which fields should be tracked in the History file.
Hope this helps.
Thanks Rick.
I am not able to find the Account history, how do you track the modified fields in each save/modify?
I had set the fields which i wanted to capture.however, how do i test whether the modified records are captured. ActivityHistory table doesn't return any result, instead it says that Query failed:Invalid_Type_for_operation:entity type doesn't support query.
where shall i see the modified fields values? please give me some hint
Does Set History tracking allows to trace ALL the fields we need to capture or only few? If only few, how to capture all the fields?
regards
pannar
When you click on Set History Tracking for the Account standard object, you are presented with a list of fields you can track. I'm not sure that all fields are listed there, although I do see Description as one of the options.
Thanks Ricky, much appreciated for your help.
Last but not least, i found that there is a table called AcitivtyHistory in SFDC DB. i chose some of the fields which i wanted to capture under Account object. however, i wanted to know how to do this practically? i mean whats the approach to get this done. thru apex coding or thru querying thru apex explorer?
Yes Ricky. I wish to get the Account History object under Report tab->Other Reports section.
I used to generate reports in tabular format by selecting the particular object and choose the fields which i wanted to display and filter the fields by entering the formula fields.
Still looking for Account History object?