Rewards Network has an exciting opportunity for a Jr. Developer, Salesforce.com to join our growing team of IT professionals! Rewards Network (NASDAQ: DINE), headquartered in Chicago, IL, operates the leading dining rewards programs in North America by marketing participating restaurants to members of these programs and by providing incentives to members to dine at these restaurants. In addition to operating the dining rewards program of leading airline frequent flyer programs, hotel frequent-stay programs, retailer shopping programs, college savings programs, and other affinity organizations, the Company offers its own dining rewards program, iDine® at www.idine.com.
Summary
The Junior Developer’s role is to work with business partners to realize the full capability of Salesforce.com CRM. They will contribute to all technical aspects of projects developed and perform detailed analysis of business and technical requirements.
Essential Duties and Responsibilities
Work with business partners to realize the full capabilities of Salesforce.com CRM
Provide operational support to the Salesforce.com system
Contribute to all technical aspects of projects developed
Perform detailed analysis of business and technical requirements
Write supporting documentation supporting business needs
Create development and integration plans
Position Requirements
Formal Education & Certification:
Bachelor degree in the field of computer science, information technology, or business administration strongly preferred
Knowledge & Experience:
Must have minimum 4+ years of total IT experience including 2+ years of SFDC
Experience with Salesforce.com Administration (User, Roles, Profile, Workflows, Approval Process, Relationship Object, Page Layout, Validation rules, Field sharing and Security, Company profile, Email2Case, MassEmail)
Prior experience with Force.com developer toolkit - Apex, Visualforce, Force.com IDE, Force.com Migration Tool, Web Services/SOA & Metadata APIs
Prior experience with data migration and ETL tools such as Informatica
Must have good knowledge and working experience in development & implementation of multiple SFDC projects
Strong development, and unit testing skills
Strong web development skills including CSS, JavaScript, XML, HTML, SOAP, XML, JavaScript, AJAX
Familiar with Services Oriented Design Principles (SOA)
Ability with Object Oriented Development Skills (Java, .Net)
Fundamental understanding of Web Services
SQL, RDBMS experience preferred
Salesforce.com Certified Force.com Developer desired, but not required
Personal Attributes:
Ability to work in a fast-paced environment
Ability to manage priorities judiciously
Excellent written and oral, presentation, and written communication skills
Excellent customer service and interpersonal skills
Ability to articulate ideas to both technical and non-technical audiences
Exceptionally self-motivated and directed
Keen attention to detail
Superior analytical, evaluative, and problem-solving abilities
I have apex terriger and within trigger I have logic and three query which is like this.
List<Account> allAccount = [Select Market_Territory__c,RecordTypeId,RecordType.Name,Territory_Affiliate__c,County_and_State_Combo__c,Affiliate_Sales_Manager__c, Id,Selling_Territory__c From Account where Id in :putallAccount.KeySet()];
List<Affiliate_Management__c> affiliateManagement = [Select Name, Id From Affiliate_Management__c where Name IN :affiliateName];
List<Territory_Market__c> territoryMarket = [Select t.Territory_State__c, t.Territory_Market__c, t.Territory_County__c,t.Name,t.Market_Category__c,
t.Parent_Market__r.Name,t.Parent_Market__r.Market_Category__c, t.Parent_Market__c,t.County_State_Combo__c From Territory_Market__c t
where t.Name in : account];
I create html component on home page where someoen put text in textbox and hit go buttton,case will be created.
Issue: It says invalid session Id. (So I used login method nad gave my username and password) but when it create case ,it define my name for owner of case. I need owner who is logged in.
How to get logged in user info in html home component.
Here is my code.
<script src="/soap/ajax/14.0/connection.js"></script>
<script language="JavaScript" type="text/javascript">
function submitSearchForm(){
var searchField = document.getElementById('advsearchfield');
var result = sforce.connection.login("myname@xxx.com.test", "password");
var newCase = new sforce.SObject("Case");
newCase.Description =searchField.value;
newCase.Status="Closed";
newCase.Origin="Hot Button";
newCase.Subject="General Inquiry";
result = sforce.connection.create([newCase]);if (result[0].getBoolean("success")) {alert("new account created with id " + result[0].id);} else {alert("failed to create account " + result[0]);}}
</script>
<form name="advsrch" method="post" onsubmit="return submitSearchForm();"><input class="searchTextBox" id="advsearchfield" maxlength="80" size="18" name="sbstr"> <input class="btn" value=" Go! " type="submit"></form>
trigger FindMarketTerritoryFromMarket on Territory_Market__c (after insert, after update) {
String dealerProspect = 'Dealer - Prospect'; //dealer prospect recType1
String dealerCustomer = 'Dealer - Customer'; // dealer cusomter recType2
String formerCustomer = 'Dealer - Former Customer';
Map<Id,Territory_Market__c> territoryMarket= new Map<Id,Territory_Market__c>();
for(Territory_Market__c t : Trigger.new) {
if (System.Trigger.isInsert){
if(t.Parent_Market__c!=null && t.Territory_County__c!=null && t.Territory_State__c!=null) {
territoryMarket.put(t.Id,t);
system.debug('new parent name');
}
}else if(t.Parent_Market__c!=Trigger.oldMap.get(t.Id).Parent_Market__c){
territoryMarket.put(t.Id,t);
system.debug('new parent name updated');
}
}
/***********************************/
List<String> countyCombo = new List<String>();
List<String> county =new List<String>();
for(Id idsOfTerritory : territoryMarket.KeySet()){
if(territoryMarket.get(idsOfTerritory).County_State_Combo__c!=null)
countyCombo.add(territoryMarket.get(idsOfTerritory).County_State_Combo__c);
county.add(territoryMarket.get(idsOfTerritory).Territory_County__c);
}
List<Account> iterateAccount = [Select a.Market_Territory__c,a.Id,a.Name,a.County_and_State_Combo__c From Account a where
(a.RecordType.Name =: dealerProspect or a.RecordType.Name=:formerCustomer) and
a.ShippingState!=null and a.Shipping_County__c !=null and
a.County_and_State_Combo__c in :countyCombo and
a.Shipping_County__c in:county and
a.RecordTypeId!=null and
a.Territory_Affiliate__c like'%Cars.com%'];
List<Territory_Market__c> newMarket = [select t.Parent_Market__r.Name,t.Parent_Market__r.Market_Category__c,t.County_State_Combo__c,t.Id From Territory_Market__c t where t.Id in: territoryMarket.KeySet()];
List<Account> updateAccount = new List<Account>();
for(Territory_Market__c market : newMarket){
system.debug('account size'+iterateAccount.size());
for(Integer i=0;i<iterateAccount.size();i++){
system.debug('name'+ market.Parent_Market__r.Name+','+ market.Parent_Market__c);
String name = market.Parent_Market__r.Name;
if(iterateAccount.get(i).County_and_State_Combo__c==market.County_State_Combo__c){
if(name!=null && name!=''&& name.contains('/')){
List <String> nameOfTerritory = name.split('/');
for(Integer j=0;j<nameOfTerritory.size();j++){
if(nameOfTerritory.get(j).contains('Cars.com')){
system.debug('found cars.com market territory'+nameOfTerritory.get(j));
if(nameOfTerritory.get(j).contains('Cars.com - National')){
iterateAccount.get(i).Market_Territory__c = 'Cars.com - National';
iterateAccount.get(i).Market_Category__c = 'I';
}else{
iterateAccount.get(i).Market_Territory__c = nameOfTerritory.get(j);
iterateAccount.get(i).Market_Category__c = market.Parent_Market__r.Market_Category__c;
}
}
}
}else{
system.debug('found cars.com without / market territory'+name);
if(name!=null && name.contains('Cars.com - National')){
iterateAccount.get(i).Market_Territory__c = 'Cars.com - National';
iterateAccount.get(i).Market_Category__c = 'I';
}else{
iterateAccount.get(i).Market_Territory__c = name;
iterateAccount.get(i).Market_Category__c = market.Parent_Market__r.Market_Category__c;
}
}
system.debug('account anme'+iterateAccount.get(i).name+'territory name'+name);
updateAccount.add(iterateAccount.get(i));
}
}
}
update updateAccount;
}
I am getting error while updating parent market in Market Territory object.
Error:Apex trigger FindMarketTerritoryFromMarket caused an unexpected exception, contact your administrator: FindMarketTerritoryFromMarket: execution of AfterUpdate caused by: System.Exception: Too many DML rows: 244: Trigger.FindMarketTerritoryFromMarket: line 80, column 5
I already put update statement outside of for loop nad array list. Can some one point me some work around this?
trigger FindMarketTerritoryFromMarket on Territory_Market__c (before insert, before update) {
Map<Id,Territory_Market__c> territoryMarket= new Map<Id,Territory_Market__c>();
for(Territory_Market__c t : Trigger.new) {
if(t.Parent_Market__c!=Trigger.oldMap.get(t.Id).Parent_Market__c){
territoryMarket.put(t.Id,t);
System.debug(t.Parent_Market__c);
}
}
List<Account> updateAccount = new List<Account>();
Map<Id,String> setAccount= new Map<Id,String>();
for(Id ids : territoryMarket.KeySet()){
List<Account> account = new List<Account>();
account = [Select a.Name From Account a limit 1];
}
}
this is my code. I removed update account code from this.
This is simple code not doing anything yet,still it fails at account = [Select a.Name From Account a limit 1]; line.
It giveme error :
Review all error messages below to correct your data. Apex trigger FindMarketTerritoryFromMarket caused an unexpected exception, contact your administrator: FindMarketTerritoryFromMarket: execution of BeforeUpdate caused by: System.QueryException: Non-selective query against large object type (more than 100000 rows). Consider an indexed filter or contact salesforce.com about custom indexing. Even if a field is indexed a filter might still not be selective when: 1. The filter value includes null (for instance binding with a list that contains null) 2. Data skew exists whereby the number of matching rows is very large (for instance, filtering for a particular foreign key value that occurs many times): Trigger.FindMarketTerritoryFromMarket: line 31, column 8
I tried to pass only not null value still same problem. Then I rmoved all where condition and trying very simple query,still didn't help.
Can someone let me know workaroud for this problem?
I have tabbed view on account page.I have two tabbed name summary(default tab) and oppotunity tab
when user click on summary to oppotunity tab,I need page should befresh.
So when user click on opportunity tab under acocunt tabbed view,and click on any opportunity under this tab new opportunity page will open and when user hit back button,it should be back to opportunity tab.(rihgt now if I user client as switch type in tabpanel,if back to summary tab)
So I tried server as swithch type,it was working fine with refresh but its not working with back and forowrd button of browser.
I am trying to create task when account recrod type is dealer customer and manafer value polulate form null value.
Here is my code.
trigger assignTask on Account (before update) {
List<Task> task = new List<Task>();
for (Integer i = 0; i < Trigger.new.size(); i++) {
//System.debug('territorys'+territory);
if(Trigger.new[i].RecordTypeId=='012300000000AGr'){
if ( (Trigger.old[i].Account_Manager__c != Trigger.new[i].Account_Manager__c)&&(Trigger.old[i].Account_Manager__c ==null)){
String taskname='New Dealer SAP '+Trigger.new[i].Name;
if(taskname.length()>79){
taskname=taskname.substring(0,78);
}
task.add(new Task(
RecordTypeId ='01240000000Ditr',
// RecordTypeId ='012T00000004Uql',
WhatId=Trigger.new[i].Id,
OwnerId=Trigger.new[i].Account_Manager__c,
Subject=taskname
));
}
}
}
}
now if I change first recrod type dealer prospect to dealer customer- and saved it.
after that with same account edit it and add account manager it works fine.It jsut create one task.
anothe senario for update:account which is dealer prospect and I click on change recrod type and choose delaer cusomter as record type and hit next button and add manager info and saved it. It created two task.
Can some one points out why in second senarion it creates two task,while only one time upsate happens.
I wrote trigger ,which work fine manualy but dind't work with data loader.
Here is my code.
trigger RateChangeContract on Account (before update) {
List<Contract_History_Tracker__c> contractHistory = new List<Contract_History_Tracker__c>();
Map<String,Account> newAccount= new Map<String,Account>();
for (Integer i = 0; i < Trigger.new.size(); i++) {
String territory=Trigger.new[i].Selling_Territory__c;
if(territory!=null && territory.length() >3){
territory=territory.substring(0,4);
}
//System.debug('territorys'+territory);
if(Trigger.new[i].RecordTypeId=='012300000000AGr' && Trigger.new[i].Type=='Dealership' &&
territory =='Cars'){
if ( (Trigger.old[i].Current_Contract_Date__c == Trigger.new[i].Current_Contract_Date__c)&&
(Trigger.old[i].Total_Monthly_Rate__c != Trigger.new[i].Total_Monthly_Rate__c)) {
newAccount.put(Trigger.new[i].Id,Trigger.new[i]);
}
}
}
for (Contract_History_Tracker__c contractHist : [Select Current_Rate__c, CreatedDate, Account__c,Id From Contract_History_Tracker__c where Account__c IN : newAccount.KeySet() Order By CreatedDate Desc limit 1]){
Account a= newAccount.get(contractHist.Account__c);
contractHist.Current_Rate__c=a.Total_Monthly_Rate__c;
contractHistory.add(contractHist);
}
update contractHistory;
}
This works fine for first account and after that it didnot update contract hisotry.
I changed my code to this now and its works fine for every account but I have some thoughts that it may with breking limits of trigger as I am writing query inside trigger.
Here is working code.
trigger RateChangeContract on Account (before update) {
//List<Contract_History_Tracker__c> contractHistory = new List<Contract_History_Tracker__c>();
Map<String,Account> newAccount= new Map<String,Account>();
for (Integer i = 0; i < Trigger.new.size(); i++) {
String territory=Trigger.new[i].Selling_Territory__c;
if(territory!=null && territory.length() >3){
territory=territory.substring(0,4);
}
//System.debug('territorys'+territory);
if(Trigger.new[i].RecordTypeId=='012300000000AGr' && Trigger.new[i].Type=='Dealership' &&
territory =='Cars'){
if ( (Trigger.old[i].Current_Contract_Date__c == Trigger.new[i].Current_Contract_Date__c)&&
(Trigger.old[i].Total_Monthly_Rate__c != Trigger.new[i].Total_Monthly_Rate__c)) {
System.debug(Trigger.new[i].Total_Monthly_Rate__c);
Contract_History_Tracker__c contractHistory= [Select Current_Rate__c, CreatedDate, Account__c,Id From Contract_History_Tracker__c where Account__c=:Trigger.new[i].Id Order By CreatedDate Desc limit 1];
contractHistory.Current_Rate__c=Trigger.new[i].Total_Monthly_Rate__c;
update contractHistory;
}
}
}
}
I have two question now.
1. How to fix first code so that it gives same functionality which second code gives.
2. If I am using second code,for how many account tirgger will work fine without breaking limit and giving exception like(dml exception)
I have apex terriger and within trigger I have logic and three query which is like this.
List<Account> allAccount = [Select Market_Territory__c,RecordTypeId,RecordType.Name,Territory_Affiliate__c,County_and_State_Combo__c,Affiliate_Sales_Manager__c, Id,Selling_Territory__c From Account where Id in :putallAccount.KeySet()];
List<Affiliate_Management__c> affiliateManagement = [Select Name, Id From Affiliate_Management__c where Name IN :affiliateName];
List<Territory_Market__c> territoryMarket = [Select t.Territory_State__c, t.Territory_Market__c, t.Territory_County__c,t.Name,t.Market_Category__c,
t.Parent_Market__r.Name,t.Parent_Market__r.Market_Category__c, t.Parent_Market__c,t.County_State_Combo__c From Territory_Market__c t
where t.Name in : account];
Hello,This is Jeff and I represent Elite Innovative Solutions Inc.We currently have an urgent job requirement for our client of position SFDC (Salesforce.com) Developer located at New York, NY / Santa Clara, CA, which you may be suited or interested in. Please do send me a copy of your updated resume and the best time and # to jeff@eliteisinc.com
Job Title : SFDC (Salesforce.com) Developer Location : New York, NY / Santa Clara, CA Duration : FULL TIME
Ideal candidate should have 3 yrs experience in SFDC technical developer , must have experience in APEX , Visual Force and Salesforce.com Integration. Must have good communication skills.
I am updating opportunities while updating the Account Owner.
Opportunities are more than 100 , so i divided into batches of 50
but i am still getting the DML execption while updating 300 records ( max DML satatements should be 6)
\Error: Apex trigger PAMUpdate caused an unexpected exception, contact your administrator: PAMUpdate: execution of BeforeUpdate
caused by: System.Exception: Too many DML rows: 147: Trigger.PAMUpdate: line 63, column 5
I create html component on home page where someoen put text in textbox and hit go buttton,case will be created.
Issue: It says invalid session Id. (So I used login method nad gave my username and password) but when it create case ,it define my name for owner of case. I need owner who is logged in.
How to get logged in user info in html home component.
Here is my code.
<script src="/soap/ajax/14.0/connection.js"></script>
<script language="JavaScript" type="text/javascript">
function submitSearchForm(){
var searchField = document.getElementById('advsearchfield');
var result = sforce.connection.login("myname@xxx.com.test", "password");
var newCase = new sforce.SObject("Case");
newCase.Description =searchField.value;
newCase.Status="Closed";
newCase.Origin="Hot Button";
newCase.Subject="General Inquiry";
result = sforce.connection.create([newCase]);if (result[0].getBoolean("success")) {alert("new account created with id " + result[0].id);} else {alert("failed to create account " + result[0]);}}
</script>
<form name="advsrch" method="post" onsubmit="return submitSearchForm();"><input class="searchTextBox" id="advsearchfield" maxlength="80" size="18" name="sbstr"> <input class="btn" value=" Go! " type="submit"></form>
Does anyone know how I'd go about creating a trigger to convert a lead to an account contact and oppty, based upon a field in the lead? For example, A lead score of > 30, I'd like to trigger the lead to automatically convert, and kick off a notification email.
trigger FindMarketTerritoryFromMarket on Territory_Market__c (before insert, before update) {
Map<Id,Territory_Market__c> territoryMarket= new Map<Id,Territory_Market__c>();
for(Territory_Market__c t : Trigger.new) {
if(t.Parent_Market__c!=Trigger.oldMap.get(t.Id).Parent_Market__c){
territoryMarket.put(t.Id,t);
System.debug(t.Parent_Market__c);
}
}
List<Account> updateAccount = new List<Account>();
Map<Id,String> setAccount= new Map<Id,String>();
for(Id ids : territoryMarket.KeySet()){
List<Account> account = new List<Account>();
account = [Select a.Name From Account a limit 1];
}
}
this is my code. I removed update account code from this.
This is simple code not doing anything yet,still it fails at account = [Select a.Name From Account a limit 1]; line.
It giveme error :
Review all error messages below to correct your data. Apex trigger FindMarketTerritoryFromMarket caused an unexpected exception, contact your administrator: FindMarketTerritoryFromMarket: execution of BeforeUpdate caused by: System.QueryException: Non-selective query against large object type (more than 100000 rows). Consider an indexed filter or contact salesforce.com about custom indexing. Even if a field is indexed a filter might still not be selective when: 1. The filter value includes null (for instance binding with a list that contains null) 2. Data skew exists whereby the number of matching rows is very large (for instance, filtering for a particular foreign key value that occurs many times): Trigger.FindMarketTerritoryFromMarket: line 31, column 8
I tried to pass only not null value still same problem. Then I rmoved all where condition and trying very simple query,still didn't help.
Can someone let me know workaroud for this problem?
I am trying to create task when account recrod type is dealer customer and manafer value polulate form null value.
Here is my code.
trigger assignTask on Account (before update) {
List<Task> task = new List<Task>();
for (Integer i = 0; i < Trigger.new.size(); i++) {
//System.debug('territorys'+territory);
if(Trigger.new[i].RecordTypeId=='012300000000AGr'){
if ( (Trigger.old[i].Account_Manager__c != Trigger.new[i].Account_Manager__c)&&(Trigger.old[i].Account_Manager__c ==null)){
String taskname='New Dealer SAP '+Trigger.new[i].Name;
if(taskname.length()>79){
taskname=taskname.substring(0,78);
}
task.add(new Task(
RecordTypeId ='01240000000Ditr',
// RecordTypeId ='012T00000004Uql',
WhatId=Trigger.new[i].Id,
OwnerId=Trigger.new[i].Account_Manager__c,
Subject=taskname
));
}
}
}
}
now if I change first recrod type dealer prospect to dealer customer- and saved it.
after that with same account edit it and add account manager it works fine.It jsut create one task.
anothe senario for update:account which is dealer prospect and I click on change recrod type and choose delaer cusomter as record type and hit next button and add manager info and saved it. It created two task.
Can some one points out why in second senarion it creates two task,while only one time upsate happens.
I wrote trigger ,which work fine manualy but dind't work with data loader.
Here is my code.
trigger RateChangeContract on Account (before update) {
List<Contract_History_Tracker__c> contractHistory = new List<Contract_History_Tracker__c>();
Map<String,Account> newAccount= new Map<String,Account>();
for (Integer i = 0; i < Trigger.new.size(); i++) {
String territory=Trigger.new[i].Selling_Territory__c;
if(territory!=null && territory.length() >3){
territory=territory.substring(0,4);
}
//System.debug('territorys'+territory);
if(Trigger.new[i].RecordTypeId=='012300000000AGr' && Trigger.new[i].Type=='Dealership' &&
territory =='Cars'){
if ( (Trigger.old[i].Current_Contract_Date__c == Trigger.new[i].Current_Contract_Date__c)&&
(Trigger.old[i].Total_Monthly_Rate__c != Trigger.new[i].Total_Monthly_Rate__c)) {
newAccount.put(Trigger.new[i].Id,Trigger.new[i]);
}
}
}
for (Contract_History_Tracker__c contractHist : [Select Current_Rate__c, CreatedDate, Account__c,Id From Contract_History_Tracker__c where Account__c IN : newAccount.KeySet() Order By CreatedDate Desc limit 1]){
Account a= newAccount.get(contractHist.Account__c);
contractHist.Current_Rate__c=a.Total_Monthly_Rate__c;
contractHistory.add(contractHist);
}
update contractHistory;
}
This works fine for first account and after that it didnot update contract hisotry.
I changed my code to this now and its works fine for every account but I have some thoughts that it may with breking limits of trigger as I am writing query inside trigger.
Here is working code.
trigger RateChangeContract on Account (before update) {
//List<Contract_History_Tracker__c> contractHistory = new List<Contract_History_Tracker__c>();
Map<String,Account> newAccount= new Map<String,Account>();
for (Integer i = 0; i < Trigger.new.size(); i++) {
String territory=Trigger.new[i].Selling_Territory__c;
if(territory!=null && territory.length() >3){
territory=territory.substring(0,4);
}
//System.debug('territorys'+territory);
if(Trigger.new[i].RecordTypeId=='012300000000AGr' && Trigger.new[i].Type=='Dealership' &&
territory =='Cars'){
if ( (Trigger.old[i].Current_Contract_Date__c == Trigger.new[i].Current_Contract_Date__c)&&
(Trigger.old[i].Total_Monthly_Rate__c != Trigger.new[i].Total_Monthly_Rate__c)) {
System.debug(Trigger.new[i].Total_Monthly_Rate__c);
Contract_History_Tracker__c contractHistory= [Select Current_Rate__c, CreatedDate, Account__c,Id From Contract_History_Tracker__c where Account__c=:Trigger.new[i].Id Order By CreatedDate Desc limit 1];
contractHistory.Current_Rate__c=Trigger.new[i].Total_Monthly_Rate__c;
update contractHistory;
}
}
}
}
I have two question now.
1. How to fix first code so that it gives same functionality which second code gives.
2. If I am using second code,for how many account tirgger will work fine without breaking limit and giving exception like(dml exception)
I wonder if it is possible to go back to the tab that you were previously on if you access a related list from the tabbed layout.
Like I have two tab on page layout. first is summary and second is opportunity.
when user click on opportunity tab and click on any of opportunity form tabeed page,it will redirect to opportunity page.when user click back button on browser,the tabeed apge view summary tab.
I want when user click back button,opportunity page should be redirect to opportunity tab instead of summary tab.
