Salesforce Fact #990 | DataRaptor: Fetch accounts without any related contacts

Here's one approach to find out the account names with no related contacts using DataRaptor Extract.

Attached are the screenshots.





Comments

Post a Comment

Popular posts from this blog

Salesforce Fact #929 | Nth highest in screen flow

Image
We can find the Nth highest value in screen flow using Get Records with a bit of logic. For example, we want to find the Nth highest NumberOfEmployees value across all the accounts. The idea is to fetch the records and then run a check to iterate over the records as long as the temp variable value is less than N value. The temp variable is initialized to 1. In the assignment we would keep on removing the first record. At the end, we will pick the first record from the collection. Attached are the screenshots. Note: this is just a POC flow and the error handlings, best practices are not covered.
Read more

Salesforce Fact #245 | Enabling Case Assignment checkbox

Image
We all have seen a tiny checkbox appearing while creating or editing Case i.e Assign using active assignment rule checkbox. Let's see how we can enable it on the UI. To enable the checkbox, go to Setup -> Object Manager -> Case -> Case Page Layouts -> Open the respective page layout and click on Layout properties. Now there are two settings for Case Assignment checkbox. One is show on edit page and another is default. 1. If we only select the default, then it will always run the active assignment rules and we won't see the checkbox in the UI. 2. If we select both default and show on edit page, then the checkbox will appear in the UI and it will be selected by default. But we can uncheck if we want. 3. If we select only show on edit page, then the checkbox will appear in the UI and it will be deselected by default. But we can check if we want. 4. If we select none of the checkbox, then the checkbox won't be visible in the UI and none of assignment rule will run. ...
Read more