-
ChatterFeed
-
0Best Answers
-
1Likes Received
-
0Likes Given
-
15Questions
-
19Replies
Send emails to all approvers when a approval is rejected
This should only be sent to the people who are in the approval path and maybe they had approved before.
Also, please consider the option of where the approver is manually chosen and not just the static assigned approver.
Thanks.
- Kenn K.
- June 09, 2016
- Like
- 0
- Continue reading or reply
Deleting/Deactivate case recordtype
I have deactivated one the recordtype we have and I still see the option when I create a new case i.e. under 'Available cases record types'
I deleted it without any issues and it just got rid of the name. I now see the id of the deleted recordtype.
Is there something I'm missing here to remove it from the available case record types?
- Kenn K.
- February 26, 2016
- Like
- 0
- Continue reading or reply
Updating single sign on certificate to work with ADFS
As far as I know, is it just as easy as uploading the new Identity Provider Certificate and we are all so? Does IT need to do anything on their end i.e. do something with the new metadata xml file after the update?
Thanks.
- Kenn K.
- February 10, 2016
- Like
- 1
- Continue reading or reply
Update Object with unique values from Child object using Aggregate result
The trigger runs on quote, queries QuoteLine for unique values and update the Quote with the unique values. This is what I have so far but it doesn't seem to be working;
trigger SB_QuoteAdditionalUpdates on SBQQ__Quote__c (before insert, before update) { Set<Id> quoteIds = new Set<Id>(); for (SBQQ__Quote__c quotes : Trigger.new) { quoteIds.add(quotes.id); } List<AggregateResult> uniqueCountries = ([SELECT Country_Operational_Date__c FROM SBQQ__QuoteLine__c WHERE SBQQ__Quote__c IN:quoteIds AND country_code__c <> null AND Employee_CountFormula__c <> null GROUP BY Country_Operational_Date__c]); if(uniqueCountries.Size()>0 ){ for (AggregateResult uniqueCountry : uniqueCountries){ quotes.Operational_Start_Date__c = String.valueOf(uniqueCountry.get('Country_Operational_Date__c')); system.debug('======>'+String.valueOf(uniqueCountry.get('Country_Operational_Date__c'))); } } }
When I make the for loop run through the aggregate result (not optimized/bulkified), it updates the quote but it's only updating with one of the unique values and the quote might have had 3 unique values.
- Kenn K.
- January 21, 2016
- Like
- 0
- Continue reading or reply
Update values from Aggregate Result Query
The trigger runs on quote, queries QuoteLine for unique values and update the Quote with the unique values. This is what I have so far but it doesn't seem to be working;
trigger SB_QuoteAdditionalUpdates on SBQQ__Quote__c (before insert, before update) { Set<Id> quoteIds = new Set<Id>(); for (SBQQ__Quote__c quotes : Trigger.new) { quoteIds.add(quotes.id); } List<AggregateResult> uniqueCountries = ([SELECT Country_Operational_Date__c FROM SBQQ__QuoteLine__c WHERE SBQQ__Quote__c IN:quoteIds AND country_code__c <> null AND Employee_CountFormula__c <> null GROUP BY Country_Operational_Date__c]); if(uniqueCountries.Size()>0 ){ for (AggregateResult uniqueCountry : uniqueCountries){ quotes.Operational_Start_Date__c = String.valueOf(uniqueCountry.get('Country_Operational_Date__c')); system.debug('======>'+String.valueOf(uniqueCountry.get('Country_Operational_Date__c'))); } } }
When I make the for loop run through the aggregate result (not optimized/bulkified), it updates the quote but it's only updating with one of the unique values and the quote might have had 3 unique values.
- Kenn K.
- January 21, 2016
- Like
- 0
- Continue reading or reply
Direction in solving multi-object query/Update
I have 2 objects ("Quote" and "QuoteLine") and a custom setting called "ServiceDate__c" which basically stores 2 information, Country__c and numberOfDays__c. The goal of the trigger is to query aCountry__c field on the QuoteLine object, compare it to country field on the ServiceDate__c object to get the number.
Finally, since there will be a number of closeDate__c fields on the QuoteLine, I would like to query only the UNIQUE CloseDate__c values and update the Quote object.
Sample code would be appreciated.
Tl:dr. Get unique date values on the Quote after calculation happens on the Quoteline object that references a custom setting for more information.
Here is what I have so a far;
trigger SB_QuoteAdditionalUpdates on SBQQ__Quote__c (before insert, before update) { Set<id> QuoteIds = New Set<id>(); for (SBQQ__Quote__c SBQuotes : trigger.new){ QuoteIds.add(SBQuotes.id); SBQQ__QuoteLine__c[] SBQuoteLines = [Select country__c, country_code__c, close_date__c, country_employee_construct__c, Employee_CountFormula__c from SBQQ__QuoteLine__c where id IN: QuoteIds]; if(SBQuoteLines.size()>0){ for(SBQQ__QuoteLine__c SBQuoteLine : SBQuoteLines ){ map<id, OperationalStartDate__c> NumberOfDaysMap = new map <id, OperationalStartDate__c>([select name, Number_Of_Days__c from OperationalStartDate__c where name =: SBQuoteLine.country__c ]); } } } }
- Kenn K.
- January 20, 2016
- Like
- 0
- Continue reading or reply
Does SF support two ADFS servers in different forests providing SSO?
Thanks,
K
- Kenn K.
- May 15, 2014
- Like
- 0
- Continue reading or reply
Javascript alert on button click
I want to prevent users from being redirected when they click a button and picklist value is false.
I have a custom button on Opportunity related list on account. If the value of Account type is 'OLD', users should get an error message and not redirect the page. If it's anything else, they can be redirected opportunity.
What is the best way of going about this?
Thanks, -Ken
- Kenn K.
- July 03, 2013
- Like
- 0
- Continue reading or reply
How do I create a webservice that sends record information as xml?
I want to regularly send all account information from salesforce to another external system that will accept it as xml. I have the end point url for the external system and the fields that needs to be sent.
How do I go about creating this? I assume I will have to schedule this to run daily at a particular time.
Please help.
Thanks.
- Kenn K.
- May 29, 2013
- Like
- 0
- Continue reading or reply
Inserting data to audit field like created date for test class
I am creating a test class and the scenario I am testing requires an older date for the created date. I know CreatedDate is an audit field and I can't write to it. Is there a workaround I could use for writing my test class?
Thanks.
- Kenn K.
- March 26, 2013
- Like
- 0
- Continue reading or reply
Creating a multi-step approval process
Hi there,
Does anyone know of a way of creating a multi-step approval process? I.e. When one approver approves it, case is sent to the next approver ( approver 2) then when approver 2 approves it, it goes to the last approver .
- Records enters entry criteria
- Approver 1 approves then
- Approver 2 approves after approver 1 has approved then
- Approver 3 approves after approver 2 has approved.
- Finalize.
Please let me know if this is possible. I am not sure if the appall process updates a specific field in the case object on every approval step.
Thanks.
- Kenn K.
- March 18, 2013
- Like
- 0
- Continue reading or reply
Extracting number values in a text field then summing up
Hi there,
I have this field that gets populated by an external service and I want to extract the number values from it then sum the numbers up.
For instance, see the text below
United Kingdom: 3, Ireland: 1, Netherlands: 1, Spain: 2, Australia: 1
I would like to extract 3,1,1,2,1 and sum them individually to have 8. i.e. 3+1+1+2+1 = 8.
Thanks.
- Kenn K.
- March 13, 2013
- Like
- 0
- Continue reading or reply
Prevent Parent Account to be deleted if it has a child account
I am trying to figure out the best way to prevent users from deleting and Account if it has a child account.
So the scenario will be the users will have to delete all the child accounts first before they can delete the parent.
Any guidance will be highly appreciated.
Thanks.
- Kenn K.
- June 28, 2012
- Like
- 0
- Continue reading or reply
I would like to retrieve a value in a relationship query
I have this query,
list<Contact> relatedContacts = [select id, AccountId, (Select Id From Cases) from Contact where id IN :contactIds ];
The thing is, I want to get the value of the cases Id so I can use it to update another field.
How do I go about getting this value?
Thanks,
-K
- Kenn K.
- February 29, 2012
- Like
- 0
- Continue reading or reply
Query Opportunity.ownerId from Quotes in a trigger
Hi There,
I would like to query for the opportunity.ownerId of the opportunity from a quote using a trigger. (I.e. who is the owner of the opportunity tied to the current quote) How do I go about doing this in a trigger?
Can't seem to get anywhere. Please explain what you did a little.
Thanks a lot!
- Kenn K.
- September 08, 2011
- Like
- 0
- Continue reading or reply
Updating single sign on certificate to work with ADFS
As far as I know, is it just as easy as uploading the new Identity Provider Certificate and we are all so? Does IT need to do anything on their end i.e. do something with the new metadata xml file after the update?
Thanks.
- Kenn K.
- February 10, 2016
- Like
- 1
- Continue reading or reply
Deleting/Deactivate case recordtype
I have deactivated one the recordtype we have and I still see the option when I create a new case i.e. under 'Available cases record types'
I deleted it without any issues and it just got rid of the name. I now see the id of the deleted recordtype.
Is there something I'm missing here to remove it from the available case record types?
- Kenn K.
- February 26, 2016
- Like
- 0
- Continue reading or reply
Direction in solving multi-object query/Update
I have 2 objects ("Quote" and "QuoteLine") and a custom setting called "ServiceDate__c" which basically stores 2 information, Country__c and numberOfDays__c. The goal of the trigger is to query aCountry__c field on the QuoteLine object, compare it to country field on the ServiceDate__c object to get the number.
Finally, since there will be a number of closeDate__c fields on the QuoteLine, I would like to query only the UNIQUE CloseDate__c values and update the Quote object.
Sample code would be appreciated.
Tl:dr. Get unique date values on the Quote after calculation happens on the Quoteline object that references a custom setting for more information.
Here is what I have so a far;
trigger SB_QuoteAdditionalUpdates on SBQQ__Quote__c (before insert, before update) { Set<id> QuoteIds = New Set<id>(); for (SBQQ__Quote__c SBQuotes : trigger.new){ QuoteIds.add(SBQuotes.id); SBQQ__QuoteLine__c[] SBQuoteLines = [Select country__c, country_code__c, close_date__c, country_employee_construct__c, Employee_CountFormula__c from SBQQ__QuoteLine__c where id IN: QuoteIds]; if(SBQuoteLines.size()>0){ for(SBQQ__QuoteLine__c SBQuoteLine : SBQuoteLines ){ map<id, OperationalStartDate__c> NumberOfDaysMap = new map <id, OperationalStartDate__c>([select name, Number_Of_Days__c from OperationalStartDate__c where name =: SBQuoteLine.country__c ]); } } } }
- Kenn K.
- January 20, 2016
- Like
- 0
- Continue reading or reply
Javascript alert on button click
I want to prevent users from being redirected when they click a button and picklist value is false.
I have a custom button on Opportunity related list on account. If the value of Account type is 'OLD', users should get an error message and not redirect the page. If it's anything else, they can be redirected opportunity.
What is the best way of going about this?
Thanks, -Ken
- Kenn K.
- July 03, 2013
- Like
- 0
- Continue reading or reply
How do I create a webservice that sends record information as xml?
I want to regularly send all account information from salesforce to another external system that will accept it as xml. I have the end point url for the external system and the fields that needs to be sent.
How do I go about creating this? I assume I will have to schedule this to run daily at a particular time.
Please help.
Thanks.
- Kenn K.
- May 29, 2013
- Like
- 0
- Continue reading or reply
Inserting data to audit field like created date for test class
I am creating a test class and the scenario I am testing requires an older date for the created date. I know CreatedDate is an audit field and I can't write to it. Is there a workaround I could use for writing my test class?
Thanks.
- Kenn K.
- March 26, 2013
- Like
- 0
- Continue reading or reply
Extracting number values in a text field then summing up
Hi there,
I have this field that gets populated by an external service and I want to extract the number values from it then sum the numbers up.
For instance, see the text below
United Kingdom: 3, Ireland: 1, Netherlands: 1, Spain: 2, Australia: 1
I would like to extract 3,1,1,2,1 and sum them individually to have 8. i.e. 3+1+1+2+1 = 8.
Thanks.
- Kenn K.
- March 13, 2013
- Like
- 0
- Continue reading or reply
I would like to retrieve a value in a relationship query
I have this query,
list<Contact> relatedContacts = [select id, AccountId, (Select Id From Cases) from Contact where id IN :contactIds ];
The thing is, I want to get the value of the cases Id so I can use it to update another field.
How do I go about getting this value?
Thanks,
-K
- Kenn K.
- February 29, 2012
- Like
- 0
- Continue reading or reply
What is the Integration In salesforce?
Hi all,
I am new to Salesforce.
What is the " Integration" in Salesforce.com, What we can do in Integration?
Can you please Help Me..
Thanks for your Help..
- ajaykeka
- February 29, 2012
- Like
- 0
- Continue reading or reply
Query Opportunity.ownerId from Quotes in a trigger
Hi There,
I would like to query for the opportunity.ownerId of the opportunity from a quote using a trigger. (I.e. who is the owner of the opportunity tied to the current quote) How do I go about doing this in a trigger?
Can't seem to get anywhere. Please explain what you did a little.
Thanks a lot!
- Kenn K.
- September 08, 2011
- Like
- 0
- Continue reading or reply
Convert To Title Case
Is there any way to convert String /Sentence to Title Case in Apex.
Convert From
"this is a sentence"
To
"This Is A Sentence"
Thanks
R
- nagen
- April 06, 2008
- Like
- 0
- Continue reading or reply