Apex Code Development You need to sign in to do that
Don't have an account?
wickham Where is # Times Opened Last Opened Field Stored?
We are looking at building a "counter" at the account level in which it would assign numeric values based on activities at the account and contact level. One of the activities is # of times that an e-mail has been opened. I'm looking at writing a formula field that would query # of times an e-mail that was opened and if anyone from an organization opened it 5 times it would assign a value.
I've looked in the contact and activities table and I don't see where that is stored. Is this something that I can hook into or is it a hidden field?
I wasn't able to find it in the Web UI, but the data is accessible in the Force.com Web Services API. It's stored in the TimesOpened field. What you could do is use the AJAX Toolkit to query for this value and also update the Account if greater than 5.
Hope that helps,
Sati