Kaizen 144 - Assigning values to different field types using Zoho CRM SDKs - Part II
Welcome to another week of our Kaizen series!
In our last week's Kaizen post, we explored the various field types in Zoho CRM and their typical uses. We also discussed the utility of our SDK sample codes available in our GitHub repositories and how they can be tailored to meet your specific needs. For effective implementation, understanding how to assign values to these different field types using the SDK is crucial, which remains our primary focus in this series.
Last week, we covered this topic using our JAVA SDK. This week, we will discuss assigning values using PHP SDK. To make sure you are all caught up, please revisit Part I before proceeding further.
2. PHP SDK
For more details, please refer to the GitHub repository for our latest PHP SDK. Check out the sample codes here.
Standard Fields:
a. Import the Field Class:
- use com\zoho\crm\api\record\{module_api_name};
b. Assign Values to Standard Fields: The syntax for assigning values to standard fields uses the addFieldValue method of the Record object:
- $record->addFieldValue({module_api_name}::{field_api_name}(), value);
Replace {module_api_name} and {field_api_name} with the appropriate values for your specific use case.
Assigning values to Standard Fields:
| Field Type JSON Type |
Assign Values | Assign Null Value |
| text (single line)
string |
$record->addFieldValue(Leads::LastName(), "Boyle"); | $record->addFieldValue(Leads::LastName(), null); |
| textarea (multiline)
string |
$record->addFieldValue(Leads::Description(), "Specify your description") | $record->addFieldValue(Leads::Description(), null); |
| email
string |
$record->addFieldValue(Leads::Email(), "abc@zoho.com"); | $record->addFieldValue(Leads::Email(), null); |
| phone
string |
$record->addFieldValue(Leads::Phone(), "91(987)654321"); | $record->addFieldValue(Leads::Phone(), null); |
| picklist
string |
$record->addFieldValue(Leads::LeadStatus(), new Choice("Not Contacted")); | -- |
| date string |
$record->addFieldValue(Products::Sales_Start_Date(), new DateTime(2024, 6, 13).Date); | $record->addFieldValue(Products::Sales_Start_Date(), null); |
| integer (number) integer |
$record->addFieldValue(Accounts::Employees(), 100); | $record->addFieldValue(Accounts::Employees(), 100); |
| currency (double)
double |
$record->addFieldValue(Leads::AnnualRevenue(), 10.00); | $record->addFieldValue(Leads::AnnualRevenue(), null); |
| boolean (checkbox) boolean | $record->addFieldValue(Leads::EmailOptOut(), true); | -- |
| website (URL) string |
$record->addFieldValue(Leads::Website(), "https://www.zoho.com"); | $record->addFieldValue(Leads::Website(), null); |
Custom Fields:
To manage custom fields using PHP SDK:
a. Import the Record Class:
- use com\zoho\crm\api\record\Record;
- $record = new Record();
b. Assign Values to Custom Fields: The syntax for assigning values to standard fields uses the AddKeyValue method of the Record object:
- $record->addKeyValue("{field_api_name}", value);
Replace {field_api_name} with the appropriate values for your specific use case.
Assigning values to Custom Fields:
Field Type JSON Type | Assign Value | Assign Null Value |
text (single line) string | $record->addKeyValue("Single_Line_Field", "Text Single Line"); | $record->addKeyValue("Single_Line_Field", null); |
textarea (multiline) string | $record->addKeyValue("Multi_Line_Field", "Text Multi Line"); | $record->addKeyValue("Multi_Line_Field", null); |
email string | $record->addKeyValue("Email_Field", "abc@zoho.com"); | $record->addKeyValue("Email_Field", null); |
phone string | $record->addKeyValue("Phone_Field", "9900000000"); | $record->addKeyValue("Phone_Field", null); |
picklist string | $record->addKeyValue("Pick_List_Field", new Choice("Option 1")); | $record->addKeyValue("Pick_List_Field", null); |
multiselectpicklist JSON array | $record->addKeyValue("Multi_Select_Field", [new Choice("Option 1"), new Choice("Option 2")]); | $record->addKeyValue("Multi_Select_Field", null); |
date string | $record->addKeyValue("Date_Field", (new \DateTime('2024-06-13'))); | $record->addKeyValue("Date_Field", null); |
datetime string | $record->addKeyValue("Date_Time_Field", date_create("2024-06-20T11:10:00+05:30")->setTimezone(new \DateTimeZone(date_default_timezone_get()))); | $record->addKeyValue("Date_Time_Field", null); |
integer (number) integer | $record->addKeyValue("Number_Field", 12); | $record->addKeyValue("Number_Field", null); |
currency (double) double | $record->addKeyValue("Currency_Field", 10.25); | $record->addKeyValue("Currency_Field", null); |
double double | $record->addKeyValue("Decimal_Field", 12.25); | $record->addKeyValue("Decimal_Field", null); |
percent double | $record->addKeyValue("Percent_Field", 12.25); | $record->addKeyValue("Percent_Field", null); |
bigint (long integer) string | $record->addKeyValue("Long_Integer_Field", "12345678"); | $record->addKeyValue("Long_Integer_Field", null); |
boolean (checkbox) boolean | $record->addKeyValue("Checkbox_Field", true); | -- |
website (URL) string | $record->addKeyValue("URL_Field", "https://www.zoho.com"); | $record->addKeyValue("URL_Field", null); |
lookup JSON Object | $account = new Record(); $account->setId("3477061000023362051"); $record->addKeyValue("Lookup_Field", $account); | $record->addKeyValue("Lookup_Field", null); |
multiselectlookup JSON array | $record1 = new Record(); $linkingRecord = new Record(); $record1->addKeyValue("id", "3477061000023362051"); $linkingRecord->addKeyValue("Multi_Select_Lookup_Field", $record1); $record->addKeyValue("Multi_Select_Lookup_Field", [$linkingRecord]); | $linkingRecord = new Record(); $linkingRecord->addKeyValue("_delete", true); $linkingRecord->addKeyValue("id", "3477061000023557067"); $record->addKeyValue("Multi_Select_Lookup_Field", [$linkingRecord]); |
userlookup JSON object | $user = new MinifiedUser(); $user->setId("3477061000005791024"); $record->addKeyValue("User_Field", $user); | $record->addKeyValue("User_Field", null); |
multiuserlookup JSON array | $record1= new Record(); $linkingRecord = new MinifiedUser(); $linkingRecord->setId("3477061000005791024"); $record1->addKeyValue("MultiUser", $linkingRecord); $record->addKeyValue("MultiUser", [$record1]); | $record1 = new Record(); $record1->addKeyValue("_delete", true); $record1->setId("3477061000023553042"); $record->addKeyValue("MultiUser", [$record1]); |
subform JSON array | $subform = new Record(); $subform->addKeyValue("Name", "SDK"); $user1 = new MinifiedUser(); $user1->setId("3477061000018959001"); $subform->addKeyValue("User_Field", $user1); $record->addKeyValue("Subform_Field", [$subform]); | $subform = new Record(); $subform->addKeyValue("_delete", true); $subform->setId("3477061000023557086"); $record->addKeyValue("Subform_Field", [$subform]); |
imageupload JSON array | $imageUpload = new ImageUpload(); $imageUpload->setFileIdS("138ef2d9af5"); $record->addKeyValue("Image_Upload", [$imageUpload]); | $imageUpload = new ImageUpload(); $imageUpload->setDelete(null); $imageUpload->setId("3477061000023579023"); $record->addKeyValue("Image_Upload", [$imageUpload]); |
fileupload JSON array | $fileDetail1 = new FileDetails(); $fileDetail1->setFileIdS("54957bcbc8fa685"); $record->addKeyValue("File_Upload", [$fileDetail1]); | $fileDetail1 = new FileDetails(); $fileDetail1->setDelete(null); $fileDetail1->setId("3477061000023551042"); $record->addKeyValue("File_Upload", [$fileDetail1]); |
multi_module_lookup JSON Object | $record1 = new Record(); $record1->setId("3477061000021552002"); $module = array(); $module["id"] = "3477061000000002179"; $module["api_name"] = "Contacts"; $record1->addKeyValue("module", $module); $record->addKeyValue("Appointment_For", $record1); | -- |
We trust this post has given you a better understanding of managing field data types in Zoho CRM using our PHP SDK. Remember that this learning does not end here. We have more posts coming up where we will explore handling field data types with our remaining SDK offerings. And do not forget to check out our Github for code samples.
As we strive for continuous improvement, we would love to hear your feedback. What topics would you like to see covered in our Kaizen series? Let us know in the comments or reach out to our support team at support@zohocrm.com.
Thank you for joining us this week. Happy coding and until next time!
Recommended Reads:
Previous Post : Assigning values to different field types using SDKs - Part I | Kaizen Collection : Home
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Anu Abraham
Sticky Posts
Client Script | Update - Introducing Commands in Client Script!
Have you ever wished you could trigger Client Script from contexts other than just the supported pages and events? Have you ever wanted to leverage the advantage of Client Script at your finger tip? Discover the power of Client Script - Commands! CommandsKaizen #165 : How to call Zoho CRM APIs using Client Script
Welcome back to another exciting Client Script post! In this post, we will discuss one of the most frequently asked questions: How do you call Zoho CRM APIs from Client Scripts? In this kaizen post, 1. Ways to make calls to Zoho CRM APIs using ClientKaizen#162 : Add Tags and Open Pre-filled Email Drafts via Client Scripts
Hello everyone! Welcome to another informative Kaizen post. In this post, let us see how to accomplish the following using Client Script. 1. How to auto-tag a record based on field update? 2. How to Open a pre-filled email draft This post will provideExtension Pointers - JS SDK series #4: Managing data from a widget using ZOHO.CRM.HTTP
Handling and managing the data between two applications is a major factor for an efficient business. There are a variety of ways to handle data between Zoho CRM and other third-party applications. You can use deluge CRM tasks, create connectors, use APIKaizen #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
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Placeholder for Agent Signature in Email Templates
Dear Zoho Team, I hope this message finds you well. We currently face a limitation when designing email templates in Zoho Desk. While we can create email templates and include a footer at the end, the agent signature is always appended by default at theCustom Profile Agents Unable to Update Mandatory Phone Number in tickets under Zoho Desk
Hi, While working in the Ticket module in Zoho Desk, agents with a custom profile are unable to update the Phone Number field (which is mandatory) under Account Information. The agents need to enter values such as "NA" or "Nil" in the field to close theResponse Violation - Zoho Desk
Hi Team, I just need an information regarding the zoho desk - Response Violation and how can we avoid the tickets from getting the tickets response violated.How to Implement Time-Based Filters in Zoho Workflows?
Hi everyone, I’m looking for a workaround to implement time-based filters in Zoho workflows. Specifically, I need a workflow to trigger only within certain hours (e.g., between 10:00 AM and 8:00 PM, Sunday to Friday). Currently, Zoho workflows executeHow to Replace an Assessment in a Job Opening on Zoho Recruit
Hi everyone, I’m currently using Zoho Recruit and would like to replace the assessment linked to a specific job opening. I want to remove the existing assessment and add a new one. What is the best way to do this without losing any important data or affectingPlug Samples #12: Verify Customer Mobile Numbers with OTP to Avoid Spam Entries
Hi Everyone! Verifying customer information is critical in business to filter out junk data and spammers. Whether it’s lead generation, appointment booking, or any other operation, ensuring quality data is essential for driving meaningful outcomes. AUpdating existing values in a list
Is it possible to update an existing value in a list? For example if I wanted to append text to an existing string value that I had previously added to a list is that possible? I'm able to extract the existing value (get() function) and append the additional text, but can't find a way to add the new value back to the list in the same index location. One work around I found was to delete the existing list entry and then add the new value, however this changes the index location to the last entry inImpuesto automatico en cotizaciones
Buen dia Mi pregunta es como se puede poner alguna operacion para que las cotizaciones me salgan automaticamente con impuestos ya que uno al cargarla al final tienen que añadir el porcentaje de impuesto SaludosHost not reachable
Good morning. I have four mail accounts and they have been working well for years. Now, suddenly, I am unable to send any e-mails from any of them. I allways have this pop-up: Thank you. Regards. Luis FernándezBIN Locations
Hi, I’m new to Zoho inventory and unless Im missing something, I cannot find BIN locations anywhere in ‘items’? please tell me it’s there somewhere?!? ThanksZoho Marketing Campaign
I want a details report of marketing API . which API i can use to get a full flexed detail of email campaign , sms , social media ,and all other campaigns ?Zoho Marketing Automation APIs
When I want to create New lead in marketing automation , I want to add First Name and Last Name as well along with Email but there is no option like this in API . Can you please give me the API which will fulfill my condition ?Adding Folders in Android App
Is it possible to create a new email folder within the Zoho Mail Android app? Or can this only be done from the desktop version of Zoho Mail? Cheers!Collaborative editing of spreadsheets by multiple users simultaneously - Is it really possible?
I work in a SharePoint 2010/SharePoint Server 2010 environment and we use MS Office 2007(Excel 2007) . I have been trying to create a MS Office document which will allow multiple users to work on a spreadsheet simultaneously. For that I have: 1) Created a excel workbook and published as a workspace as suggested by Andrea Kalli in her link: http://www.wonderhowto.com/how-to-collaborate-files-between-sharepoint-and-office-2007-182172/ 2) Set up and saved the Excel Workbook as "Shared" and made it availableAbility for customer to give feedback after receipt of an order
Is there any way we can receive feedback from customers regarding their order after delivery (other than just an email, obviuosly)? This is not the same as product reviews, as it may concern other points, but would ideally have an inbuilt reference toAll notes disappeared
I've been using the notebook app for over five years on my phone without being logged into an account. A few days ago I opened the app and all my notes had disappeared. Since then I tried restarting my phone, updating the app and logging into my account,Conversion of functions from Google Spreadsheets
Hello! I use this formula "=QUERY(ResumoOrdemVencimento!A3:O38;"SELECT A,B,C,D,E,F,G,H,I,J,K,L,M,N,O WHERE C != '' ORDER BY C,G")" in Google Sheets but when importing my spreadsheet into Zoho Sheets the formula was not converted. The QUERY function brings data from another spreadsheet, and then I sort and apply conditional formatting. The order of data will change automatically as I update the source spreadsheet. What Zoho Sheets function is equivalent to QUERY? I have some other spreadsheets toZoho Books Sandbox environment
Hello. Is there a free sandbox environment for the developers using Zoho Books API? I am working on the Zoho Books add-on and currently not ready to buy a premium service - maybe later when my add-on will start to bring money. Right now I just need aZoho Books | Product Updates | November 2024
Hello users, We are back with exciting new features and enhancements in Zoho Books. From multi-criteria workflows to writing off customer opening balances, discover the new updates designed to make your bookkeeping swift. Attach XRechnung to InvoicesSpell check sucks
Come on guys, it's 2024 and your spell check is completely retarded. You gotta fix it.Signature image logo not displaying in recipient mail clients
Whenever I send an email to another person the image that forms part of my logo is not displayed just a broken link to: https://mail.zoho.com/mail/ImageSignature?fileName=Email-log.jpg&accountId=47238000000007001&storeName=NN1:-3205531763309921492 I can see the logo because I've got a zoho account and I'm logged on but others without a zoho account can't see it. How do I fix this? Thanks -MartinSales Order, what are the statuses under Confirmed and Closed
Hi, I have to build a workflow in Deluge which should be triggered when Sales Order status is Confirmed or Closed. But these 2 states don't exist when you fetch a sales order. Which of the statuses are considered as Confirmed or Closed ? Here is a listNotifications for calendar meetings
So we have been happy users for a few months now. This is an important problem we face, since I have forgotten meetings already cause of lack of notifications. The problem: I have notifications (email, popup and notifications) set for my calendar by default.Reusuable Sections & Universal Brand Settings
Zoho Email Campaign setups take longer than other software I've used because it doesn't have reusable sections or universal brand settings (fonts and colors). These enhancements should be added to help us create our campaigns more easily.Blockchain technology
Blockchain technology is being used to revolutionize accounting and financial reporting. With blockchain, financial transactions are recorded on a decentralized ledger, making tracking transactions and verifying their accuracy easier. This technologyEste domínio já está associado a esta conta
Fui fazer meu cadastro na zoho e quando digitei meu domínio recebi essa mensagem que meu domínio estava associado a uma conta que eu nem faço idéia de quem seja. Como que faço pra resolver isso? Atenciosamente, Anderson Souza.not able to hit inventory api
when i hit the api with my account keys and the access is provide by the clientZoho email setup in office365
When i am trying to setup zoho mail setup using my domain in office365 and it is not working and it says that we couldn't log on to the incoming (IMAP) server and please check your email address and password and try again. I was able to login using myRemove County field from Customer Address input screen (or allow input to be deleted)
We are in the USA and have just noticed that there is now a County field in the Customer Address input screen (and maybe other areas of Zoho Books, but this is the one affecting us at the moment). County is not important to our business, and in fact we553 Relaying disallowed error
Hi, I am receiving a "553 Relaying disallowed" error when sending emails to my domain email address which I have configured in Zoho. However, I am able to receive emails from my domain email to my gmail account. The SPF and MX entries are all configuredLeads and Deals Issue
Hi! Is Zoho having trouble today? I've been experiencing issues today. When I move a deal to closed/won, it previously would require a closing date but today the screen just went blur and the closing date did not pop up. And then under leads, I was trying!! URGENT My sent mail goes to spam
I tested a few times and every time I send mail out it goes the recipients spam box. Why is it marking my mail as spam? please help me ! thanksEvent Time Zone in meeting invites are confusing users
When sending calendar invites to internal and external users, the first section "Event Time Zone" is confusing people and they are automatically declining events. Can this section please be removed??? It already shows the correct time zone next to theRequest For Quotation (RFQ) module
Hello, Do you have any plans to implement a RFQ module in to ZOHO Inventory? I would like to chose items that I require a price for, select a number of different suppliers to e-mail and have them submit there pricing online. I would then like to see aConstant Sync Errors 🙄
I'm constantly getting sync error notifications with no actual resolution. Also... I have folders and files with a (!) on the cloud icon, indicating it's not accessible. This has also led to the complete loss of certain folders. Like... the go missing!Display your zoho contact name when they call your mobile number
As per the title If a contact calls the office number, the contacts name shows on mobile as long as I have their contact details registered in my crm. Is there a way that if the contact calls my mobile, their name can be displayed? Currently just their number shows when they call.In Zoho Projects, is there a way to create a folders template under documents that can be used once a project is created?
We have a specific folder structure that we would like to use that is standard across every project. Instead of having to create this structure every time a project is created, is there a way to create a template for the folders that can be added?Custom view for Milestones
Hi, Just an idea for the future... would it be possible to create custom views for the Milestones view under Work Overview ? I usually need to look at this view filtered by project group but the filter doesn't remain when navigating away. A custom viewZoho Books API Limit Is RIDICULOUS!!!!!!!!!!!!!
The 2,500 API call limit in Zoho Books is about as useful as AOL dialup. Seriously Zoho, not only can I use up 2,500 API calls in no time with my own app but YOUR OWN STUPID IPAD APP blows through them super fast too, so if any one of my clients wantsjavax.mail.authenticationfailedexception 535 authentication failed
Hi, I am facing 535 authentication failed error when trying to send email from zoho desktop as well as in webmail. Can you suggest to fix this issue,. Regards, RekhaNext Page