Author Archives: Lin
Salesforce Mass Editor (Chrome Extension) – Mass create, mass update, mass clone, mass delete on any list view. Support for both Classic and Lightning!
- Oct
- 28
This’s my second Chrome Extension (First one is HERE) this year, named “Salesforce Mass Editor” and it supports for doing the below things : ・Makes any Salesforce list view to be a powerful mass editor. ・Mass insert, mass clone, mass update, mass delete, ALL-IN-ONE. Support for both Classic and Lightning! ・Export record data to CSV […]
read moreInstantiating an Apex class based on dynamic string name with Type class
- Sep
- 30
Somtimes we need to instantiate a Apex class by dynamic value in Salesforce, which can make our program more modular and more readable, such as the below case : 1. Each Contact has its socail fields : “Type__c” and “AccessToken__c” 2. Needs to request its profile via socail api in Apex First we need to […]
read moreWriting a Schedulable Batch Apex in Salesforce
- Sep
- 26
To use batch Apex, you have to create an Apex class that implements interface Database.Batchable in Salesforce, like the following sample code: Execute batch Then you can use Database.executebatch method to execute it. Schedule Apex job To schedule your batch Apex to run at regular intervals, you also need an Apex class that implements interface […]
read moreUsing Aggregate SOQL queries/results in Batch Apex
- Sep
- 26
In previous post, we had created a schedulable batch apex that implements Database.Batchable<sObject> in Salesforce, but if you want to use SOQL having aggregate functions like SUM(), MAX(), COUNT() on results grouped by “GROUP BY” clause in start execution, changing to interface Database.Batchable<AggregateResult> isn’t a workable way, because it fails with the below compile error […]
read moreZip attachments only with Apex in Salesforce
- Sep
- 07
Before this post (about 2 years ago), I’d shared a post that is about how to zip attachments with JSZip and Apex in Salesforce, and recently I found a more simple way to do that thing, which is only using an Apex library named “Zippex” ( view on Github). Here is the outline of my […]
read moreTo fix “portal account owner must have a role” Error in Salesforce Community Unit Test
- Aug
- 29
In Salesforce, if you’re trying to run Unit Test with a Non-Role user, which includes part of creating Portal / Community User test data, the following error will be occured, that is because the portal account’s owner does not have a role to be assigned. System.DmlException: Insert failed. First exception on row 0; first error: […]
read moreTo fix MIXED_DML_OPERATION error(setup and non-setup objects) in Salesforce
- Jul
- 21
The following error will be occured if you’re trying to perform DML operation on both setup and non-setup objects in the same transation. ` MIXED_DML_OPERATION, DML operation on setup object is not permitted after you have updated a non-setup object (or vice versa): CustomObject__c, original object: User: [] ` Here is the sample code that […]
read moreUsing HTML tag(e.g. line break) in Custom Label
- Jul
- 12
Custom Label is a really useful feature in Salesforce, not only can be edited after deployed, but also can be used for making an app multilingual with Translation Workbench. If you want to use HTML tag with it on Visualforce Page, e.g. <br /> tag, the only thing you need to do is using an […]
read moreUsing Custom Metadata Types and Custom Settings in Salesforce
- Jul
- 07
Custom Metadata is one of the new features that released at Summer’15 of Salesforce, which is customizable, deployable, packageable, and upgradeable application metadata, and it supports the following custom field types. • Checkbox • Date • Date and Time • Email • Number • Percent • Phone • Picklist (Can’t use Global Picklist Value Set) […]
read more