We currently use SFDC to track Support cases at our company and we're using a pretty stock Case tab. When editing the Case details, upon saving the record, the Last Modified date is updated as expected. However, the support engineers are very fond of using a related list - Case Comments to continually add comments to the case. They like that each Comment is encapsulated by itself (as opposed to a giant scrolling textbox) which keeps track of who when and what was happening. However, they'd like the Case Detail last modified date to be updated each time a comment is updated or created.
In talking with Basic support at SFDC, they didn't think this was possible. One solution that I could think of is to write some sort of scheduled job outside (like .NET) of SFDC that periodically checks all the cases and then update the last modified date of the Case detail if the max(last modified) field of any related comment is greater than the last modified date of the case detail. However, before going this route, I was wondering if there was another method that others have used that I haven't found in my (so far in vain) searching on the web.
I'm also questioning if I can/should be able to directly modify the last modified date field in the case details table in sfdc.
How can I create a formula which will indicate the time it took my employees to answer a case.
I have the "status" field and actually I want to measure the time between the case is opened and time the status field value was changed from "new" to any other value.
Is there any way to do a redirect, instead of a popup window using a HYPERLINK formula? I'm referencing an Scontrol, so would like it to behave like a Custom Link with an scontrol that uses parent.frames.
Thanks, Ryan
Message Edited by Grinster650 on 12-08-200501:16 PM
A new version (V2.1) of DBAmp as been posted at the DBAmp open source project. Details are available at www.forceamp.com . The new version provides UPDATE /DELETE support as well as some performance enhancements. Questions regarding DBAmp can be posted in this forum (Open Source).
After I successfully uploaded Opportunity objects and their OpportunityLineItem objects, I failed to upload OpportunityLineItemSchedule objects. I got this error "insufficient access rights on cross-reference id " I'm not sure why this happened, I am sure I have enough access rights to create new opportunities and add products on line in the salesforce.com. Does anyone have any idea about why this happened?
I have a very minor feature request for Salesforce and would like to contact someone about it. After a quick look around the site I can't tell how to do so. Can someone please assist me? How do I make a feature request? Who should I contact? The request is minor. I need a certain permission file added to the Web service machines so that the technology I'm using will work.
