Hi,
For this requirement use aggregate result to easily and effectively manage the sum of quantities for triggering opportunity line items record.
Create a new account instance , populate id and the quantity field then add the account instance to an account;s list and update that list.
You can fetch the account id and related quantity using following snippet
//OppIds is the set of opportunity Ids of triggering opportunity line item records
for (AggregateResult arr : [select Sum(Quantity), OpportunityId,Opportunity.AccountId from OpportunityLineItem where OpportunityId in :OppIds Group By Opportunity.AccountId,OpportunityId]) {
Account Acc= new Account();
Acc.id =String.valueof(arr.get('AccountId'));
Acc.custom_field_for_quantity__c =String.valueOf(arr.get('expr0'));
}
Feed
- Recent Activity
- Created Date
- Questions with an Accepted Answer
- Questions with No Accepted Answer
- Unanswered Questions
Hi Filip,
I think that you can have the stationary asset (or any other emission source) registered, and the way of "ignoring" it is with the "0" energy use record. So if the store is in "building" stage, you can register as new StatAsset, and will not have Energy Use. In that way, you have it in the inventory and will not produce carbonfootprint.
Hi Brandon Sowers,I solved this by removing the Entry Criteria. It said that a criteria won't required, but it actually fails if one is present.Hope this helps you!Please accept my solution as Best Answer if my reply was helpful. It will make it available for other as the proper solution. Thanks and Regards Sandhya
I have a Filter widget setup to filter a table.
The 'Campaign' column I am filtering by has string values with commas such as:
- Greater Asia - Australia, Thailand, Malaysia, Indonesia - FY25Q1 - CM019208 - LF FY25 Portfolio - LF FY25 Pro Latex Campaign GAI_V1
- Greater Asia - Australia, Thailand, Malaysia, Indonesia - FY25Q1 - CM019208 - LF FY25 Portfolio - LF FY25 Pro Latex Campaign GAI_V2
- Greater Asia - Australia, Thailand, Malaysia, Indonesia - FY25Q1 - CM019208 - LF FY25 Portfolio - LF FY25 Pro Latex Campaign GAI_V3
I would like our teams to be able to use the filter to search for "Greater Asia - Australia, Thailand, Malaysia, Indonesia - FY25Q1 - CM019208 - LF FY25 Portfolio - LF FY25 Pro Latex Campaign GAI_V"
so they can pull up all versions of the same 'Campaign'.
For whatever reason though, the commas are making it so that nothing shows up in the search results in the filter then the above search string is copy and pasted into the search bar on the filter. Any way around this? Can I put the whole string in quotes to avoid the commas nulling out the filter selections or something like that?
Try searching without the commas and see if they show up. This might be one of those characters that get stripped before loading into the database. This happens for quotes as well.
Hi SF Community,
I have added the submit for approval button onto my page layout and getting this message on testing: No applicable approval process was found.
Is there a way to link my approval process to the submit for approval button ? Would this be linking the flow I have created for the approval process to the button ?
Many Thanks
Mike
Hello,
Are you sure the record meets the initial criteria of the approval?
i am unable to click on record Details. A warning box keeps on appearing saying "Select an insertion point for the component" I have already upgraded the Properties pan to start the Dynamic Forms migration wizard.
What to do
Hello, I’m getting the error "Too many SOQL queries: 101" while executing a bulk update operation in Salesforce. What is the cause of this, and how can I fix it? Best Regard, Dona
Hi,
This error occurs when your Apex code exceeds the governor limit of 100 synchronous SOQL queries in a single transaction.
To fix the error "Too many SOQL queries: 101" :
1.
Bulkify Your Code using Maps and collections2. Implement Batch Apex and Future Methods
3. Avoid DML operations inside loops
4. Use static variables to prevent recursive triggersThanks
My org is looking to track goals related to Activities for users. We will want to track visits, phone calls, solicitations, and possibly other metrics down the line. The goals will be different for different users so need flexibility with assigning the targets. Has anyone done this and have ideas to share?
This is something that I built for measuring Sales Quota Attainment, with a few tweaks it could be expanded to other Objects
Tips & Tricks: Creating Sales vs. Goal Reports and Dashboards
Hi everyone,
A few users have been encountering the following error today while using the FSL app. We followed the instructions provided in this link:
https://help.salesforce.com/s/articleView?id=000981141&type=1
, but unfortunately, it didn't resolve the issue for the users.
What else can we try?