Join The Community Sign Up For Club Zenata

Article Read Time:

2 Min

Stay Connected

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

Billy Bates

Senior Web Developer

Billy is a Wordpress Developer with an eye for design. His knowledge will help our company website and client sites meet their goals. Billy and his young family have just moved to Ashland Oregon, and are looking forward to exploring the area’s amazing beer, wine, and food. He also has a passion for synthesizers and drum machines.

Lucas Sant'Anna


With a background in Operations Research and Data Analysis, Lucas is a Brazilian programmer that likes to get stuff done quickly and reliably. In previous jobs, he implemented industrial job scheduling, fleet management and detailed long-haul route optimization – among other data-driven processes – to reach objectives of increased profit and reduced wasted resources. His goal is to make Zoho fully automated and with more meaningful data for spot-on decisions.