Skip to main content

Using Zoho Connections to Invoke the API

By Zoho Tips No Comments

Using Zoho Connections to Invoke the APIWhen writing custom functions in Zoho CRM, there are times that, when we add or update a record in the custom function, we need to trigger existing workflow. The only way to do this is to use the Zoho API within the custom function when adding/updating the record and set the trigger to workflow.

With the new API 2.0, this can be a tad more cumbersome to first set up the client, get the refresh token, and then copy and paste all the long strings into every custom function where you use the API.  Enter connections:  It is fairly simple to set up a “connection” for the CRM API, and then refer to that connection when invoking the URL. Here’s how:

Read More

Zoho CRM and the Lead Source field

By Uncategorized No Comments

Going back to CRM basics this month… The Lead Source field is a standard in the Lead, Account, Contact and Deal modules.  It is intended to represent your quiver of marketing strategies used to find leads.  If you use this field as its intended, in conjunction with the “Type” field in the Deal module,  you can get great feedback on how much new business is brought in by the varying marketing strategies, and make the necessary adjustments to put more time and energy into techniques that work and less on ones that don’t.

ALWAYS mark a new lead with a lead source, and make sure the Lead source field is mapped into at the very least the Deal module.

ALWAYS indicate whether a Deal Type is “New Business” or “Existing Business”.

If you do these two things – you can then pull a DEAL Summary report for all Closed Won deals within a specified timeframe, group by Lead Source, and Sum Amount.  This will show you the $ amounts won via each marketing strategy employed over the specified timeframe!

To take this one step further, you can throw Campaigns into the mix!  If your marketing is campaign driven, you can also mark each Lead/Deal with a Campaign Source – then you can pull a similar report, but instead of Lead Sources, use Campaign source instead.  This gives you ROI on all of your marketing campaigns!

ZOHO CRM – using Connections to invoke the API

By CRM, Zoho, Zoho CRM No Comments

When writing Custom functions in Zoho CRM, there are times that, when we add or update a record in the custom function, we need to trigger existing workflow.  The only way to do this is to use the Zoho API within the custom function when adding/updating the record and set the trigger to workflow.  With the new API 2.0, this can be a tad more cumbersome to first set up the “Client” get the refresh token and then copy and paste all the long strings into every custom function where you use the API.  Enter Connections!  It is soooo easy to set up a “Connection” for the CRM API, and then refer to that connection when invoking the URL – here’s how… Read More

Office 365: Create a Geographical Chart in Excel

By Microsoft Office 365 No Comments

Excel’s charting capabilities are well-known at a basic level—everyone knows that they can create pie, bar, or line charts/graphs with their Excel data.  However, Excel also allows you to create geographical charts that automatically plot data on a map.  The maps use a “fill” function to show data, so this best shows numerical data by County/State/Country etc. You can plot data by:

Country/Region
State/Province
County
Postal Code
      
Read More

Office 365: Update the Offline Global Address List in Outlook

By Microsoft Office 365 One Comment

One of the Address Books that Outlook keeps is the Global Address List, which is a comprehensive list of every “mailbox-enabled or mail-enabled object in an Active Directory forest that has Exchange installed” (Source: Microsoft).

Microsoft also keeps an offline version of this address list, and this can be accessed when you are not connected to Exchange.  You’ll want to keep this address list, or address book, updated in the event that you need it.  Read More

Skip to content