I created my trigger and it seems to work fine. When I try to create a bulk insert test I get 100% coverage but get an error which I can't seem to overcome. Any help would be greatly appreciated.

22:56:46.254|FATAL_ERROR|System.DmlException: Insert failed. First exception on row 0; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, LastFTFDateforAccountStamp: execution of BeforeInsert

caused by: System.DmlException: Update failed. First exception on row 0; first error: MISSING_ARGUMENT, Id not specified in an update call: []

Trigger.LastFTFDateforAccountStamp: line 27, column 9: []

Class.AEREGIONROLECLASSONACTIVITIES.testBulkInsert: line 85, column 10
External entry point

Trigger

trigger LastFTFDateforAccountStamp on Event (before insert, after update){ Set<Id> Events = new Set<id> (); List<Account> AccountList = new List<Account>(); for (Event e : Trigger.new) Events.add(e.id); Map<Id, Event> eventdate= new Map<Id,Event> ([Select ActivityDatetime from event where id in :Events]); for (Event e : Trigger.new){ if (e.call_type__c =='In Person' && e.EventStatus__c=='Completed'&& e.ActivityDatetime < datetime.now()) { //update account if event is in Person and completed Account a = new Account( Id = e.AccountId ); a.Last_FTF_Activity__c=e.endDatetime; AccountList.add(a); } else if (e.call_type__c =='Sales Phone Call' && e.EventStatus__c=='Completed'&& e.ActivityDatetime < datetime.now()) { Account a = new Account( Id = e.AccountId ); a.Last_SPC_Activity__c=e.endDatetime; AccountList.add(a); update AccountList; } } }

public with sharing class AEREGIONROLECLASSONACTIVITIES { static testMethod void testSingleInsert() { Profile p = [select id from profile where name='Standard User']; UserRole ur= [select ID from UserRole where name='Support Analyst']; User u = new User(alias = 'test123', email='test123@noemail.com', emailencodingkey='UTF-8', lastname='Testing', languagelocalekey='en_US', localesidkey='en_US', profileid = p.Id, country='United States', timezonesidkey='America/Los_Angeles', username='test123@noemail.com'); insert u; Lead L = new Lead(LastName='Tester',Company='Test Inc',OwnerId=u.Id,ownerRoleid__c=ur.id); insert L; Contact co = new Contact( firstname='John', lastname='Doe', Survey_sent__c=true); insert co; Account a= new Account( Name = 'Test Account', OwnerId = u.Id ); insert a; case c = new Case(Taken_By__c='Internal',customer_type__C='Internal',priority='low', origin='Email',status='Assigned',escalation__C='Level 2',subject='Brian Trigger Test', Description='Brian Trigger Test',Update_Contact_Survey_Value__c = True,Send_Internal_Survey_to_User__c=true,contactid=co.id,OwnerId = u.Id ); insert c; Event e2= new Event(subject='Test', ActivityDatetime= datetime.now(), DurationInMinutes=60,eventstatus__c='Completed', Product_Subject__c='Arrow',format__c='Demo',Call_type__c='In Person',OwnerId = u.Id); insert e2; update e2; Account bb= new Account( Name = 'Test Account', Last_SPC_Activity__c=e2.ActivityDatetime, OwnerId = u.Id ); insert bb; Opportunity o= new Opportunity(Name='Brian Test', type='COA', ordertype__c='Defensive COA',stagename='S0-Suspect Pool', closedate=date.today()); insert o; System.assertEquals(u.unavailable__c,[Select Unavailable__c From CASE Where Id = :c.Id].unavailable__c); } static testMethod void testBulkInsert() { List<Event> events = new List<Event>(); Profile p = [select id from profile where name='Standard User']; User u = new User(alias = 'test123', email='test1234@noemail.com', emailencodingkey='UTF-8', lastname='Testing', languagelocalekey='en_US', localesidkey='en_US', profileid = p.Id, country='United States', timezonesidkey='America/Los_Angeles', username='test1234@noemail.com'); insert u; Account a= new Account( Name = 'Test Account', OwnerId = u.Id ); insert a; for (Integer i=0;i<200;i++) { Event e2= new Event(subject='Test', ActivityDatetime= datetime.now(), DurationInMinutes=60,eventstatus__c='Completed', Product_Subject__c='Arrow',format__c='Demo',Call_type__c='Sales Phone Call',OwnerId =u.Id); events.add(e2); } insert events; } }

Hello, I'm fairly new to apex, but I have been able to complete the following code below to capture the last in person and sales phone call activity date. The trigger works perfectly, but I would like to have the trigger fire when an event is entered and closed immediately or when an event is scheduled for the future and then closed as completed when that future date passes and the event is closed by the user. I don't want the trigger to fire everytime a record is updated that meets the criteria only when a record is updated and has somehow changed.

So my question comes down to how can I add the ischanged functionality to my trigger?

Or better yet how can I incorporate the following which you typically find when creating a workflow using the UI.

"When a record is created, or when a record is edited and did not previously meet the rule criteria"

Thanks for the help in advance. 

trigger LastFTFDateforAccountStamp on Event (after insert, after update){
Set<Id> Events = new Set<id> ();
List<Account> AccountList = new List<Account>();
for (Event e : Trigger.new)
Events.add(e.id);

Map<Id, Event> eventdate= new Map<Id,Event> ([Select ActivityDatetime from event
where id in :Events]);

for (Event e : Trigger.new){
if (e.call_type__c =='In Person' && e.EventStatus__c=='Completed'&& e.ActivityDatetime < datetime.now()) {

//update account if event is in Person and completed

Account a = new Account( Id = e.AccountId );
a.Last_FTF_Activity__c=e.endDatetime;
AccountList.add(a);

update AccountList;

}
else if (e.call_type__c =='Sales Phone Call' && e.EventStatus__c=='Completed'&& e.ActivityDatetime < datetime.now())
{
Account a = new Account( Id = e.AccountId );
a.Last_SPC_Activity__c=e.endDatetime;
AccountList.add(a);

update AccountList;
}
}
}

I created my trigger and it seems to work fine. When I try to create a bulk insert test I get 100% coverage but get an error which I can't seem to overcome. Any help would be greatly appreciated.

22:56:46.254|FATAL_ERROR|System.DmlException: Insert failed. First exception on row 0; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, LastFTFDateforAccountStamp: execution of BeforeInsert

caused by: System.DmlException: Update failed. First exception on row 0; first error: MISSING_ARGUMENT, Id not specified in an update call: []

Trigger.LastFTFDateforAccountStamp: line 27, column 9: []

Class.AEREGIONROLECLASSONACTIVITIES.testBulkInsert: line 85, column 10
External entry point

Trigger

trigger LastFTFDateforAccountStamp on Event (before insert, after update){ Set<Id> Events = new Set<id> (); List<Account> AccountList = new List<Account>(); for (Event e : Trigger.new) Events.add(e.id); Map<Id, Event> eventdate= new Map<Id,Event> ([Select ActivityDatetime from event where id in :Events]); for (Event e : Trigger.new){ if (e.call_type__c =='In Person' && e.EventStatus__c=='Completed'&& e.ActivityDatetime < datetime.now()) { //update account if event is in Person and completed Account a = new Account( Id = e.AccountId ); a.Last_FTF_Activity__c=e.endDatetime; AccountList.add(a); } else if (e.call_type__c =='Sales Phone Call' && e.EventStatus__c=='Completed'&& e.ActivityDatetime < datetime.now()) { Account a = new Account( Id = e.AccountId ); a.Last_SPC_Activity__c=e.endDatetime; AccountList.add(a); update AccountList; } } }

public with sharing class AEREGIONROLECLASSONACTIVITIES { static testMethod void testSingleInsert() { Profile p = [select id from profile where name='Standard User']; UserRole ur= [select ID from UserRole where name='Support Analyst']; User u = new User(alias = 'test123', email='test123@noemail.com', emailencodingkey='UTF-8', lastname='Testing', languagelocalekey='en_US', localesidkey='en_US', profileid = p.Id, country='United States', timezonesidkey='America/Los_Angeles', username='test123@noemail.com'); insert u; Lead L = new Lead(LastName='Tester',Company='Test Inc',OwnerId=u.Id,ownerRoleid__c=ur.id); insert L; Contact co = new Contact( firstname='John', lastname='Doe', Survey_sent__c=true); insert co; Account a= new Account( Name = 'Test Account', OwnerId = u.Id ); insert a; case c = new Case(Taken_By__c='Internal',customer_type__C='Internal',priority='low', origin='Email',status='Assigned',escalation__C='Level 2',subject='Brian Trigger Test', Description='Brian Trigger Test',Update_Contact_Survey_Value__c = True,Send_Internal_Survey_to_User__c=true,contactid=co.id,OwnerId = u.Id ); insert c; Event e2= new Event(subject='Test', ActivityDatetime= datetime.now(), DurationInMinutes=60,eventstatus__c='Completed', Product_Subject__c='Arrow',format__c='Demo',Call_type__c='In Person',OwnerId = u.Id); insert e2; update e2; Account bb= new Account( Name = 'Test Account', Last_SPC_Activity__c=e2.ActivityDatetime, OwnerId = u.Id ); insert bb; Opportunity o= new Opportunity(Name='Brian Test', type='COA', ordertype__c='Defensive COA',stagename='S0-Suspect Pool', closedate=date.today()); insert o; System.assertEquals(u.unavailable__c,[Select Unavailable__c From CASE Where Id = :c.Id].unavailable__c); } static testMethod void testBulkInsert() { List<Event> events = new List<Event>(); Profile p = [select id from profile where name='Standard User']; User u = new User(alias = 'test123', email='test1234@noemail.com', emailencodingkey='UTF-8', lastname='Testing', languagelocalekey='en_US', localesidkey='en_US', profileid = p.Id, country='United States', timezonesidkey='America/Los_Angeles', username='test1234@noemail.com'); insert u; Account a= new Account( Name = 'Test Account', OwnerId = u.Id ); insert a; for (Integer i=0;i<200;i++) { Event e2= new Event(subject='Test', ActivityDatetime= datetime.now(), DurationInMinutes=60,eventstatus__c='Completed', Product_Subject__c='Arrow',format__c='Demo',Call_type__c='Sales Phone Call',OwnerId =u.Id); events.add(e2); } insert events; } }

Hello, I'm fairly new to apex, but I have been able to complete the following code below to capture the last in person and sales phone call activity date. The trigger works perfectly, but I would like to have the trigger fire when an event is entered and closed immediately or when an event is scheduled for the future and then closed as completed when that future date passes and the event is closed by the user. I don't want the trigger to fire everytime a record is updated that meets the criteria only when a record is updated and has somehow changed.

So my question comes down to how can I add the ischanged functionality to my trigger?

Or better yet how can I incorporate the following which you typically find when creating a workflow using the UI.

"When a record is created, or when a record is edited and did not previously meet the rule criteria"

Thanks for the help in advance. 

trigger LastFTFDateforAccountStamp on Event (after insert, after update){
Set<Id> Events = new Set<id> ();
List<Account> AccountList = new List<Account>();
for (Event e : Trigger.new)
Events.add(e.id);

Map<Id, Event> eventdate= new Map<Id,Event> ([Select ActivityDatetime from event
where id in :Events]);

for (Event e : Trigger.new){
if (e.call_type__c =='In Person' && e.EventStatus__c=='Completed'&& e.ActivityDatetime < datetime.now()) {

//update account if event is in Person and completed

Account a = new Account( Id = e.AccountId );
a.Last_FTF_Activity__c=e.endDatetime;
AccountList.add(a);

update AccountList;

}
else if (e.call_type__c =='Sales Phone Call' && e.EventStatus__c=='Completed'&& e.ActivityDatetime < datetime.now())
{
Account a = new Account( Id = e.AccountId );
a.Last_SPC_Activity__c=e.endDatetime;
AccountList.add(a);

update AccountList;
}
}
}

Overview of My Scenario

Custom Fields Involved, in my Opportunity Object

A.    Deal Approved, date field

B.    Deal Rejected, date field

C.    Reason Deal Rejected, text field

D.   Close Sheet Attached, check box

E.    Stage = Closed Won

Usually the process flows as follows:

1.    Sales Rep receives a signed agreement, thencompletes Customer Close Sheet

2.    Sales Rep Attaches CLOSE SHEET to theOpportunity

3.    Sales Rep Updates Sales Stage to Closed Won(validation rule prevents close won if Close Sheet = False)

4.    Workflow Notifies Operations of Closed Deal

5.    Operations reviews the Close Sheet and either:

a.    Marks Opportunity Approved by inserting todaysDate in the Close Sheet Approved; or

b.    Marks Close Sheet Rejected; then

                                              i.     AddsReason Rejected.

6.    Workflow then notifies Sales Rep of Rejectionand includes data “Reason Rejected” field

7.    Sales Rep corrects the issue, then notifiesOperations that issues were resolved.

8.    If Operations reviews and  then approves the Opportunity, Operationsthey can set the Approved Date and erase the Rejected Reason, and Date Rejected.

Formulas that I have tried and are failing to meet my ultimate objectivethus far

F1.(Rejected_Reason__c ) = 0

F2.NOT ( ISNULL ( Rejected_Reason__c ))

F3.Close Sheet_Attached__c = FALSE ) && (ISPICKVAL( StageName ,"Won"))  ********NOTE: This formula appears to be working, with a slight workaround … I’ve included a default value (a DOT) in the field “Rejected Reason”

My objective is to create a formula that will enable:

Objective 1.              New Opportunities to be created without needinga Rejected Reason, until or unless an Opportunity has been rejected;

Objective 2.              No opportunity can be Approved unless it’sclosed won.

Objective 3.              IDEALLY (but not a MUST), when Operationsupdates the Approved Date, the system would automatically remove the RejectedReason and Rejected Date

Hi, 

I am fairly new to Apex development and programming in general.  My particular issue is that I am having trouble creating a test method for a custom controller.  I have a VF page with a simple form for submitting cases, and a custom controller to handle it.  I've deployed the VF page and controller to my developement org and everything works properly.  Now I want to deploy it to production but need test coverage.  

I have read through the Apex Developer's Guide and countless forum postings on developing test methods but I am still stumped.  

Below is the VF page, Custom Controller class, and my current (inadequate) test method.

VF Page: simple case submit form

<apex:page controller="SubmitCaseController"> <h1>Submit New Case</h1> <apex:form > <apex:pageMessages /> <table> <tr> <th>Your Name:</th> <td><apex:inputText value="{!c.SuppliedName}"/></td> </tr> <tr> <th>Your Email:</th> <td><apex:inputText value="{!c.SuppliedEmail}"/></td> </tr> <tr> <th>Your Account Number:</th> <td><apex:inputText required="true" value="{!acctNum}"/></td> </tr> <tr> <th>Title:</th> <td><apex:inputText required="true" value="{!c.Subject}"/></td> </tr> <tr> <th>Your Problem:</th> <td><apex:inputTextArea required="true" rows="5" value="{!c.Description}"/></td> </tr> <tr> <td><apex:commandButton value="Submit Case" action="{!submitCase}"/></td> </tr> </table> </apex:form></apex:page>

 Custom Controller: The general functionality is to use the acctnum field to match an existing account.  Then, find the appropriate contact by matching the account and email address.  Then insert the case.

public with sharing class SubmitCaseController { public Case c { get; set; } public String acctNum { get; set; } public SubmitCaseController() { c = new Case(); } public PageReference submitCase() { List<Account> accts = [SELECT Id FROM Account WHERE AccountNumber = :acctNum]; if (accts.size() != 1) { ApexPages.Message msg = new ApexPages.Message(ApexPages.Severity.FATAL, 'Invalid account number'); ApexPages.addMessage(msg); return null; } else { try { c.AccountId = accts.get(0).Id; // now look for an associated contact with the same email Contact cnt = [SELECT Id FROM Contact WHERE AccountId = :c.AccountId AND Email = :c.SuppliedEmail LIMIT 1]; if (cnt != null) c.ContactId = cnt.Id; // Specify DML options to ensure the assignment rules are executed Database.DMLOptions dmlOpts = new Database.DMLOptions(); dmlOpts.assignmentRuleHeader.useDefaultRule = true; c.setOptions(dmlOpts); // Insert the case INSERT c; return new PageReference('/thanks'); } catch (Exception e) { ApexPages.addMessages(e); return null; } } }}

 My current test method:

@isTestprivate class SubmitCaseControllerTests { public static testMethod void testSubmitCaseController() {PageReference pageRef = Page.PortalCaseSubmit; Test.setCurrentPage(pageRef); Account testaccount = new Account(name = 'Acme', AccountNumber='123456'); insert testaccount; Contact testcontact = new Contact(firstname='joe', lastname='smith', email='joe@smith.com'); insert testcontact; Case c; c.SuppliedName='Joe Smith'; c.SuppliedEmail='joe@smith.com'; c.Subject = 'Test'; c.Description = 'This is a test.'; String acctnum = '123456'; SubmitCaseController controller = new SubmitCaseController(); controller.submitcase(); Case cases = [Select ID, subject, description from Case Where account.id = :testaccount.id]; System.assertequals(cases.description, c.description); } }

My logic is to instantiate an account and contact and insert them into the database.  Then, mimic the process of someone completing the form and submitting it.  I could test both positive and negative results this way.  However, I am stumped as to how to populate the form fields and submit the form using Apex.  Any help would be appreciated.

Thanks,

Clint 

Hi guys!

I need to create email template with links in the body. For example I want my email body to have name of account which would be not just a string but link (ordinary anchor: <a href=https://na1.salesforce.com/Account.ID>Account.Name</a>. Currently I'm generating email body programmatically (body={!Campaign_Description}, I fill in Campaign.Description field and then trigger workflow rule which sends email based on my custom email template. All this done programmatically). If I'm using ordinary Text-type email template and filling Campaign.Description field with string

    <a href=https://na1.salesforce.com/Account.ID>Account.Name</a>

than when I receive email its body is not recognized as HTML content and I see the whole string shown above with all tags - just plain text.

I tried to build Custom-type email template, but didn't achieve my point - I fill in Campaign.Description field with the same string but after receiving email I see that chars '<' and '>' are replaced with '&lt;' and '&gt;' respectively - smart action but I don't want that. As a result I see just plain text again - no link. .

So I wonder, is it possible in some way to get email which will contain links? May be my method of generating email body programmatically is not pretty good and some of you know better ways to accomplish that - please advice. Also may be you can advice how can I build merge template without programmatical building of its body and having links in it at the same time?

Any advices/comments/links are apreciated