Salesforce User Questions Archives - gettectonic.com
Viewing All Hard and Soft Credits for Household Accounts

Viewing All Hard and Soft Credits for Household Accounts

Subject: Inquiry About Viewing All Hard and Soft Credits for Household Accounts What’s the best way to view a complete list of all hard and soft credits associated with a household account? I understand that the NPSP customizable rollups allow us to aggregate soft credit totals based on the Opportunity Contact Roles for each contact in a household, which is useful but can sometimes be inaccurate due to data entry errors in assigning the correct roles. Additionally, filtered opportunity-related lists on the contact page can show different soft and hard credits assigned to individual contacts. While helpful, this can be confusing for users who prefer to see all information at the household account level and may overlook the contact details. What I’m looking for is a comprehensive list at the account level that includes all opportunities linked to every contact in a household, regardless of the Opportunity Contact Roll type. Essentially, I need to see every soft and hard credit received by all household members. I came across a post by Megan Moorehead from over three years ago titled “Soft Credit Opportunities Related List on Household.” She replied to her own post a couple of months later (on September 10, 2021), but I only partially understand her solution. Before I delve deeper into her suggestions, I wanted to check if there are any simpler or more recent out-of-the-box options added to NPSP. I’m flexible regarding how to obtain this full list of all hard and soft credits related to household members—it could be through a related list or a report. I believe this is a common need among many organizations, so any suggestions on how you’re generating this type of list would be greatly appreciated. Response: You’re correct that this isn’t available out of the box. The challenge arises because opportunities aren’t always directly tagged to the household. You might consider using a screen flow to gather opportunities from household members and display them on the account page in a data table. Alternatively, you could create a custom field on opportunities (populated by a record-triggered flow) called “Household,” which would link opportunities back to the household based on the contact’s association at the time of creation. This would allow for a separate related list on the account page. One thing to keep in mind: since soft credits are only assigned via Contact Roles, if the issue is that Contact Roles are missing, then Megan’s Mass Action Scheduler solution—or any solution—won’t help. Those opportunities will not appear in the household list, except for those where someone in the household received hard credit. Like Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Health Cloud Brings Healthcare Transformation Following swiftly after last week’s successful launch of Financial Services Cloud, Salesforce has announced the second installment in its series Read more Alphabet Soup of Cloud Terminology As with any technology, the cloud brings its own alphabet soup of terms. This insight will hopefully help you navigate Read more

Read More
Ingest Salesforce Data to Microsoft Fabric

Ingest Salesforce Data to Microsoft Fabric

I’m using Dataflow Gen 2 in Microsoft Fabric to ingest data from Salesforce via the Salesforce Objects connector, which is authenticated through an Organizational Account (OAuth 2.0). However, unlike Azure Synapse’s SalesforceV2 type, this connector doesn’t offer fields to input a client ID, client secret, or environment URL. Here are the key concerns: 1. Reauthentication Requirement Will reauthentication be required regularly (e.g., after access tokens expire), and how often will that occur? What factors contribute to the frequency of reauthentication? With OAuth 2.0, the system typically provides an access token (short-lived, often around 1 hour) and a refresh token, which can last longer. Reauthentication is necessary when both expire. While Dataflow Gen 2 does not allow manual token management, it should handle refreshing access tokens automatically. The reauthentication frequency depends largely on: 2. Cons of Using an Organizational Account What are the potential downsides of using an Organizational Account for this connection, particularly in a production setting where automation and stability are critical? Potential drawbacks: To mitigate these risks, I recommend using a service account (rather than individual accounts) to centralize and secure access. 3. Workaround for Client Credentials Flow Is it possible to implement a client credentials flow (i.e., providing a client ID, client secret, and environment URL) to prevent frequent reauthentication, similar to Azure Synapse or Data Factory? If not, what options are available for maintaining a stable, long-term data connection from Salesforce? Currently, there doesn’t appear to be support for client credentials flow in Dataflow Gen 2. You may want to reach out to Microsoft support for confirmation. As an alternative, you could explore: Like Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more The Salesforce Story In Marc Benioff’s own words How did salesforce.com grow from a start up in a rented apartment into the world’s Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Health Cloud Brings Healthcare Transformation Following swiftly after last week’s successful launch of Financial Services Cloud, Salesforce has announced the second installment in its series Read more

Read More
Power BI

Connect Salesforce and Power BI

Hello, Im trying to connect a filtered case list (https://company.lightning.force.com/lightning/o/Case/list?filterName=blahblah) containing customer reviews in the case description into a Power BI table and connect it to my AI Hub custom prompt bot that categorises text. Ideally, when new cases get added to that filtered list –  the Power BI table automatically refreshes with the case id, subject, description and an additional column where the categorised text gets added in. eg) Case ID Case Subject Case description Category 332432 AAAA blah blah customer complaint 4243242 BBBB something product quality 424234 CCCC bleh customer praise Thanks! You might find it helpful to follow these steps: 1. Connect Salesforce filtered case list to Power BI. 2. Use Power Apps AI Builder to categorise case descriptions: 3. Configure Power BI to automatically refresh for the latest classification results. 4. Displaying Classified Data in Power BI Like Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more The Salesforce Story In Marc Benioff’s own words How did salesforce.com grow from a start up in a rented apartment into the world’s Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Health Cloud Brings Healthcare Transformation Following swiftly after last week’s successful launch of Financial Services Cloud, Salesforce has announced the second installment in its series Read more

Read More
Triggering a Refresh of the Einstein Next Best Action

Triggering a Refresh of the Einstein Next Best Action

How to Force a Refresh of the Einstein Next Best Action Component User Question: “Hi folks, is there a way to force a refresh of the Einstein Next Best Action component in the service console? I tried re-executing my recommendation strategy flow, but the recommendation didn’t change, even though the flow picked a new one. I also triggered the lightning:nextBestActionsRefresh event from an Aura component, but that didn’t work either.” Triggering a Refresh of the Einstein Next Best Action (NBA) Component Einstein Next Best Action (NBA) is designed to react dynamically to changes in Salesforce, updating its recommendations. While refreshing the entire page works, there are more efficient methods to trigger a refresh in a more subtle, automatic way. Trigger 1: Automatic Refresh Based on Record Changes If a field on the record is modified, the NBA component automatically refreshes to show updated recommendations. Trigger 2: Refresh Triggered by Flow on the Same Page NBA also refreshes if a flow changes a related object. For example, if a flow modifies a related Survey record, the NBA component on the current record page will refresh. This smart refresh is facilitated by Salesforce’s Lightning cache, though it may not apply in all scenarios. Trigger 3: Community Cloud Event Integrations NBA can refresh via special event integrations in Salesforce Community Cloud pages. Trigger 4: Using a Lightning Component on the Same Page The NBA component listens for the lightning:nextBestActionsRefresh event. When triggered, it sends a new request to the NBA strategy execution endpoint. If the updated strategy returns new recommendations, the component refreshes automatically. This works on both Lightning Experience and Communities pages. To fire the event from a Lightning component, add this tag: htmlCopy code<aura:registerEvent name=”refreshEvent” type=”markup://lightning:nextBestActionsRefresh”/> Make sure the event includes the correct recordId in its payload. The component will only refresh if the event’s recordId matches the current record page. Example Code for Firing the Event: javascriptCopy codefunction(component, event, helper) { var appEvt = $A.get(“e.lightning:nextBestActionsRefresh”); if (!$A.util.isEmpty(component.get(“v.myRecordId”))) { appEvt.setParam(“recordId”, component.get(“v.myRecordId”)); } appEvt.fire(); } Trigger 5: Flow Firing the Application Event If your flow doesn’t modify related records but you still want to refresh NBA, you can trigger the nextBestActionsRefresh event from a Lightning component on a flow screen. This will prompt NBA to refresh. Trigger 6: Using Platform Events Platform events enable any event in Salesforce or an external system to trigger an NBA refresh. This is useful for real-time updates, like dynamically changing recommendations based on supply chain or ERP changes. One example involved updating recommendations based on customer sentiment detected during call recordings. By implementing these methods, you can ensure the NBA component remains responsive and up-to-date across various use cases. Like1 Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more The Salesforce Story In Marc Benioff’s own words How did salesforce.com grow from a start up in a rented apartment into the world’s Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Health Cloud Brings Healthcare Transformation Following swiftly after last week’s successful launch of Financial Services Cloud, Salesforce has announced the second installment in its series Read more

Read More
gettectonic.com