Kelsey Petersen No Comments

MSCRM – Last Activity Date

If you haven’t worked with the calculated or rollup field types in MSCRM, you’re missing out! They really help to automate calculations and provide an easy way of doing tasks that you previously had to do with JavaScript or workflows. I’m going to review a few examples of calculated and rollup fields that I have found useful for many clients.

If your users or sales reps are logging activities in MSCRM, chances are that management would like to know how often they’re working on a particular customer or opportunity. With a rollup field, you can get this information with ease. This example is going to determine the date of the most recent closed activity for an account. My example will look at all activities but you can limit it to specific types. I have a client that only wants to know when a rep logged a phone call and didn’t leave a message because that should mean that the rep actually spoke to the customer.

  1. Create a new field for the account. The Data Type will be Date & Time, Field Type will be rollup. Format is your preference – Date Only or Date and Time.
  2. Make sure that Behavior is NOT set to Date Only. Since the Actual End field on the activity is not date only, the rollup field can’t be either.
  3. When you click on the Edit button next to Field Type, a new window will open where you can define your rollup criteria.
  4. Under Related Entity, choose Activities (Regarding).
  5. For the Activity filter, set it to Activity Status equals Completed.
  6. Under Aggregation, use MAX of Actual End. You can choose a different date field here but I use Actual End to be consistent across all activity types.

Here is what the completed rollup settings will look like.

MSCRM Rollup

Rollup fields are automatically updated every evening with a system job that runs. Additionally, you can manually update the field by clicking on the small refresh icon.

MSCRM Rollup Refresh



Kelsey Petersen No Comments

MSCRM – Calculating Opportunity Age

If you haven’t worked with the calculated field types in MSCRM, you’re missing out! They really help to automate calculations and provide an easy way of doing tasks that you previously had to do with JavaScript or workflows. I’m going to review a few examples of calculated fields that I have found useful for many clients.

People often want to know how old a record is. For example, you may want to know how long an opportunity has been open or how long a lead has been waiting to be contacted. An easy way to achieve this is with a calculated field. You can basically “set it and forget it.” Let’s review how to create a field to calculate the age of an opportunity. It will indicate how long an opportunity has been open.

  1. Create a new field on the opportunity. The Data Type will be Whole Number for the number of days. The Field Type will be Calculated.
  2. When you click the Edit button next to the field type, it will create the field and open a new window where you can set up your calculation.
  3. First set up a condition that checks if the status of the opportunity is Open.
  4. Add an action for the condition. It will set Age to DIFFINDAYS(createdon, NOW()). This is essentially today’s date minus the day that it was created on.
  5. Add an Else action that will calculate the age when the opportunity is not open (closed as won or lost). This will look at the actual close date minus the date that it was created. The formula is DIFFINDAYS(createdon, actualclosedate).

Here is a screenshot of what the calculation looks like when finished.


It’s very simple and doesn’t require any maintenance. The field updates on its own.

MSCRM Age Example

Corey Babka No Comments – Creating Email Templates

You can easily setup and create email templates in Salesforce, used for email blasts, simple emails, etc.  I like to use my templates for both, which can be a real time saver when you find yourself writing the same (or similar) emails many times a day.  To start click Setup and search for “Email templates”.  Click to select that area of the setup menu.

You’ll see a list of your templates:


Here’s we’re going to click “New Template”.

Choose whether you want simple text, HTML, etc.  I prefer simple text sometimes, makes the email feel a bit less boiler plate and individual when there isn’t as much marketing stuff in there.  However, depending on the needs, maybe the marketing “stuff” is what’s needed.  Select and Click Next.

Here we provide the template information including folder (if you want to organize your templates), the name/API name, description, the subject and the body.  Here I’ve copied the sample template into the body to display the merge fields used.


Couple of key points here and what we’ll demonstrate in the webinar for this tip (see our events section) is the creation of new merge fields.  Using the top part of the form, you choose your field, then simply copy and paste in those merge fields into the body of the email.  Here we’ve got the Account.Product field displayed.


Save it and done.

Corey Babka No Comments – Running an Email Blast Using a Template

Now that we’ve got our template created, let’s make the blast happen.  For this, we need to go to our Contacts area as I always say, “we do business with accounts; we communicate with contacts”.

Once there at the bottom of the contact home page (one with the “recently viewed”) and scroll to the bottom – select “Mass Email Contacts”.


On this first page, you can use a view that you already created, or you can create a new view for the contacts.  Here I’m using an existing view.  Once you click “GO”, it will show you all the contacts you’re going to mail to (to which you can uncheck some if you’d rather not email them).


Now you choose your email template.  You can choose a folder and even preview them as well if you forgot what they look like.


Click Next to get to the final screen (this is point of no return here if you click SEND).  Here you just have to decide what to do with the history of the email.  For instance, I prefer to NOT bcc myself, I do add history for each and then just put in a topic for the mass email (the body of the email will NOT store in history, only the subject and date it was sent to save on space).  You can schedule it which I always recommend as well.


Now, keep in mind that there are some limits to how many emails you can send so check with your administrator before doing any of this, making sure you won’t use up your quota or you don’t have too many contacts to send to.  Also, there’s a simple change that has to be done or your emails will say something like “ on behalf of Corey Babka” which no one likes.  See this post on this setting:

Corey Babka No Comments – Using Email Templates for “One-Off” emails

Another way to use the email templates is to not “blast” the emails, but to send them one at a time.  For instance, in a contact record, I may mouse over the history area and click “Send Email”.


This of course allows for the emails to be sent and recorded directly from Salesforce but you need a template.  You can manually write it but that would be a little tough.  So, “select a template” instead and have it filled in.


Once the template is selected it fills in everything but provides you the opportunity to customize just a little bit more for that one email.  Maybe a comment to the person directly about last month’s phone call, an upcoming event or maybe a request for a meeting specific to their needs.  This just really helps your users not have to type the same thing every time (and helps with spelling, marketing needs, standard messaging, etc.).

Some will create a template that is more like a signature to which you can also select that each time.

Justin Hill No Comments

GoldMine : Using Templates for E-mail Signatures

Did you know that you can use an actual e-mail template for a signature, as opposed to using a simple text file? This allows you to use fancy fonts and insert company logos.

First, you must create an e-mail signature template.

1. Select Go To | Document Templates from the top level menu.

2. Select YOUR username from the top left-hand drop down list.

3. Within the left-hand pane, right click on “E-mail Templates”, then select “New”.

4. This will drop you into the template editor. Simply use it like a word processor and type out (inserting pictures as appropriate) your desired signature text.

5. When finished, click the little yellow disk button in the top left-hand corner to “Save”. Make sure your template is listed properly in the Document Templates list.

To set the template to be your default e-mail signature;

1. Select Tools | Options from the top level menu.

2. Select the “E-mail” tab, click on “More Options”.

3. In the lower right-hand corner, use the “Default Templates” drop downs to find and select your signature template. You can set it for “New Outgoing”, “Replies”, and “Forwarded”.

4. Ok your way back out to GoldMine.

5. To test the template, simply start writing an e-mail. The Defaults you set up should take effect immediately.

Justin Hill No Comments

GoldMine : Modify your Toolbar

Did you know that you can add simple GoldMine menu items to the top-level toolbar? This is done on a per-user basis, so each user can have their own “favorite” toolbar items.

1. Click on the “little down arrow” at the right edge of the toolbar;

2. Select “Add or Remove Buttons”.
3. Click “Customize”.
4. Click the “Commands” tab.
5. From here you will see all the available GoldMine top level menu items. To add any item to your toolbar, simply click-drag the item from the window up onto the toolbar. If you add the wrong thing, or want to remove an item, simply click-drag it OFF of the toolbar.
Justin Hill No Comments

GoldMine : Viewing your History

Such a simple question, isn’t it? How can you look at just YOUR historical items without running a report or going from record to record to record?

Easy, it’s all within the Activity List.

1. Select Go To | Activities from the top level menu.

2. From here, you can see both Pending and Completed items on a per-user basis, filtered by Date Range and Activity Types.

3. Use the left-hand pane to drill down to the historical items you want to inspect. (Clicking on the “Closed Activities” folder gives you ALL activity types)

4. Use the top-level drop downs to select Date Range and Username.

5. Don’t forget you can export the list by right-clicking and selecting Output To | Excel.

Try it!

Suzanne Kirkland No Comments

ZOHO CRM – Get your GAME on!

With the new 2016 CRM release comes GAMESCOPE! Gamescope will motivate your employees to work harder and have fun doing it! Anyone can set up a game with one or more users in the system. Each player earns points completing certain defined things in CRM – like converting a lead, closing a deal, completing a task.

To set up the actions and points rewarded, click on the GameScope icon in the top nav bar,


then click the gear wheel.screen-shot-2016-09-27-at-7-26-42-pm

To create a game, simply click the New Game Button. Try it out!

Suzanne Kirkland No Comments

ZOHO CRM – Add margins to a template

Zoho’s inventory templates look fine when viewing online, but if someone wanted to print them, they don’t have much of a margin around them.   Here’s a quick trick to add a margin to any template in Zoho:

Create the template first.  Then click the html button in the Template Editor’s Tool pallet:

You’ll be presented with all the html code that goes into making the template that you created.  Don’t be scared ;o)

Add this code at the start:

<div style=”margin:10px;”>

and this code at the very end:


You can adjust the number 10 to get the desired margin you want.  Smaller number will create thinner margin.