A Tip A Day #39 – Easily Find Newly Created Fields in Salesforce

This post is a part of the daily blog series  A Tip A Day, daily dosage of learning! Day #39 - Easily Find Newly Created Fields Finding the CreatedDate of fields in Lightning Experience is hard work.  The fields list in object manager doesn't have a column for 'Created Date'.  You need to manually click …

A Tip A Day #19 – Set Currency of User

This post is a part of the daily blog series  A Tip A Day, daily dosage of learning! Day #19 - Set Currency of User I have a user whose current Currency is set as SGD - Singapore Dollar Requirement The requirement is now to change the Currency of the user to USD.  Simple? I thought …

A Tip A Day #18 – Rollup Summary Decimals in Database

This post is a part of the daily blog series  A Tip A Day, daily dosage of learning! Day #18 - Rollup Summary Decimals in Database Lets say you have a rollup summary field of decimal on your master object record which is a SUM of currency field of your child records. Scenario: For a child …

A Tip A Day #11 – Workaround for PriceBookEntry Trigger/Workflow

This post is a part of the daily blog series  A Tip A Day, daily dosage of learning! Day #9 - Workaround for PricebookEntry Trigger Salesforce has quite a few limitations on Product, Pricebook and Pricebookentry objects. The one that I recently faced on Pricebookentry is that we are not allowed to write triggers on Pricebookentry …

Bulk Scheduling Dashboard Refresh using Apex Batch

Good stuff from Cloudy Affair!

cloudy ☁ affair

One fine day, I was browsing through the questions on Answers Community. A gentleman posted that his organization had over 150 dashboards which need to be refreshed simultaneously at a particular time of the day and currently they are doing it manually, which I understood was a tremendous overhead. I thought for a while and started posting an answer pointing towards whats stopping him to schedule a dashboard refresh. But then I thought maybe I should check the documentation and what I found was –

  • “Run Reports” & “Schedule Dashboards” permissions is necessary to refresh dashboard and schedule dashboard refresh respectively. [AB : Ok, thats fine.]
  • Unlimited and Performance Edition users can schedule up to two dashboard refreshes an hour per day. Enterprise Edition users can schedule up to one dashboard refresh an hour per day. [AB : Wooh, Whatttt!]
  • Additional scheduled dashboards may be available for purchase.  [AB : Makes sense, performance…

View original post 825 more words

Salesforce Code Scanner – Health Check

As a Salesforce Developer, have you ever worried about the code in your Salesforce org and wanted to check if: the code you have written/existing code is in line with the best practices? you have followed the coding guidelines suggested by Salesforce? there are any loop holes in the code that could cause severe security …

Visualforce Pagination with Dynamic Search

This post has a working example of dynamic search in a Visualforce page and the results shown with pagination. There are 4 field search criteria including date fields too which makes it more interesting.  The results upon clicking Search will display below the Search section with 4 buttons to paginate.  The Next/Last Page buttons grey …

Run Script After Sandbox Creation and Refresh

This feature is to make your sandbox environment business ready, automate data manipulation or business logic tasks or even to schedule your jobs. At sandbox creation, specify a single Apex class to perform the tasks. This class executes every time the sandbox is refreshed/copied. Create an Apex class that implements SandboxPostCopy and specify the class here. For example, the …