Link Zoho Analytics Reports to Records in Zoho Apps

Instant Link to Other Zoho Apps in Analytics Reports

Think how useful this feature could be for any employee! When viewing any kind of report in Analytics, be it Invoices (Books), Deals (CRM), Inventory Adjustments (Inventory), Receipts (Expense), etc., to be able to click in the report itself, or the underlying data, and then be taken straight to a specific record within another app is extremely helpful! No more having to open up a new tab and application and search by ID or reference number to access a specific record of interest.

What do I need before writing the Query?

First, the app for which you want to create the connection must be synced and integrated with Analytics. Then, within that app,identify the base URL for the specific report you want to create. This is the part of the URL that immediately precedes the unique 19-digit record ID. Add that into the concat command, followed by the “record_id” for the specific record you want.

Want to learn even more?
Sign up for one of our Zoho courses!

Anything else?

This sample SQL code is simply an example of one application, that of Sales Orders in Zoho Books. However, you can use the same general structure and code to create a URL connection between almost any Analytics reports and the corresponding records in other Zoho apps. Once you completed the code and saved it, in the report viewer you will have to select the column and “Change Data Type” to ‘URL’. Then, it really is just a one-click connection to each record.

Click here to copy these scripts. For more information on Zoho Analytics, read through our comparison of Analytics and Tableau. And, for more Zoho-wizardry, check out our GitHub page.

Want to learn how to create Invoice and collect payment from Zoho Creator?

Or learn how complex assignment rules config Via Zoho CRM modules works?

Want this functionality, but don't want to do it yourself?

Click here to speak to us!

Need help with your Zoho system?

Hire a full time Zoho System Admin from our poolof highly qualified program graduates!

Related Resources