Justin Hill No Comments

GoldMine : Configuring Constant Contact in GoldMine 2019

The Constant Contact integration is now much, much better. To see what’s changed, first login to CC via GoldlMine:

Go to | Campaigns | Constant Contact Campaigns

Click on Configure, then Login and provide your CC login.

Then Click the Refresh button in the Campaigns center to download your Campaign list.

Detail about any given campaign can be seen by double-clicking on a Campaign name.

Justin Hill No Comments

GoldMine : Lock down your SQL queries with GoldMine 2019

Those GoldMine geeks amongst us have known about this security hole for years: the SQL Query tool in GoldMine. Thankfully, it only works with SELECT statements. That being said, there was nothing stopping a disgruntled salesman from “SELECTing * from CONTACT1” and walking away with your client list.

Until now. You can disable SQL Querying at the database alias level.

Go to Tools | Databases | Alias Manager | Edit Alias

Uncheck “Enable SQL Queries” and Ok your way out.

All users will need to restart their GoldMine to get the change.

Megan Hagedorn No Comments

Dynamics 365: Show Dependencies to Make Deleting Fields and Workflows Easier

Any time you need to delete a field or workflow, you’ll want to check for dependencies and make the necessary changes to remove those dependencies. Check out this post from 2018 to learn how to “show dependencies” for a field or workflow. To show dependencies for a workflow, open the workflow and select “Show Dependencies” at the top of the window.

Read more

Megan Hagedorn No Comments

Dynamics 365: Enable Change Tracking to use an Entity as a Flow Trigger

If you are starting to use Flows, this is an important (and quick) tip!  If you use an automated flow with Dynamics and set the trigger to “when a record is created” or “when a record is updated”, you MUST first enable Change Tracking for the entity that will be triggering the Flow.  Without this, when you attempt to run or test the flow, it will fail.
Read more

Megan Hagedorn No Comments

Dynamics 365: Add a Wait Condition to Complex Workflows

Did you know that you can add a wait condition to a workflow? This can be particularly helpful if the workflow is complex. Sometimes the system can get ahead of itself and cause workflows to fail if too many actions are being performed too quickly. For example, if a record needs to be created, then populated to a lookup field (if you created a contact record then updated a lookup on the Opportunity with that new contact, all in a single workflow), you’ll want to use this tip!
Read more

Megan Hagedorn No Comments

Office 365: Insert a Printout of Another Document in OneNote

OneNote allows you to easily insert a PDF printout of another document onto a page, which you can then markup or reference as needed.  This is great for keeping notes during meetings or marking up documents for formatting changes.  Please note that these instructions were tested with OneNote, the Windows 10 App, not OneNote 2016.
Read more

Megan Hagedorn No Comments

Office 365: Message Multiple Channels at Once in Teams

Microsoft recently added a feature to Teams allowing you to post a single announcement or message to multiple channels.  This will be a great way to snag people’s attention (imagine using this + the announcement or ‘mark important’ features) and post important messages across a channel without needing to copy and paste the message multiple times. Read more