I recently had a use case where I was going to take a drop down value and use that to pull a value from a separate lookup object. I would have “Hourly” and my logic would return “Hourly__c” which I could then use dynamic SOQL and sObjects to do some magic. I did not want to use hardcoded values…
Category: Knowledge
Salesforce.com Icons
No school like the old school. A quick way to give quick visual feedback in the Classic Salesforce.com UI is to use the built-in icons in conjunction with a formula field. A source that I have used forever seems to work and then not work so I found another URL that seems to work: Does…
Quick Tip: CSVFIX Duplicate Column
One tool I use to do bulk data loads in to Salesforce.com does not allow mapping one source to multiple destination fields. You can of course use workflows or code to backfill the data once it gets in but a cheaper/easier alternative if it is just one field is the following: // Works on Windows…
Custom Settings Fun
Custom Settings are one of the great ways a developer can give admins power to update logic, settings, and the behaviour of code and really make code more flexible. This is just a quick reference of all the cool ways you can pull those settings back out without having to use a SOQL statement. The…
Test Classes with Global Picklists
Global Picklists or as Salesforce.com likes to refer to them, “Picklist Value Sets” from the menu or “Global Value Sets” in change sets, are not new but my dealings with them are. Specifically in Apex and test classes with a parent/child relationship using Global Picklists. Global picklists btw do not have the same limitations normal picklists have…
Adding New Opportunity Record Type to Wave Sales App
We created a new Opportunity Type over the weekend and I assumed that it would just magically get added to the Opportunity dataset that the default Wave Sales App builds out but no, the dataflow/dataset was missing all the records related to the new record type. Creating a new dataset showed the data so I…
Embedding Wave Dashboard in to VisualForce page with Filters
This is a post on how to successfully embed a Wave dashboard in Visualforce with multiple datasource filters in Summer 17. If you found errors, fixes, or need help please comment and I’ll respond/update the post, thanks! Wave err…Einstein Analytics as Marketing has now re-branded Wave, is a little spotty on documentation. It assumes you drive…
Silly Admin Trick: Extracting Names and Emails from Groups and Permission Sets
Filed away in the “Why is this so hard?”, extracting a list of users related to a Public Group, Queue, or Permission Set in Salesforce.com is harder than it should be. Not in reporting and a pain with Dataloader and XLS. There are lots of workarounds and methods for doing this but it should be easy!…
Fixing Salesforce.com Developer Console Jerking Back Up or Snapping Back
A strange issue I have had with Salesforce.com Developer Console on Chrome for a couple of (don’t laugh) a couple of months is that as I scroll down the page will jerk back up to the previous page. In scanning altslash.org I saw this headline: Chrome Now Uses Scroll Anchoring To Prevent Those Annoying Page Jumps…
Wave Replication and Data Accuracy
In order to support custom dataflows you have to turn on ‘Data Replication’ and you want to create custom dataflows in order to allow better control over schedules, development, debugging, and insulation against dataflow failures due to changes, data, etc. That being said you will want to disable incremental updates. Troubleshooting has several times come…