Computers, Music, and Thoughts
CSVFIX has been my go to for command line ETL but I have always run it on Windows. After running in to some issues with a CSV file loading in to Salesforce I needed something on the mac to ‘peak’ in to the file and do the usual amount of stuff that I’m used to…
Another posting that resulted from a lot of great examples on the web but none that were actually bulked and tested. So the business case is “Run the default lead assignment rules when leads are created”. Seems easy but when you look at the documentation, forums, and blog postings it is all none bulked examples…
Anyone that has dealt with Opportunity Line Items knows that you cannot create a lookup to that record on another. So the next best thing is to put a text field and store the Id. Apex stores Ids in their 18 length form but in the UI it shows it to you as 15 digits. Since…
sObjects are great for dynamic apex where you need to re-use code across objects and/or need to dynamically set data. I’ve had several projects where the same logic is used across many objects such as date, territory, and ownership. Recently had a use case where I used sObjects and a custom setting with a list of…
Business Case: Client has a lot of email-to-case addresses and wants their quick action ‘From’ to be preselected in order to cut down on clicks and ensure the email goes out from an address that is not the agent and that will be returned directly to Salesforce. Seems easy enough! When looking at the predefined field…
Todays silly admin trick which you can find in 2 seconds on google is how to get the license of the user in Salesforce to show up in a list view or in reports. Once you see the answer it is a no brainer but: Create Formula field -> Text Name it something like: License…
In Salesforce Classic when you create your first community (Customer Portal) Salesforce puts a black navigation bar at the very top of the page that allows you to quickly toggle between the standard user interface and your customer portals. It…is annoying and for some reason since I rarely run in to this I forget how to disable it…
Inline editing is super easy in Salesforce Lightning but not from a related list on a record page. So this is a quick and easy way to without a controller create a VF page that can be used as a button to update a field selected records in a related list. Just flip the object…
Sometimes there is a need for a class to execute based on a record value (checkbox) or as part of a scheduled batch job. Not a new concept but you will get this error: Static method cannot be referenced from a non static context So a quick fix is to just create a non-static method that…
July 2019 Update: They ended up fixing this…but boy was it annoying. VS Code is great but after a recent update I started getting a lot of suggestions to created classes in triggers for classes that already exist. I’m sure it is a bug but it was a distraction so after more searching than necessary…