Find the API Name from the Field Label

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…

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…

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…

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…