Force.comに関するブログ文章やメモです。

Salesforce Mass Editor (Chrome Extension) – Seconds to make any standard list view to be a powerful mass editor

salesforce-mass-editor-main

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. ・Export record data to CSV file. ・Mass copy & paste from […]

read more

Instantiating an Apex class based on dynamic string name with Type class

saleforce

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 more

Writing a Schedulable Batch Apex in Salesforce

schedule-apex-user-interface

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 more

Using Aggregate SOQL queries/results in Batch Apex

saleforce

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 more

Zip attachments only with Apex in Salesforce

Apex zip sample page

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 more

To fix MIXED_DML_OPERATION error(setup and non-setup objects) in Salesforce

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 more

Using HTML tag(e.g. line break) in Custom Label

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 more