I want to build an Apex trigger to do something very simple.

We are using Eloqua for marketing automation and we have it integrated with SF. I want to be able to build a view where within minutes of someone performing some activity - opening an e-mail, visiting our web site, clicking through a link, visiting a landing page, and/or submitting a form - we know it has happened almost immediately when we view the lead or contact in SF.

These activities are captured in Eloqua and passed to SF as a new activity. Right now, we can only get acess to, and sort on, last activity date. There is no way to sort based on last activity date AND time. SF will not give us access to last activity time, even though it is captured and recorded by SF AND YOU CAN SEE IT IN LEADS AND CONTRACTS!!!

After weeks and weeks of back and forth with SF support, they tell us we need to build a trigger that will update a custom field when Eloqua sends an activity to SF ... 2 triggers probably, since we need to build one for a lead and one for a contact.

In other words, every time an activity is sent to a lead or contact in SF from Eloqua, we update a custom field with the date and time of that activity being created in SF.

A custom formula field will not work.

We don't have much experience (actually none at all) building Apex triggers, and this is likely the only one we'll need for a long while. Does anyone have any sample code for doing something like this? While inexperienced in Apex, we're good at taking plaguarized code and morphing it to our needs! Ha!

Would also like to connect with Apex developers who might be able to do this for us cost effectively.

:-)

Thanks!

-- Mark

I want to build an Apex trigger to do something very simple.

We are using Eloqua for marketing automation and we have it integrated with SF.  I want to be able to build a view where within minutes of someone performing some activity - opening an e-mail, visiting our web site, clicking through a link, visiting a landing page, and/or submitting a form - we know it has happened almost immediately when we view the lead or contact in SF.

These activities are captured in Eloqua and passed to SF as a new activity.  Right now, we can only get acess to, and sort on, last activity date.  There is no way to sort based on last activity date AND time.  SF will not give us access to last activity time, even though it is captured and recorded by SF AND YOU CAN SEE IT IN LEADS AND CONTRACTS!!!

After weeks and weeks of back and forth with SF support, they tell us we need to build a trigger that will update a custom field when Eloqua sends an activity to SF ... 2 triggers probably, since we need to build one for a lead and one for a contact.

In other words, every time an activity is sent to a lead or contact in SF from Eloqua, we update a custom field with the date and time of that activity being created in SF.

A custom formula field will not work.

We don't have much experience (actually none at all) building Apex triggers, and this is likely the only one we'll need for a long while.  Does anyone have any sample code for doing something like this?  While inexperienced in Apex, we're good at taking plaguarized code and morphing it to our needs!  Ha!

Thanks!

-- Mark

I want to build an Apex trigger to do something very simple.

We are using Eloqua for marketing automation and we have it integrated with SF. I want to be able to build a view where within minutes of someone performing some activity - opening an e-mail, visiting our web site, clicking through a link, visiting a landing page, and/or submitting a form - we know it has happened almost immediately when we view the lead or contact in SF.

These activities are captured in Eloqua and passed to SF as a new activity. Right now, we can only get acess to, and sort on, last activity date. There is no way to sort based on last activity date AND time. SF will not give us access to last activity time, even though it is captured and recorded by SF AND YOU CAN SEE IT IN LEADS AND CONTRACTS!!!

After weeks and weeks of back and forth with SF support, they tell us we need to build a trigger that will update a custom field when Eloqua sends an activity to SF ... 2 triggers probably, since we need to build one for a lead and one for a contact.

In other words, every time an activity is sent to a lead or contact in SF from Eloqua, we update a custom field with the date and time of that activity being created in SF.

A custom formula field will not work.

We don't have much experience (actually none at all) building Apex triggers, and this is likely the only one we'll need for a long while. Does anyone have any sample code for doing something like this? While inexperienced in Apex, we're good at taking plaguarized code and morphing it to our needs! Ha!

Would also like to connect with Apex developers who might be able to do this for us cost effectively.

:-)

Thanks!

-- Mark

I want to build an Apex trigger to do something very simple.

We are using Eloqua for marketing automation and we have it integrated with SF.  I want to be able to build a view where within minutes of someone performing some activity - opening an e-mail, visiting our web site, clicking through a link, visiting a landing page, and/or submitting a form - we know it has happened almost immediately when we view the lead or contact in SF.

These activities are captured in Eloqua and passed to SF as a new activity.  Right now, we can only get acess to, and sort on, last activity date.  There is no way to sort based on last activity date AND time.  SF will not give us access to last activity time, even though it is captured and recorded by SF AND YOU CAN SEE IT IN LEADS AND CONTRACTS!!!

After weeks and weeks of back and forth with SF support, they tell us we need to build a trigger that will update a custom field when Eloqua sends an activity to SF ... 2 triggers probably, since we need to build one for a lead and one for a contact.

In other words, every time an activity is sent to a lead or contact in SF from Eloqua, we update a custom field with the date and time of that activity being created in SF.

A custom formula field will not work.

We don't have much experience (actually none at all) building Apex triggers, and this is likely the only one we'll need for a long while.  Does anyone have any sample code for doing something like this?  While inexperienced in Apex, we're good at taking plaguarized code and morphing it to our needs!  Ha!

Thanks!

-- Mark