Article Read Time:

2 Min

Search

Subcribe :

Train Your Team:

Our Extensions:

Join For FREE:

The CRM Zen Show Episode 242 – It’s aZird It’s aZlane, It’s aZaaZThe CRM Zen Show Episode 242 –

Zoho News

Implementation of the Week

  • Zoho Desk + Zoho Analytics Integration for Tracking Billing against Paid Support Agreements
    • In this implementation, our goal was to provide needed data to our client’s support team to know if their customer has enough hours to continue support, or if there needs to be a discussion about billing.
    • To accomplish this, we first built Analytics reports rolling up the total number of recurring support hours purchased by each client, as well as the number of hours billed during the current month so far.
    • Then, we set up functions triggering both on Ticket Creation and Timesheet Create/Edit. 
    • These functions check the Analytics data to compare the monthly billings (including the Timesheet that triggered the function) to the prepaid monthly hours.
    • Based on the comparison of the numbers, we can write back to the Ticket to identify if the Customer is covered, approaching their max, or overdrawn on the account.
    • These identifiers reset each month when the new billing cycle starts.

Code Share of the Week

  • Convert GPS Degrees/Minutes/Seconds to Degree Decimals 
    • GPS Coordinates can be displayed one of two ways:
      • Degrees/Minutes/Seconds (DMS)
        • Example: 52°46’27.2″N 1°17’09.7″W
      • Degree Decimals (DD)
        • 52.774231, -1.286038
    • More often, you will need the Degree Decimals if you are sending GPS coordinates via API or if you want to calculate the distance between two GPS points. Here is a snippet that will convert the DMS format to the DD format.

New On Zenatta

  • Zenatta Blogs
    • Project Management Styles
      • The best project management style is the one that works best for you.  Here is a general overview of most of the project management styles out there.

Tips and Tricks