Should be straight forward…to enable Service Contracts you have to “Enable Entitlement Management” …why is this so hard to google.
Silly Admin Trick: Enable Service Contracts
Posted on
Category: Knowledge
Silly Admin Trick: How to Access Salesforce “Platform Integration User” Profile
Posted on
While trying to disable a record type I got the following message: This Record type Record_Type_Name Cannot be deactivated because of the following profiles use this record type as default. Upon clicking the profile “Platform Integration User” I get the “Insufficient Privileges”, so sad. Looking at the article linked below I put this URL together to access…
Silly Admin Trick: Random Character Generator
Posted on
Sometimes what is so easy in other languages and scripting tools can be a real pain in Apex and Formula Fields. I am talking about random character generation. Not sure why this is not a method but have used this trick a couple of times and in doing some reading it actually taking about 1/10…
Wave / EA: Counting the number of weeks, months, days, etc. in SAQL
Posted on
This was for some reason harder than it should have been. Needed to create the number of weeks from the beginning of the year to today. Re-posting this really because there are not a lot of examples out on the web. date_diff(“week”,toDate(“2018-01-01″,”yyyy-MM-dd”), now()) as ‘YearlyGoal’ I will go back later to make the start of the year…
Silly Admin Trick: Removing Carriage Returns from Long Text Fields
Posted on
Recently had a project to use Jitterbit to query and pull data out of Salesforce.com in to a CSV file to import in to another system. All great and fine except long text fields with carriage returns were wrecking the CSV. This simple fix was all that was needed: Replace(root$transaction.response$body$queryResponse$result$records.Account$BillingStreet$,’\n’,”); Got it right off the support…
Too many SOQL queries: 101 even when using testSetup
Posted on
I am a huge fan of creating global test classes within Salesforce that leverage one testSetup section to set up the data that then can be used many times to test the many different methods and classes. Gone are the days of having a million test classes to manage and update every time changes are made in…
Silly Admin Trick: List of all Objects
Posted on
Do the following to get a list of Objects by their API names: Pop in to Workbench Run the following query:SELECT SobjectType FROM ObjectPermissions Click Bulk CSV to download Click the query button to execute Open in Excel and Dedupe A quick and easy way to generating a list for creating backups using ‘Backup-force.com’: https://github.com/neowit/backup-force.com
Backing up Salesforce.com Meta Data on a Mac
Posted on
There are a couple solutions both paid and free for backing up your Salesforce.com Metadata in addition to using an IDE like Eclipse. If you need something ‘free’ and on a schedule the best solution I have found has been: Alan Morey’s Force Meta Backup To use this tool though there’s a couple of prereq’s…
Silly Admin Trick: Finding Active ‘Frozen’ Users in Salesforce.com
Posted on
One gap with freezing users in Salesforce.com is the ability to go back and find those users. Google is your friend for finding the answer. There’s even an article from Salesforce: How can I tell what Users are Frozen via the API? The below is my take on it. Use workbench/bulk/csv to create an exportable list that…
Clicking Link in Email Opens Blank Chrome Tab
Posted on
Restart Chrome…it has an update that has been applied. Click Help -> About to validate but this issue drove me nuts and since I work on a Mac that only needs rebooting when the VPN crashes (1-4 weeks) I was periodically suffering through this one. It is amazing how long you can deal with a…