Kaizen #86 - PHP SDK [Part III]

Hey there!

Welcome back to yet another insightful post in our Kaizen series!

In this post, we will continue the journey of PHP SDK sample codes for Record Operations from last week. Let us delve into a new set of use-cases and expand your horizons with additional examples in the Record and Send Mail Operations.

1. Subforms

To add subform details of a record during a record create/update, use the following format.

$subformVar = new Record();

$subformVar->addKeyValue("Subform_Field_API_Name", "FieldValue");

$record->addKeyValue("Subform_API_Name", [$subformVar]);

Repeat the second line of the above code to add as many fields as you have in your subform layout. To add multiple subform records, you will have to map the fields within a new object for each subform record.

Here is a sample code to update the details of a custom subform in Contacts.

<?php

use com\zoho\crm\api\HeaderMap;

use com\zoho\crm\api\record\BodyWrapper;

use com\zoho\crm\api\record\RecordOperations;

use com\zoho\crm\api\record\Contacts;

use com\zoho\crm\api\util\Choice;

use com\zoho\crm\api\record\Record;

require_once "vendor/autoload.php";

class UpdateRecord

{

public static function initialize()

{

// add initialisation code

// refer to the previous post for details and examples

}

public static function updateRecord1(string $moduleAPIName, string $recordId)

{

$recordOperations = new RecordOperations();

$request = new BodyWrapper();

$record = new Record();

$record->addFieldValue(Contacts::LastName(), "Boyle");

$subformRec1 = new Record();

$subformRec1->addKeyValue("Language_Proficiency", new Choice("English"));

$subformRec1->addKeyValue("Personal_Email", "patricia.boyle@zylker.com");

$subformRec1->addKeyValue("Secondary_Phone", "9876543210");

$record->addKeyValue("Proficiency_and_Others", [$subformRec1]);

$request->setData([$record]);

$headerInstance = new HeaderMap();

$response = $recordOperations->updateRecord($recordId, $moduleAPIName, $request, $headerInstance);

//Add your code to handle the response received in $response

// For more details, see here.

}

UpdateRecord::initialize();

$moduleAPIName = "Contacts";

$recordId = "5545974000002858001";

UpdateRecord::updateRecord1($moduleAPIName, $recordId);

2. Line Items and Line Taxes in Inventory Modules

2.1 Product Line Items and Product Line Taxes

To add or update product line items and their product line taxes in the Inventory module, use the following format.

$lineItemVar = new Record();

$lineItemProductVar = new LineItemProduct();

$lineItemProductVar->setId("product_id");

$lineItemVar->addKeyValue("Product_Name", $lineItemProductVar);

$lineItemVar->addKeyValue("Quantity", Value);

$lineItemVar->addKeyValue("ListPrice", Value);

$lineItemVar->addKeyValue("Discount", Value);

$productLineTaxVar = new LineTax();

$productLineTaxVar->setName("Tax_Name");

$productLineTaxVar->setPercentage(Value);

$lineItemVar->addKeyValue('Line_Tax', [$productLineTaxVar]);

Repeat this code to add multiple products to the inventory record.

Note that when you update any one of the line items in the inventory records, the remaining line items will become null and have to be re-added to the list.

2.2 Inventory Record Line Taxes

To add line taxes to an inventory record, use the following format.

$lineTaxVar = new LineTax();

$lineTaxVar->setName("Tax_Name");

$lineTaxVar->setPercentage(Value);

$record->addKeyValue('$line_tax', [$lineTaxVar]);

The 'line_tax' represents the tax amount specific to each line item. Whereas, the '$line_tax' represents the tax applied to the overall products in the line item list.

Following is a sample code to create a record in the Quotes module.

<?php

use com\zoho\crm\api\HeaderMap;

use com\zoho\crm\api\record\BodyWrapper;

use com\zoho\crm\api\record\LineTax;

use com\zoho\crm\api\record\LineItemProduct;

use com\zoho\crm\api\record\RecordOperations;

use com\zoho\crm\api\record\{Accounts, Contacts, Quotes, Deals};

use com\zoho\crm\api\record\Record;

require_once "vendor/autoload.php";

class CreateRecords

{

public static function initialize()

{

// add initialisation code

// refer to the previous post for details and examples

}

public static function createRecords(string $moduleAPIName)

{

$recordOperations = new RecordOperations();

$bodyWrapper = new BodyWrapper();

$record = new Record();

$record->addFieldValue(Quotes::Subject(), "Quote No 1");

$AccountName = new Record();

$AccountName->addFieldValue(Accounts::id(), "55459742858119");

$record->addFieldValue(Quotes::AccountName(), $AccountName);

$dealName = new Record();

$dealName->addFieldValue(Deals::id(), "55459742858125");

$record->addFieldValue(Quotes::DealName(), $dealName);

$contactName = new Record();

$contactName->addFieldValue(Contacts::id(), "55459742858122");

$record->addFieldValue(Quotes::ContactName(), $contactName);

//product 1

$inventoryLineItem1 = new Record();

$lineItemProduct1 = new LineItemProduct();

$lineItemProduct1->setId("55459742897004");

$inventoryLineItem1->addKeyValue("Product_Name", $lineItemProduct1);

$inventoryLineItem1->addKeyValue("Quantity", 2.0);

$inventoryLineItem1->addKeyValue("ListPrice", 150.0);

$inventoryLineItem1->addKeyValue("Discount", "5%");

$productLineTax = new LineTax();

$productLineTax->setName("Sales Tax");

$productLineTax->setPercentage(2.0);

$inventoryLineItem1->addKeyValue('Line_Tax', [$productLineTax]);

//product 2

$inventoryLineItem2 = new Record();

$lineItemProduct2 = new LineItemProduct();

$lineItemProduct2->setId("55459742897009");

$inventoryLineItem2->addKeyValue("Product_Name", $lineItemProduct2);

$inventoryLineItem2->addKeyValue("Quantity", 1.0);

$inventoryLineItem2->addKeyValue("ListPrice", 100.0);

$inventoryLineItem2->addKeyValue("Discount", "3%");

$productLineTax1 = new LineTax();

$productLineTax1->setName("Sales Tax");

$productLineTax1->setPercentage(2.0);

$productLineTax2 = new LineTax();

$productLineTax2->setName("Vat");

$productLineTax2->setPercentage(4.0);

$inventoryLineItem2->addKeyValue('Line_Tax', [$productLineTax1, $productLineTax2]);

$record->addKeyValue("Quoted_Items", [$inventoryLineItem1, $inventoryLineItem2]);

//line taxes

$lineTax1 = new LineTax();

$lineTax1->setName("Sales Tax");

$lineTax1->setPercentage(2.0);

$lineTax2 = new LineTax();

$lineTax2->setName("Vat");

$lineTax2->setPercentage(2.0);

$record->addKeyValue('$line_tax', [$lineTax1, $lineTax2]);

$bodyWrapper->setData([$record]);

$headerInstance = new HeaderMap();

$response = $recordOperations->createRecords($moduleAPIName, $bodyWrapper, $headerInstance);

//Add your code to handle the response received in $response

// For more details, see here.

}

CreateRecords::initialize();

$moduleAPIName = "Quotes";

CreateRecords::createRecords($moduleAPIName);

3. Events and Tasks Module Operations

3.1 Add and Update Participants in Events

There are two methods to add participants to an event. In the first method, use the record ID of the contact, lead or user.

$participantVar = new Participants();

$participantVar->addKeyValue("participant", "record_id");

$participantVar->addKeyValue("type", "record_module");

$record->addFieldValue(Events::Participants(), [$participantVar]);

In the second method, mention the participant's email ID with the type key specified as email.

$participantVar = new Participants();

$participantVar->setParticipant("name@domain.com");

$participantVar->setType("email");

$record->addFieldValue(Events::Participants(), [$participantVar]);

In the above code snippet, setParticipant() is a method used to assign a new value to the participant field.

3.2 Reminder in Events

To create/update reminders for any event, use the following format.

$reminderVar = date_create("YYYY-MM-DDThh:mm:ss.sssZ", new \DateTimeZone(date_default_timezone_get()));

$record->addFieldValue(Events::FieldName(), $reminderVar);

Here date_create() function is used to create the DateTime object with two parameters. The first parameter represents for the DateTime string and the following represents for the time zone.

3.3. Reminder in Tasks

To create/update reminder for a task, use the following format.

$remindAtVar = new RemindAt();

$remindAtVar->setAlarm("ACTION=Value;TRIGGER=Condition;TRIGGER_TIME=hh:mm");

$record->addFieldValue(Tasks::FieldName(), $remindAtVar);

In the above code, the setAlarm() method is used to set the reminder properties. The multiple key-value pairs in the string argument denote the properties of your reminder. Following are the representation of keys for this field type.

ACTION - Specifies the notification type of the reminder.
TRIGGER - Defines the trigger condition that activates the reminder.
TRIGGER_TIME - Indicates the time at which the alarm should be triggered.

Refer to this document, to learn more about these key-value pairs and their possible values.

3.4 Recurring Activity in Events and Tasks

Use the following format to create a recurring event.

$recurringActivityVar = new RecurringActivity();

$recurringActivityVar->setRrule("FREQ=value;INTERVAL=value;BYMONTH=mm;BYMONTHDAY=dd;

DTSTART=yyyy-mm-dd;UNTIL=yyyy-mm-dd");

$record->addFieldValue(Module_API_Name::FieldName(), $recurringActivityVar);

Here, the setRrule() method is used to define the elements that determine the recurrence of the activity. This format is common for all the activity modules. To know more about the Rrule elements, refer to this post.

Below is a sample code to create an event using the above field types.

<?php

use com\zoho\crm\api\HeaderMap;

use com\zoho\crm\api\record\BodyWrapper;

use com\zoho\crm\api\record\Participants;

use com\zoho\crm\api\record\RecordOperations;

use com\zoho\crm\api\record\RecurringActivity;

use com\zoho\crm\api\record\Events;

use com\zoho\crm\api\record\Record;

require_once "vendor/autoload.php";

class CreateRecords

{

public static function initialize()

{

// add initialisation code

// refer to the previous post for details and examples

}

public static function createRecords1(string $moduleAPIName)

{

$recordOperations = new RecordOperations();

$BodyWrapper = new BodyWrapper();

$record = new Record();

$record->addFieldValue(Events::EventTitle(), "Test Events");

$startdatetime = date_create("2023-05-16T23:03:06+05:30", new \DateTimeZone(date_default_timezone_get()));

$record->addFieldValue(Events::StartDateTime(), $startdatetime);

$enddatetime = date_create("2023-05-16T23:45:06+05:30", new \DateTimeZone(date_default_timezone_get()));

$record->addFieldValue(Events::EndDateTime(), $enddatetime);

//add participants

$participant1 = new Participants();

$participant1->setParticipant("patricia.boyle@zylker.com");

$participant1->setType("email");

$participant2 = new Participants();

$participant2->addKeyValue("participant", "5545974000002858122");

$participant2->addKeyValue("type", "contact");

$record->addFieldValue(Events::Participants(), [$participant1, $participant2]);

//event reminder

$remindAt = date_create("2023-05-16T21:00:06+05:30", new \DateTimeZone(date_default_timezone_get()));

$record->addFieldValue(Events::RemindAt(), $remindAt);

//recurring event

$recurringActivity = new RecurringActivity();

$recurringActivity->setRrule("FREQ=YEARLY;INTERVAL=1;BYMONTH=5;BYMONTHDAY=16;DTSTART=2023-05-16;UNTIL=2026-05-16");

$record->addFieldValue(Events::RecurringActivity(), $recurringActivity);

$BodyWrapper->setData([$record]);

$headerInstance = new HeaderMap();

$response = $recordOperations->createRecords($moduleAPIName, $BodyWrapper, $headerInstance);

//Add your code to handle the response received in $response

// For more details, see here.

}

CreateRecords::initialize();

$moduleAPIName = "Events";

CreateRecords::createRecords1($moduleAPIName);

Here is a sample code for creating a recurring task with a reminder.

<?php

use com\zoho\crm\api\HeaderMap;

use com\zoho\crm\api\record\BodyWrapper;

use com\zoho\crm\api\record\RecordOperations;

use com\zoho\crm\api\record\RecurringActivity;

use com\zoho\crm\api\record\RemindAt;

use com\zoho\crm\api\record\Tasks;

use com\zoho\crm\api\record\Record;

require_once "vendor/autoload.php";

class CreateRecords

{

public static function initialize()

{

// add initialisation code

// refer to the previous post for details and examples

}

public static function createRecords1(string $moduleAPIName)

{

$recordOperations = new RecordOperations();

$bodyWrapper = new BodyWrapper();

$record = new Record();

$record->addFieldValue(Tasks::Subject(), "Follow-up call");

//task reminder

$remindAt = new RemindAt();

$remindAt->setAlarm("ACTION=EMAIL;TRIGGER=-P0D;TRIGGER_TIME=14:20");

$record->addFieldValue(Tasks::RemindAt(), $remindAt);

// recurring task

$recurringActivity = new RecurringActivity();

$recurringActivity->setRrule("FREQ=WEEKLY;INTERVAL=1;UNTIL=2023-06-01;BYDAY=TH;DTSTART=2023-06-01");

$record->addFieldValue(Tasks::RecurringActivity(), $recurringActivity);

$bodyWrapper->setData([$record]);

$headerInstance = new HeaderMap();

$response = $recordOperations->createRecords($moduleAPIName, $bodyWrapper, $headerInstance);

//Add your code to handle the response received in $response

// For more details, see here.

}

CreateRecords::initialize();

$moduleAPIName = "Tasks";

CreateRecords::createRecords1($moduleAPIName);

5. Send Email

You can either use an email or inventory template to send mail or write your own HTML/text body for the email. Refer to this sample code on GitHub to know how to fetch the inventory template IDs. To use a template in your email follow the below structure.

$mail = new Mail();

$templateVar = new EmailTemplate();

$templateVar->setId(template_id);

$mail->setTemplate($templateVar);

Use the following format to write your own email body.

$mail = new Mail();

$mail->setContent("your_html_content");

$mail->setMailFormat("html");

To specify plain text as the value for the setContent() method, you have to set text as the value for the setMailFormat() method.

Here is a sample code of send mail using email template for your reference.

<?php

use com\zoho\crm\api\sendmail\SendMailOperations;

use com\zoho\crm\api\sendmail\Mail;

use com\zoho\crm\api\emailtemplates\EmailTemplate;

use com\zoho\crm\api\sendmail\BodyWrapper;

use com\zoho\crm\api\sendmail\UserAddress;

//use com\zoho\crm\api\inventorytemplates\InventoryTemplate;

require_once "vendor/autoload.php";

class SendMail

{

public static function initialize()

{

// add initialisation code

// refer to the previous post for details and examples

}

public static function sendMail1(string $recordId, string $moduleAPIName)

{

$sendMailOperations = new SendMailOperations();

$mail = new Mail();

$from = new UserAddress();

$from->setUserName("Patricia Boyle");

$from->setEmail("patricia.boyle@zylker.com");

$mail->setFrom($from);

$to = new UserAddress();

$to->setUserName("Carissa Kidman");

$to->setEmail("carissa-kidman@yahoo.com");

$mail->setTo([$to]);

$mail->setSubject("Mail subject");

//use this for customized email body

//$mail->setContent("Hello! Thank you for shopping with us!");

//$mail->setMailFormat("text");

//use this for inventory template

//$template = new InventoryTemplate();

//$template->setId("55459741230768");

//$mail->setTemplate($template);

$template = new EmailTemplate();

$template->setId("55459741230058");

$mail->setTemplate($template);

$mail->setConsentEmail(true);

$wrapper = new BodyWrapper();

$wrapper->setData([$mail]);

$response = $sendMailOperations->sendMail($recordId, $moduleAPIName, $wrapper);

//Add your code to handle the response received in $response

// For more details, see here.

}

SendMail::initialize();

$recordId = "5545974000002935001";

$moduleAPIName = "Contacts";

SendMail::sendMail1($recordId, $moduleAPIName);

We hope you found this post useful and engaging!

If you have any queries, feel free to drop them in the comments section below or reach out to us directly at support@zohocrm.com. We eagerly await your thoughts and feedback on this!

Keep an eye out for future posts packed with similar content!

Cheers!

Additional Reading

PHP SDK - Configuration and Initialization Process, Sample Codes for Record Operations
Subforms - Subforms API
Product line items and line taxes - Insert Records API, Handling Product Line Items, Sales Orders API
Events and Tasks Module Operations - Insert Records API, Handling Recurrence and Participants in Events Module
Send Mail - Send Mail API, Email Templates API, Inventory Templates API

Topic Participants
Kiruthiga G

Sticky Posts
Kaizen #152 - Client Script Support for the new Canvas Record Forms
Hello everyone! Have you ever wanted to trigger actions on click of a canvas button, icon, or text mandatory forms in Create/Edit and Clone Pages? Have you ever wanted to control how elements behave on the new Canvas Record Forms? This can be achieved
Kaizen #197: Frequently Asked Questions on GraphQL APIs
🎊 Nearing 200th Kaizen Post – We want to hear from you! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.
Kaizen #198: Using Client Script for Custom Validation in Blueprint
Nearing 200th Kaizen Post – 1 More to the Big Two-Oh-Oh! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.
Celebrating 200 posts of Kaizen! Share your ideas for the milestone post
Hello Developers, We launched the Kaizen series in 2019 to share helpful content to support your Zoho CRM development journey. Staying true to its spirit—Kaizen Series: Continuous Improvement for Developer Experience—we've shared everything from FAQs
Kaizen #193: Creating different fields in Zoho CRM through API
🎊 Nearing 200th Kaizen Post – We want to hear from you! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.

Recent Topics
Show backordered items on packing slip
We send out a lot of large orders, and often there are one or two things backordered. How can I fix the packing slips to show quantity ordered & quantity packed There should also be the ability to "ship" 0 of an item so the receiver knows that things
Document | Files
The vendor "Partial matches" still not fixed here after years of putting up with having to select most vendors manually ! ( again, the banking "Transaction rules" would solve a lot of these issues ) Some unwanted, irrelevant pdf's also arrive. It would
books+POS+ tap to pay+ stripe
So in the UK we now have tap to pay with stripe. So we can use the stripe app as a POS terminal. Brilliant news. Can we hope that the Books App might add this feature ASAP. It would be great to have one system rather than using the not very good Square
Canvas Form View - Client Script Page on load - Url params not working
We have a custom module with a canvas page for form view. We have a button in Customers module to open this canvas page using invokeurl function. We send few parameters as in the URL as query parameters. https://crm.zoho.in/crm/orgxxxxxxxx/tab/CustomModule12/create/canvas/64333200000261xxxx?layoutId=643332000002605001&c=${Customers.Customer
Sending Recruit SMS's to Zoho Cliq - Or tracking in the Messages module in Recruit?
Is there any way to send SMS Gateway messages in Recruit to ZOho Cliq? We use 2-way SMS massages a lot in Zoho Recruit to speed up communication with Candidates. However the only way to keep track of received SMS's is by keeping a look out for the Email
This mobile number has been marked spam. Please contact support.
Hi Support, Can you tell me why number was marked as spam. I have having difficult to add my number as you keep requesting i must use it. My number is +63....163 Or is Zoho company excluding Philippines from their services?
Zohomail does not support additional fields in mailto links
Hello, I set up Zohomail as default composer in Firefox according to manual here: https://www.zoho.com/mail/help/defaultcomposer.html#alink2 Later, I wanted to use this functionality to answer in a Linux mailing list thread using mailto link: mailto:xxxxx@kernel.org?In-Reply-To=%3C727o0521-q24p-s0qq-66n0-sn436rpqqr1p@example.com%3E&Cc=xxxxx%example.org&Subject=Re%3A%20%5BPATCH%20v2%28%29
Is it possible to set a customer context variable in Zobot
Hi, I want to use a context variable to route users down different paths in my Zobot chat flow. I know I can do this when the user enters data. But I want to know if I can use a variable that is 'hard coded' on the card, that the user is unaware of. Use
Cannot change Blog Title
There is nowhere to change the blog title. You can change the blog URL but that is making no difference to the text "Enter Your Post Title" am I missing something?
Kaizen #203 - Answering Your Questions | Handling API Limits and Error Responses
Hi Everyone, Welcome back to yet another post in the Kaizen Series! We appreciate your keen participation in the 200th milestone celebration of the Kaizen series. We will continue to answer the queries we received through the feedback. When working with
How to verify website ownership with google search console
Hi, I am having a free .in domain provided by Zoho I have created a website on it now I want to verify my ownership to google webmaster. Can you please help me how to do that.
Kaizen #89 - Color Coding using Client Script
Hello everyone! Welcome back to another exciting Kaizen post. Today let us see how you can apply color codes to the List and Detail Pages of Zoho CRM using Client Script. Need for color code in Zoho CRM When you mark things with different colors as a
"SPF record exceed the allowed limit of 10"
Hi, I was wondering if there were a "universal Zoho SPF record" that would allow all my configured Zoho services that email things to meet this limitation ? or do I have to have an entry for mail, com, billing, etc?
Zoho Mail android app update: Block & reject future emails, Report phishing, Spam alerts, Suspicious URL detection
Hello everyone! In the most recent Zoho Mail Android app update, we have brought in support for the following features: Block & reject future emails Report Phishing Spam alerts in the mail details screen. Suspicious URL detection. Block & reject future
Animated GIF Images in Chat
I know this seems to be a small feature request but in a recent Cliq update Zoho disabled autoplay for animated GIFs posted in Cliq conversations. We think this was not a good change. In our organization, animated GIFs in a chat play a role in expressing
I can't seem to login in to Mail Apps of MacOS /IOS
Hi, i'm having trouble in signing in to mail apps from IOS. It's always come back to wrong passwords. But i already changed my password like 3 times. But still it says wrong credentials
Profile Image Showing Incorrectly in Zoho Mail
Hi everyone, I’m facing a serious issue with Zoho Mail. The profile image showing for my email address is incorrect — it’s not my image. When I send an email to my Gmail account, it displays someone else’s image. This looks very suspicious and can make
I need access to my old email
I need access to my old email bromzeman@zoho.com to verify it for forwarding. I can’t access the inbox to get the confirmation code. Please assist with recovery or forwarding. as you might already know, they made alot of the email addresses to have that
Set Defaults for Email Groups
Is there a way to set defaults for all of the groups that I establish as a moderator? For example, I want every group I establish to have the following settings: 1. Moderator is <user> 2. User is <user>, <user> 3. Notifications for new group turned
LOGS FOR RECEIVED MAIL ( READ DATE & TIME)
In Zoho mail we can extract the read logs of received mails so that we can see when we have read the mail and at what time & we have read it.
Domain verification probem
Hello, i use a domain from Namecheap with hosting from Cinfu when i try to verify my domain on zoho i get "TXT Verification failure" i even tried the HTML verification and the code appears but also giving me the verification failure error.
Switching to Cloudflare email routing from Zoho Mail
Hello, I'm currently working on migrating from Zoho Mail to Cloudflare's email routing solution. This requires changing MX and TXT records for our custom domain - when we do this, will our users still be able to log into their accounts and access an archived
Un Subscription Button
How can i Add the Un Subscription Button in Zoho mail
Documents unable view and need to downlad
I can't view .doc files in Zoho mail unless I download them, but I can view PDF files without downloading.
we encountered a problem while sending your email. please try again later.
Adding and removing people from groups
We're having problems adding people to a group. Apparently Zoho has one email address and will not recognize a different email address.
MAIL SEARCH IS NOT WORKING
THIS ISSUE HAS BEEN BUGGING ME SINCE MORNING, PLEASE RESOLVE THIS AT THE EARLIEST
URL Parameter on Help Center SIgn in link
Is it possible to add a url parameter to the sign in link on the Help Center?
migrating from HelpScout
I am attempting to import a conversation file from helpscout into desk and am receiving size errors. What is the current file size restriction. Does anyone have any tips for a successful migration?
Layout Rules Don't Apply To Blueprints
Hi Zoho the conditional layout rules for fields and making fields required don't work well with with Blueprints if those same fields are called DURING a Blueprint. Example. I have field A that is used in layout rule. If value of field A is "1" it is supposed to show and make required field B. If the value to field A is "2" it is supposed to show and make required field C. Now I have a Blueprint that says when last stage moves to "Closed," during the transition, the agent must fill out field A. Now
Article Name Sorting in Zoho Desk Knowledge Base (agent / admin side)
Dear Zoho Desk Support, We are writing to request an enhancement to the Knowledge Base management feature within Zoho Desk. Currently, there is no option to sort articles by their name, which significantly hinders efficient article management, especially
How to parse JSON data with SQL in Zoho Analytics?
Hi all, I have a column with JSON data. I want to show this column in a chart, but it is very messy, and no JSON parsing function is supported on Zoho Analytics. data example: {"id": 5, "status": "false", "date": "15/10/22"} what I want to do in SQL is
Ability to turn off "Would you like this amount to be reflected in the Payment field?" message
Team, Is there any way to turn off the message" Would you like this amount to be reflected in the Payment field?" when I make a payment? This is so annoying. This happens EVERY TIME I put an amount in the Payment Made field.
Add an Equation Field (Or update the Formula Field)
Hi, I would like to be able to have one field as a Text Field with QR Code, and then have multiple Equation/Formula Fields that then take parts of that fields data with LEFT, MID, RIGHT, REGEX, etc. Thanks Dan
How to parse column having JSON data using SQL?
We have a daily sync from a PostgreSQL database that brings data into Zoho Analytics. Some of the columns store raw JSON data. We need to build SQL queries on top to parse data from JSON and store them in discrete columns. There is no option for "Data
Enable report button based on the current user role
Greetings i have a report that contains action buttons, i want these buttons to appear as enabled only when the current logged in user has a certain role, for example only CEO role users will be able to use this button. but when setting the conditions
500 Internal Error In Mail API
I'm getting 500 Internal Error when using mail API. I'm getting this error for this one account, it works fine for other Account IDs which I have in my system.
Piss poor service in Support in Domains and email
Srijith Narayanan B contacted me today. Very pleasant fellow. Just didn't want to tell him how bad your support service is. You help the person, but you leave before we can finish the next stage. Which causes a lot of frustration. It's been 8 days now
Zoho live chat widget in React Js
I am trying to test Zoho live chat widget code in react js, below is the sample code void(0)} onClick={()=>window.$zoho.salesiq.floatwindow.visible("show")}>LIVE CHAT window.$zoho = window.$zoho || {};window.$zoho.salesiq = window.$zoho.salesiq
Are there any plans to add Triggers for Subform edits?
By The Grace of G-D. Hi, How are you? Can you tell me if you have any plans to support subform edit as a workflow trigger? And what about have them trigger an "onChange" client script?
Next Page

Kaizen #86 - PHP SDK [Part III]

Kaizen #86 - PHP SDK [Part III]

1. Subforms

2. Line Items and Line Taxes in Inventory Modules

2.1 Product Line Items and Product Line Taxes

2.2 Inventory Record Line Taxes

3. Events and Tasks Module Operations

3.1 Add and Update Participants in Events

3.2 Reminder in Events

3.3. Reminder in Tasks

3.4 Recurring Activity in Events and Tasks

5. Send Email

Additional Reading

Topic Participants

Kiruthiga G

Sticky Posts

Kaizen #152 - Client Script Support for the new Canvas Record Forms

Kaizen #197: Frequently Asked Questions on GraphQL APIs

Kaizen #198: Using Client Script for Custom Validation in Blueprint

Celebrating 200 posts of Kaizen! Share your ideas for the milestone post

Kaizen #193: Creating different fields in Zoho CRM through API

Recent Topics

Show backordered items on packing slip

Document | Files

books+POS+ tap to pay+ stripe

Canvas Form View - Client Script Page on load - Url params not working

Sending Recruit SMS's to Zoho Cliq - Or tracking in the Messages module in Recruit?

This mobile number has been marked spam. Please contact support.

Zohomail does not support additional fields in mailto links

Is it possible to set a customer context variable in Zobot

Cannot change Blog Title

Kaizen #203 - Answering Your Questions | Handling API Limits and Error Responses

How to verify website ownership with google search console

Kaizen #89 - Color Coding using Client Script

"SPF record exceed the allowed limit of 10"

Zoho Mail android app update: Block & reject future emails, Report phishing, Spam alerts, Suspicious URL detection

Animated GIF Images in Chat

I can't seem to login in to Mail Apps of MacOS /IOS

Profile Image Showing Incorrectly in Zoho Mail

I need access to my old email

Set Defaults for Email Groups

LOGS FOR RECEIVED MAIL ( READ DATE & TIME)

Domain verification probem

Switching to Cloudflare email routing from Zoho Mail

Un Subscription Button

Documents unable view and need to downlad

we encountered a problem while sending your email. please try again later.

Adding and removing people from groups

MAIL SEARCH IS NOT WORKING

URL Parameter on Help Center SIgn in link

migrating from HelpScout

Layout Rules Don't Apply To Blueprints

Article Name Sorting in Zoho Desk Knowledge Base (agent / admin side)

How to parse JSON data with SQL in Zoho Analytics?

Ability to turn off "Would you like this amount to be reflected in the Payment field?" message

Add an Equation Field (Or update the Formula Field)

How to parse column having JSON data using SQL?

Enable report button based on the current user role

500 Internal Error In Mail API

Piss poor service in Support in Domains and email

Zoho live chat widget in React Js

Are there any plans to add Triggers for Subform edits?

Next Page