ZohoCRM: Get Organization Business Hours using Deluge/API
- Category: Zoho CRM
- Hits: 35911
A super quick article on getting the business hours set in ZohoCRM.
Why?
When creating a booking system in ZohoCreator, I want to enter the default working shift for an employee either existing or that has been added to the system based on the business hours set at the organization level in ZohoCRM.
How?
Using an invokeURL, the key here is you'll find them in the settings; so check that your connection has the scope to access both Organization details (ZohoCRM.org.READ is enough - perhaps optional) and access to Settings (ZohoCRM.settings.READ). I'm calling mine "mycrmconnection".
ZohoCRM: Integrate ChatGPT to ZohoZIA
- Category: Zoho CRM
- Hits: 70243
Following on from the article: Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo. This is the next step as we get it to look at data within ZohoCRM.
Why?
Because it is a serious improvement upon ZohoZIA and we get a lot of requests around customizing ZohoZIA...
How?
So taking ideas from my previous article for ZohoCliq; let's use what we know to develop a ZohoZIA for a demo system.
There are several steps, so first we will set up the ZIA action "Ask ChatGPT" using the GUI, then we will capture the question using Deluge code and query the OpenAI ChatGPT API to return a response.
ZohoCRM: Get All eBay Active Listings
- Category: Zoho CRM
- Hits: 33901
Another one of these articles talking about getting all the active product listings from eBay for a specific client.
Why?
Our use-case scenario here is that we want to get an inventory level or stock check of all the products that are currently listed in a client's eBay store; we want to get the stock level and then use this data to synchronize with data held in Zoho Inventory...
How?
So we're going to use a ZohoCRM function to get this file which we can run on demand. Why not in Zoho Inventory or any other Zoho app? Because we like to challenge ourselves...
ZohoCRM: Import Attachments
- Category: Zoho CRM
- Hits: 68373
An article for myself really as I couldn't find much online to address the errors I encountered below but also to document the import process of a bunch of files into a ZohoCRM system.
Why?
Our use-case here is a data migration for a client from a legacy CRM to ZohoCRM. They have a lot of files they want attached to their respective records in CRM. This took me a while as our own documentation is scatty and the online forums weren't too helpful either.
How?
In the example below, we are going to document how to import files associated to CRM Contact records. There's first the preparation of an "Attachments.csv" file that needs the correct values in each column and the "Attachments.zip" containing the files to attach that needs some formatting as well:
Zoho CRM: Manage a subform using Client Script
- Category: Zoho CRM
- Hits: 53687
This is an article with a snippet of code demonstrating how to manage a subform using a Zoho CRM Client Script.
Why?
A client wanted an automation on-the-fly that when selecting a specific value in a field, a row would be added to a subform contained herein.
How?
Well I won't go in to detail on how to add a client script, this article is just to show the snippet of code used in the client script which will manage a subform.
Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template
- Category: Zoho CRM
- Hits: 34476
A noteworthy article in my opinion on how to send a CRM quote record using a template the customer created from a button.
Why?
Yes you can do this already by going to the record, clicking on the ellipsis or three horizontal dots button in the top right and selecting "Send Mail" then selecting which inventory template to use... This is too many steps for some. Instead, we've been asked to create a button that sits on the view page of a record and the staff simply click on and it does all the aforementioned.
How?
The difficult part here was to figure out how to convert the CRM record into a PDF using a customer's template.
ZohoCRM: ZDK Client Script to retrieve Contact Email
- Category: Zoho CRM
- Hits: 30936
An article on one of my first client scripts for ZohoCRM. This retrieves and populates an email field based on when a contact is selected in a lookup field.
Why?
I could do a normal automation/workflow on save of the record, but the client wants the email to be prefilled in the field as soon as a contact is selected.
How?
This needs to behave like a formula field which changes and displays before saving the record. At time of print however, I can't get a formula field to retrieve a field from another CRM record.
Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge
- Category: Zoho CRM
- Hits: 31292
A quick article on how to upload an image to the product/item listing in Zoho Inventory.
Why?
We're enhancing the out-of-the-box integration from eBay to Zoho Inventory bespoke for a customer. We want the photo on eBay to be downloaded and uploaded to the Zoho Inventory record for the respective record. As Zoho Books and Zoho Subscriptions uses the same database tables as Zoho Inventory, and there's more documentation on the API for Zoho Books, we're going to apply this solution to Zoho Books.
How?
We're not going to go into detail on how to parse an eBay response here (see my other articles on eBay webhooks). Instead, all we want is the URL of an image to be downloaded, then uploaded to the Zoho Inventory or Zoho Books item record.