Tuesday, February 28, 2023

Looking for an alternative to salesforce excel connector? (for Mac and Windows?)

Looking for a  Mac/Windows alternative to the retiried Excel Connector?


Many companies used salesforce excel connector + Microsoft Excel for bulk updates and general data maintenance tasks. The constant process of exporting segments, identifying issues, performing refershes, and re-importing that data back into Salesforce is extremely time-consuming and prone to complications.

Naturally, companies look for solutions to bridge the gap between Microsoft Excel and Salesforce and cut out some of that tedious work.

Now you can use ZaapIT's native app to do every data maintaince task right inisde Salesforce:


Manage Duplicates and general data cleansing


Merge Jobs



Manual Mass Merge






Bulk Updates and Bulk Format



Advanced views with inline edit, chars and more





Setting your user as the app’s admin in ZAAPIT for Salesforce

 

You shoud do that if you can’t see the Mass update/actions all buttons:


Please mark the layout editor checkbox and unmark the view editor checkbox for your user, add the fields to the layout if you can’t find them under your user, after doing that you will be able to create a merge job.

 

https://sc2.zaapit.com/pdf/ZaapitTools__User_Guide.pdf

 

Mark only 1 checkbox (the enable zaapit layout editor checkbox), add the fields to the layout if you can’t see them:


                                      Get ZaapIT app Now!

Monday, November 12, 2018

Track Field History for Tasks / Activities in Salesforce Lightning

A lot of Salesforce users & admins have asked for a task history tracking option in Salesforce in order to track status & comment changes or to generate global usage/trend report.
It is now possible to do that with the following app & package.



Installing ZaapIT History Tracking (3 steps):

1) Install  Smart-Tables / Smart-Activity-manager from the AppExchange.

2) Install the below ZaapIT history extension package:

Use this URL to install the package into any organization:
https://login.salesforce.com/packaging/installPackage.apexp?p0=04t1p000000Niyi

Use this URL to install the package into any Sandbox:
https://test.salesforce.com/packaging/installPackage.apexp?p0=04t1p000000Niyi

3) Add the history grid to the page layout as a tab (use zaapit_tb_task_rl1 page).
https://www.youtube.com/watch?v=-ly2C_aI7PA



Track field history for tasks in Salesforce lightning

Adding the history tracking tab to the page


Monday, October 2, 2017

Sending Bulk Emails to every Contact / Lead

Did you ever wanted to send bulk emails to every Contact / Lead in Salesforce?

On September/2017 we added that ability to our list of features - no more switching to next page...

Sending bulk emails:

  1. Create a Salesforce email-template (via setup>filter> email templates), make sure the template have a text version + a description (the app uses that information when it creates the an activity log)
  2. Open the Smart-mass-update>contacts or leads tab
  3. Use an existing view or create a new view with the relevant filters i.e. in order select the relevant leads / contacts for this email campaign ...
  4. Mark the "all" checkbox and click the Mass Email button (on the list-top)
  5. Select your template from the list for available templates
  6. Click the Send - All Rows button (you will receive a batched email summary once done).
  7. After the emails were sent use the "HTML Email Status Report" to monitor user interaction.
    https://XXXX.salesforce.com/00O?rt=11&interval_q=last30&break0=EMAILTEMPLATENAME&sort=OPENED&sortrir=down&details=yes&format=t


Sending emails in bulk to every contact / lead



Tuesday, March 21, 2017

Mass Lead Convert in Salesforce lightning LEX

The following example will show you how preforms bulk lead convert in Salesforce lightning (LEX).

The below process can convert multiple leads records in bulk and merge them with existing/matching contacts & accounts (the app uses the lead's email & company name to find existing/matching contacts & accounts).
This process pulls all the lead's fields & related information automatically places/merge it the with the right record...


Mass Convert leads in Salesforce lightning

Tuesday, December 20, 2016

Automatic Lead-convert in Salesforce

The following example will show you how to setup an automatic lead-convert process with a custom convert criteria.

The following auto lead convert process does not create duplicate contacts / accounts (it uses to lead's email & company name to find existing contacts & accounts - similar to our mass convert actions).
You can disable/enable the auto-duplicate detection and the creation of new opportunities (disabled by default)...

Creating an automated lead conversion process with a custom convert criteria:



Process builder - automated lead convert criteria

Process builder - automated  lead convert process


Monday, December 19, 2016

Account Hierarchy / Customer-View in Salesforce

Did you ever wanted to offer your clients an upsell or cross sell deal? Did you ever wanted to see the key insights of a multi-accounts customer?

Multi-Objects Account Hierarchy in Salesforce (Customer-View):