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
Error Code 4: Invalid value passed for JSONString
Okay, I want to start by saying I know I'm a terrible scripter, so sorry if this is a dumb mistake. I just can't figure it out, even with LLM help. Here's my code: // --- Input Variables --- customer_id = salesorder.get("customer_id"); so_id = salesorder.get("salesorder_id");
Organizing contacts/members by company
I work for a membership organization (representing businesses) and am trying to use Zoho CRM more effectively for managing the points of contact for our members. Currently, our members are listed in our CRM by the primary point of contact's name, but
Allow Stripe Credit Card and Stripe ACH payment methods to be enabled separately on an invoice.
I need to be able to pick at the invoice level whether Stripe Credit Card and/or Stripe ACH payment methods are available. Currently, I'm not able to select from the two Stripe payment methods individually on an invoice. However, there are some larger
Unable to search in Zoho Email
I've started using Zoho Email (free version) recently and realized that it doesn't have email search functionality. Am I missing anything here? I've gone through the Zoho tutorial which does show the search bar on the right top of the Zoho UI. But in
Response Time Report
From data to decisions: A deep dive into ticketing system reports Every organization that interacts with its customers should have an established timeframe for how soon an agent is expected to send the first response and any reply to any follow-up messages.
Problem : Auto redirect from zoho flow to zoho creator
Hi there, I've been waiting for zoho team to get back on this for last couple of days. Anyone else have the problem to access zoho flow? everytime I click on zoho flow it redirects me to zoho creator. I tried incognito mode but it still direct me to zoho
Zoho - Outlook plugin
Does anyone know if there is a way to modify the autofill in the Zoho plugin in outlook? When we create a contact, it enters the correct email address and name, but then pulls information from our own signature line to add phone number, address, etc.
Threaded conversations for emails sent via automation
Hi Guys, I hope you are doing well. Don't you guys think we should have an option in a workflow to notify users either as a new email or the previous email thread. For example, if you have one deal in the process and there are 10 different stages during
Zoho Books - Sales Person Information
Hi Team, On Invoices, Quotes, etc... I can include the Sales Person, but it only shows their name and not their email or phone number. It would be great to have place on invoice templates where we can manage what sales person information should be shows
Offline working in Zoho Creator portal
Zoho's help says that offline working is only available in the Creator mobile app and not in the portal app. But I can see offline options in the portal app too and it seems to work when I test it. My portal users are often in areas where there is poor
Fetch Records using Dynamic Criteria
Hi, I have a form that builds a filter based on user input. I need to fetch the records based on dynamic criteria. How would I accomplish this as there is no eval function? For example: desiredRecord = Form1[dynamicCriteria];
Url filter Report date (pivot chart)
Hello. Is it possible to filter the data in pivot char using parameters in the url? I'm trying but I should not doing very well. Something like: https://creator.zoho.com/.../....../#Report:MyPivotChartReport?MyDate=01-Jan-2012;31-Jun-2012;MyDate_op=58 Saludos
Sending gmail to a particular person fails because the address gets changed to "gmaill", with a second "l" typo somewhere
I send to bob@gmail.com (example) and get an error sending to bob@gmaill.com, only for this one person. Note the extra "l" in the email the system tried to send to, which was not in the address I entered. Can't find a typo in the contact or anywhere else
Emoji Support in Bigin CRM
We request the implementation of emoji support across Bigin CRM. This feature should allow users to seamlessly use emojis in text fields, headlines, and deals. It would enhance communication, improve the visual appeal of records, and bring more personalization
Bigin Booking Pages enhancements
I would like to ask for several enhancements for the brand new (and promising) Booking feature. 1. Add "Contact/Mobile" Field to Booking form We use Mobile as key (id), but unfortunately it is missing from the Booking form, only Home Phone is available.
Amount in words in Indian format
Hi, I had coded the following code to convert amount in words. But in the code in the format of US like million. But i need in Lakh and Crore. So pls suggest ideas r post corrected code string Num2Words(int val) { val_s = input.val.toString(); th = {"", "thousand", "million", "billion", "trillion"}; // uncomment this line for English Number System // th = {"","thousand","million", "milliard","billion"}; dg = {"zero", "one", "two", "three", "four", "five", "six", "seven", "eight",
What are people using to send Service based emails?
Zoho Campaigns is for marketing. Users can unsubscribe from these emails. Service based emails need to be delivered and can without the worry of Can-spam act. What are people using to send service based emails? My mailing list is derived from a database
Standalone LMS tool
Will Zoho release a standalone LMS (Learning management System) than can be used by external parties (guest)?
Announcing Kiosk 1.1 - Customize screen titles, configure new fields & actions, use values from your Kiosk to update fields, and more.
Hello all We are back again with more enhancements to Kiosk. So what's new? Enhancements made to the Components Add titles for your Kiosk screens and adjust its width to suit your viewing preferences. Three new fields can be added to your screen: Percentage,
An Overview of Dario Schiraldi Deutsche Bank Executive
Hello Community, Dario Schiraldi is an executive at Deutsche Bank, focused on advancing the firm’s financial services and crafting its global strategic vision. With 20 years of expertise in leadership roles, he has spearheaded successful market acquisitions
Emailing a document to WorkDrive
Does WorkDrive include the ability to upload a document by sending an attachment to an email address? (Books and Expenses include this functionality) If it doesn't is it under consideration? on the Road Map?
Allow Changing Appointment Status from "Completed" to "No Show" or Other Valid States
Hi Zoho Bookings Team, We hope you're doing well. We would like to submit a feature request regarding appointment status management in Zoho Bookings. 🎯 Use Case Sometimes, an appointment is mistakenly marked as Completed, but later we realize that the
Ability to modify what displays in calendar invite?
I am a long time calendly user and want to make the switch to bookings. I understand that there is not currently a meets/hangouts integration, is one on the roadmap? Is there anyway I can modify the calendar invite to include the meet link? I can add it to the emails no problem, but I would also like it to display on their calendar. Is there some work around I can do to get it on the calendar? Also am I able to modify the calendar event title?
Zoho One and Tally Integration
Has Anyone in this forum done any implementation with Zoho CRM and Tally accounting software. If so who have you used and how easy was it?
Microsoft PowerPoint files Extremely slow to save
I and others on my team have noticed that Microsoft PowerPoint documents are extremely slow to save when using WorkDrive. It always takes over 30 seconds to save a file. Word and Excel files seem to save in a typical length of time, but PowerPoint is
How can users unblock their blocked Zoho Mail accounts?
After the reason for the account block (storage exceeded, spam detection etc.) has been rectified, the user can unblock the account from the UnBlock Me page. Account support@edu2review.com Edu2Review is an education review platform, we rate the quality
Adding additional fields for batch information
Hello, I am looking at adding additional information into our inventory module. we would like to be able to see up to 8 attributes that will be individual & different for each batch (i.e. batch specific information) but currently I seem to only be able
Dynamic Pickup List Values using Deluge and Client Script
I would like to dynamically show Pickup List Values For example we need to fetch some data from an on premise application and display it so they can choose and pick This can be done in Creator but I didn't find anything for CRM
Validation Rule for Controlled Stage Movement in Deals Module (Deluge Script)
For keeping a control over module stage or status, you can use the below deluge script. The below deluge script defines validation control over deals module stages: // Function to validate allowed stage transitions in the Deals module map validation_rule.LeadStatustValidation1(String
Pick List Issues
I have created a pick list that looks at a table in a sheet, it selects the column I want fine. Various issues have come along. The option to sort the pick list is simplistic, only allows an ascending alphabetical sort. Bad luck if you want it descending.
Four types of task dependencies
"Nothing is particularly hard if you divide it into small jobs." - Henry Ford Projects, small or large, are driven by simple work units called tasks. Monitoring standalone tasks might look simple but as the workflow becomes elaborate, tasks may start relying on one another. In project management, this relationship between tasks is termed as "Task Dependencies". Dependency between tasks arise
1099 tracking
Do zoho books offer feature of tracking for 1099's for contractors, etc? Quick books offers this feature and wondered when/if Zoho books will do same
VAT-type Taxes in US Edition?
I'm located in the US, and I use the Zoho One US edition of Books. We are in the process of registering with Canadian authorities for their GST / HST, which is a VAT-type of scheme. It is not immediately obvious to me how one would deal with input tax
2 users editing the same record - loose changes
Hello, I'm very new to Zoho so apology if this has been addressed somewhere i can't find. I have noticed the following: If we have 2 users put an inventory item in edit mode at the same time: say user1 click on edit and user2 while user1 is still in edit,
Schedule sms to be sent later
When will you make available an option to send sms's at a later time??? You finaly have this option available on emails, so it will be very useful to have it also with sms. Our sms provider, has already this available but we cannot use it because you
Ecommerce integration with prestashop
Development of campaigns integration with prestahop. When???
How to create an article containing images and rich text via the api?
Hi, I'm trying to migrate our kb articles from our previous helpdesk service, and import them to ZohoDesk. Is there any way to create an article that contains images? Is it possible to add formatting to articles created via the API? Thanks, Adam.
Number of statement execution limit exceeded on deluge scheduled function
I'm working on a send email functionality in creator that sends out crew work orders at the end of the day each day for the next day. I'm running into the issue that zoho is unable to handle the number of statements that I am doing to be able to successfully
Color of Text Box Changes
Sometimes I find the color of text boxes changed to a different color. This seems to happen when I reopen the same slide deck later. In the image that I am attaching, you see that the colors of the whole "virus," the "irology" part of "virology," and
Zoho SignForm In Progress But Cannot Be Completed
If a person starts signing a document (via SignForm), but closes the window before submitting, Zoho marks the document "in progress", but how do they finish signing it?
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

Error Code 4: Invalid value passed for JSONString

Organizing contacts/members by company

Allow Stripe Credit Card and Stripe ACH payment methods to be enabled separately on an invoice.

Unable to search in Zoho Email

Response Time Report

Problem : Auto redirect from zoho flow to zoho creator

Zoho - Outlook plugin

Threaded conversations for emails sent via automation

Zoho Books - Sales Person Information

Offline working in Zoho Creator portal

Fetch Records using Dynamic Criteria

Url filter Report date (pivot chart)

Sending gmail to a particular person fails because the address gets changed to "gmaill", with a second "l" typo somewhere

Emoji Support in Bigin CRM

Bigin Booking Pages enhancements

Amount in words in Indian format

What are people using to send Service based emails?

Standalone LMS tool

Announcing Kiosk 1.1 - Customize screen titles, configure new fields & actions, use values from your Kiosk to update fields, and more.

An Overview of Dario Schiraldi Deutsche Bank Executive

Emailing a document to WorkDrive

Allow Changing Appointment Status from "Completed" to "No Show" or Other Valid States

Ability to modify what displays in calendar invite?

Zoho One and Tally Integration

Microsoft PowerPoint files Extremely slow to save

How can users unblock their blocked Zoho Mail accounts?

Adding additional fields for batch information

Dynamic Pickup List Values using Deluge and Client Script

Validation Rule for Controlled Stage Movement in Deals Module (Deluge Script)

Pick List Issues

Four types of task dependencies

1099 tracking

VAT-type Taxes in US Edition?

2 users editing the same record - loose changes

Schedule sms to be sent later

Ecommerce integration with prestashop

How to create an article containing images and rich text via the api?

Number of statement execution limit exceeded on deluge scheduled function

Color of Text Box Changes

Zoho SignForm In Progress But Cannot Be Completed

Next Page