Skip to main content

Salesforce Blog

Search This Blog

Duplicate finder formula field using VLOOKUP

on March 08, 2017

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

This is great help from salesforce to find dups without any trigger OR SOQL involved.

FORMULA:

fields formula Salesforce

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Comments

Post a Comment

Pradeep Dani

Popular Posts

Create queue in sfdc apex test class for case object

Usually we need to create all type of data while writing test class. Like custom settings, custom object records, queue. Queue will be associated with the group. So to create a queue we need to create group. Following is the code snippet which runs to create the queue. APEXTEST:

Data Chunking in salesforce for large volume data extracts

Basically Chunking can be done in two ways: Auto-number Chunking PK chunking Auto-number Chunking Using a date range to group data into sets can be easy and clean, but the total number of records that could fall within a given range might go above the Force.com query optimizer’s selectivity threshold. When this happens, the underlying query must do a full object scan, often leading to timeouts. (Refer to the Database Query & Search Optimization Cheat Sheet to see what the selectivity thresholds are.) If you are certain that filtering by the date range alone will always be selective, you can use this field to chunk your data. Otherwise, using a unique ID is more reliable, and can be easily implemented by following these steps. Create or use an existing auto-number field. Alternatively, you can use any number fields that can make up a unique value, as long as they are sequential. Note : If you are adding a new auto-number field, make sure to enable the “Generate Auto

Make html form to not open a new window every time form gets submitted

Recently I got this scenario and researched a lot to find the hack/solution. Solution - If you can put a window names and refer same every time, then browser will make sure to open new tab if not opened already, otherwise it will just refresh the window. Example snippet: demo here <form id="myForm" action="<URL>" method="POST" target="_blank" onsubmit="target_popup(this)"> First name: <input type="text" name="fname"/><br/> Last name: <input type="text" name="lname"/><br/> <button type="submit" id="btnTest"> Submit</button> </form> <script> var target_popup = function(form) { window.open('',//URL should be blank so that it will take form attributes. 'UniqueWindowName', //window name 'width=400,he

Powered by Blogger

Written by @JPradeepkumar