• MiguelGuerreiro
  • NEWBIE
  • 25 Points
  • Member since 2007

  • Chatter
    Feed
  • 1
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 34
    Questions
  • 65
    Replies

Hello,

I am trying to create a workflow on object "Cases". I have a look up field on Cases called Internal_Originator_c. I want to notify this person whenever the case ownership changes. In the workflow formula, I am writing ISCHANGED(OwnerID) but I am getting the following error.

 

Error: Function ISCHANGED may not be used in this type of formula

 

Why? Can someone sugget a better solution, please? I really appreciate the help.

Hi, The organization that I work used Email to case to track support issues. They would like new cases (=new emails) to stand out as unread, similar to the way that unread emails stand out in Gmail. Is there any way for me to build a field that can figure out if the case was read or not? Thanks! Sara

Hello,

 

I have created a web form for an object. The field in this object are translated into several languages.

 

How can I, using one web form only, have it display several languages?

 

Thanks!

Hello,

 

I have developed a trigger on Attachments. My idea is to update a case field when a new attachment is insert on a case. It works OK, not perfect.

 

I can't deploy it to production because I'm not able to create a test class for it... I tried but I'm only starting with Apex now. The code is below, can someone help me build a test class for it?

 

 

trigger NewAttachment on Attachment (before insert) {List<Case> CasesToUpdate = new List<Case>();for (Attachment t: Trigger.new){try{Case c = new Case(Id = t.ParentId);c.HasAttachments__c = true;CasesToUpdate.add(c);}catch (Exception e) {}}update CasesToUpdate;}//end

 

Thanks! 

 

 

Hello,

 

I'm using CMSForce to create a web form for a custom object (which has a look up field for Contacts). Is there a way to automatically link the custom object to the correct contact when he saves the record in the web form? Maybe using his email address?

 

Thanks!

Hi,

we have a problem in our company that i dont know how to resolve.

Step 1: We have to modify a field in all the new lead that comes, its working.

Step 2: This modification will fire a trigger that create documens asociated to the lead,

working but when are more than 10 documents the next error fire: "Too many SOQL queries: 21"

 

Then next step work but only if we do it throught a independient workflow but we dont know how to do that the last trigger do it: 

 

Step 3: We need that the process create 4 based timed WorkFlows that will send an email to the lead, working.

 

WF Process

 

 

Any suggestion??

Thanks a lot

 

I am unable to find a solution that allows me to determine whether a case is related to Support or Services. Both our Support teams and a services team use SFDC for case management (project related cases and support related cases).

 

Internally I can track whether this is a Support case or a service case based on Record Types but when a client logs into the self service portal to log a issue or view a issue I am unable to display the ticket 'group'owner. How can they select whether the case being submitted is a Support case or a service case so the correct teams are notified and the issue worked?

Message Edited by NIKAL on 01-13-2010 11:07 AM

hello,

 

im trying to create a trigger to prevent users from adding comments on closed cases.

 

this is my code:

 

trigger CloseComment on CaseComment (before insert) {


for (CaseComment t: Trigger.new)
{
Case c = new Case(Id = t.ParentId);

if(c.Status == 'Closed' && c.Process__c == 'Payroll')
{
t.addError(c.Process__c + 'case closed' + c.Status);
}
else
t.addError(c.Process__c + 'case open' + c.Status);
}
}

 

but i can't get the values of any case fields. I guess im missing something simple.

 

Any ideas?

Message Edited by MiguelGuerreiro on 01-14-2010 09:20 AM
Hello,   I need to archive (remove from salesforce) around 400.000 email messages. I tried the weekly export but files are too big and it's not possible to open them (in case I need to import some information back to salesforce). The main issue is that the email message body is not stored in one cell (one single email message is scattered in several rows). The same happens with Data Loader.  Does anyone ever try this? What are my options? I'm running out of space and I really need to free up some space...

Hi,

 

We have enabled cases for Partner Portal. But during a new case creation, we want to hide the option "Send notification email to contact" checkbox that appears at the bottom of the new Case page lyout.

 

How can we do this without having to convert the page to visualforce?

 

Thanks

I am looking for a solution: I have a workflow rule setup to send an email when a date field is changed. The problem is it sends the alert when the date is entered as well as when it is changed. Any idea how to suppress the the email alert when the date is initially entered?

 

Thanks for any guidance you may be able to offer.

Hello,

 

Anyone using Case Age In Business Hours package from appexchange is having problems with Email2Case?

 

 

We're getting a lot of errors because of too many SQL queries...

 

Thank you for any help!

 

2009-09-23 13:45:36,770 145373 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:0: CalculateBusinessHoursAges: execution of BeforeUpdate

caused by: System.Exception: Too many SOQL queries: 21

Trigger.CalculateBusinessHoursAges: line 20, column 32
2009-09-23 13:45:36,792 145395 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:1: CalculateBusinessHoursAges: execution of BeforeUpdate

caused by: System.Exception: Too many SOQL queries: 21

Trigger.CalculateBusinessHoursAges: line 20, column 32
2009-09-23 13:45:36,792 145395 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:2: CalculateBusinessHoursAges: execution of BeforeUpdate

caused by: System.Exception: Too many SOQL queries: 21

Trigger.CalculateBusinessHoursAges: line 20, column 32
2009-09-23 13:45:36,792 145395 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:3: CalculateBusinessHoursAges: execution of BeforeUpdate

caused by: System.Exception: Too many SOQL queries: 21

Trigger.CalculateBusinessHoursAges: line 20, column 32
2009-09-23 13:45:36,792 145395 [Timer-0] ERROR com.sforce.mail.GenericClient - Wed Sep 23 13:45:36 WEST 2009:Error:4: CalculateBusinessHoursAges: execution of BeforeUpdate

caused by: System.Exception: Too many SOQL queries: 21

Trigger.CalculateBusinessHoursAges: line 20, column 32
2009-09-23 13:45:36,792 145395 [Timer-0] INFO com.sforce.mail.GenericClient - Copying 5 messages to error mailbox
2009-09-23 13:46:21,784 190387 [Timer-0] INFO com.sforce.mail.GenericClient - Wed Sep 23 13:46:21 WEST 2009:Success:0 ID=02s20000002VbynAAC Success=true
2009-09-23 13:46:21,784 190387 [Timer-0] INFO com.sforce.mail.GenericClient - Wed Sep 23 13:46:21 WEST 2009:Success:1 ID=02s20000002VbyoAAC Success=true
2009-09-23 13:46:21,784 190387 [Timer-0] INFO com.sforce.mail.GenericClient - Wed Sep 23 13:46:21 WEST 2009:Success:2 ID=02s20000002Vc2DAAS Success=true

 


 

Message Edited by MiguelGuerreiro on 09-23-2009 01:54 PM

Hello Team,

 

After downloading and installing the AppExchange package 'Currency Exhcange Rate Updater' into my SandoBox account, and configuring it according to the Configuration Guide, it fails to connect to http://download.finance.com.  As such, I have contacted SalesForce.com support who informed me that this was the place to get help with this issue.  Has anyone here run into this same problem, and if so, is there a solution that you can share?  Thanks in advance,

 

Daniel Orrego

Finance Technical Director

Cornerstone Information Systems

812.345.3425