Workflow Custom Function for any existing Module for Box
The Box extension for Zoho CRM is one convenient way to access stored data and share files with leads and contacts (by default) from Zoho CRM. You can extend this functionality to custom modules too. Follow the steps below to see how it's done.
To associate the above custom function to a workflow rule:
- Click Settings > Setup > Automation > Workflow Rules.
- In the Workflow Rules page, click the Create Rule button.
- In the Create New Rule tab, specify workflow rule parameters that you require.
- Execute the workflow during Record Actions. Select Create or Edit and click Next.
- Select All Records in the following options. Next, select Custom Function to be triggered under an Instant Action.
- Associate the custom call function to be triggered. Click Save.
To create custom buttons:
- Click the Settings > Setup > Customization > Modules.
- Click $Module of your choice$ > Layout.
- Drag and drop the Fields from the New Fields tab.
- Click Save.
//Note: the custom function should have "record_id" parameter
// getting record info from Leads or Quotes using the record_id
quote_info = zoho.crm.getRecordById("Quotes", quote_id.toLong());
// Getting Box folder ID from the record info
box_folder_id = quote_info.get("Box Folder ID");
if ((box_folder_id == null) || (box_folder_id == ""))
{
rootFolderId = zoho.crm.getOrgVariable("box.box_rootfolder_id");
if (rootFolderId == "")
{
// Returning since the root folder ID is empty
return;
}
tokenObj = map();
tokenObj.put("folder_name", "Quotes");
tokenObj.put("parent", rootFolderId);
// Using the token object and Box connector to call the invoke connector from CRM API createFlrResp = zoho.crm.invokeConnector ("box.box.createboxfolder", tokenObj, true);
if (createFlrResp == null){
return;
}
// Get the status code from the createFlrResp
status_code = createFlrResp.get("status_code");
quote_folder_id = "";
resp_obj = createFlrResp.get("response");
// Checking for same folder name
if (status_code == "409")
{
context_info = resp_obj.getJSON("context_info");
conflict_ids = context_info.getJSON("conflicts").toJSONList();
for each entry in conflict_ids
{
quote_folder_id = entry.getJSON("id");
}
}
// Returns the folder ID if these conditions satisfy
else if ((status_code == "201") || (status_code == "200"))
{
quote_folder_id = resp_obj.getJSON("id");
}
if (quote_folder_id == "")
{
return;
}
//Get the record name if folder ID exists
first_name = quote_info.get("Subject");
tokenObj1 = map();
tokenObj1.put("folder_name", first_name);
tokenObj1.put("parent", quote_folder_id);
// Update the folder id and record name using API
createFlrResp1 = zoho.crm.invokeConnector ("box.box.createboxfolder", tokenObj1, true);
status_code1 = createFlrResp1.get("status_code");
resp_obj1 = createFlrResp1.get("response");
rec_folder_id = "";
if (status_code1 == "409")
{
context_info1 = resp_obj1.getJSON("context_info");
conflict_ids1 = context_info1.getJSON("conflicts").toJSONList();
for each entry1 in conflict_ids1
{
rec_folder_id = entry1.getJSON("id");
}
}
else if ((status_code1 == "201") || (status_code1 == "200"))
{
rec_folder_id = resp_obj1.getJSON("id");
}
if (rec_folder_id != "")
{
updateMap = map();
updateMap.put("Box Folder ID", rec_folder_id);
// Update the Box folder ID using the CRM API
update_resp = zoho.crm.updateRecord ("Quotes", quote_id + "", updateMap);
}
return;
}
|
Related List For Quotes Module :
// Note: the custom function should have "record_id" parameter
// Getting record info from Leads or Quotes using the record_id
quote_info = zoho.crm.getRecordById("Quotes", quote_id.toLong());
box_folder_id = quote_info.get("Box Folder ID");
// satisfies the below conditions if folder id is empty
if ((box_folder_id == null) || (box_folder_id == ""))
{
rootFolderId = zoho.crm.getOrgVariable("box.box_rootfolder_id");
if ((rootFolderId == "") || (rootFolderId == "none"))
{
xmlList = ("Folder for Zoho CRM is not created yet in Box. a Root Folder. the root folder if folder id exists
tokenObj = map();
tokenObj.put("folder_name", "Quotes");
tokenObj.put("parent", rootFolderId);
createFlrResp = zoho.crm.invokeConnector ("box.box.createboxfolder", tokenObj, true);
if (createFlrResp == null)
{
xmlList = "Please authorize Box to view Box Files. You can authorize Box in Box Settings tab.";
return xmlList;
}
status_code = createFlrResp.get("status_code");
quote_folder_id = "";
resp_obj = createFlrResp.get("response");
//Satisfies the below condition when the folder name comes same
if (status_code == "409")
{
context_info = resp_obj.getJSON("context_info");
conflict_ids = context_info.getJSON("conflicts").toJSONList();
for each entry in conflict_ids
{
quote_folder_id = entry.getJSON("id");
}
}
else if ((status_code == "201") || (status_code == "200"))
{
quote_folder_id = resp_obj.getJSON("id");
}
if (quote_folder_id == "")
{
xmlList = ("No files exists for this record.");
return xmlList;
}
//get the record name and folder id from quote_info
first_name = quote_info.get("Subject");
tokenObj1 = map();
tokenObj1.put("folder_name", first_name);
tokenObj1.put("parent", quote_folder_id);
createFlrResp1 = zoho.crm.invokeConnector ("box.box.createboxfolder", tokenObj1, true);
status_code1 = createFlrResp1.get("status_code");
resp_obj1 = createFlrResp1.get("response");
rec_folder_id = "";
if (status_code1 == "409")
{
context_info1 = resp_obj1.getJSON("context_info");
conflict_ids1 = context_info1.getJSON("conflicts").toJSONList();
for each entry1 in conflict_ids1
{
rec_folder_id = entry1.getJSON("id");
}
}
else if ((status_code1 == "201") || (status_code1 == "200"))
{
rec_folder_id = resp_obj1.getJSON("id");
}
//Update the folder id using the crm API
if (rec_folder_id != "")
{
updateMap = map();
updateMap.put("Box Folder ID", rec_folder_id);
update_resp = zoho.crm.updateRecord ("Quotes", quote_id + "", updateMap);
}
xmlList = ("No files exists for this record.");
return xmlList;
}
else
{
tokenMap = map();
tokenMap.put("FOLDER_ID", box_folder_id);
tokenMap.put("limit", 100);
tokenMap.put("offset", 0);
//get the folder items created under the root folder using the token object
folder_items_map = zoho.crm.invokeConnector (("box.box.getfolderitems"), tokenMap, true);
folder_items_status = folder_items_map.get("status_code");
if (folder_items_status == "200")
{
listfolder_resp = folder_items_map.get("response");
entries = listfolder_resp.getJSON("entries");
entries_list = entries.toJSONList();
if ((entries_list.toString() == null) || (entries_list.size() == 0) )
{
xmlList = ("No files exists for this record.");
return xmlList;
}
//Get the json object items from the entries list
else
{
i = 0;
recordsXmlStr = "";
for each entry in entries_list
{
type = entry.getJSON("type");
name = entry.getJSON("name");
id = entry.getJSON("id");
description = "";
if (toString(entry).indexOf("description") > 0)
{
description = entry.getJSON("description");
}
if ((description == null) || (description == ""))
{
description = "--";
}
size = "";
if (toString(entry).indexOf(("size")) > 0)
{
size = entry.getJSON(("size"));
}
if ( ((size == null) || (size == "null")) || (size == ""))
{
size = "0";
}
content_modified_at = "";
if (toString(entry).indexOf("content_modified_at") > 0)
{
content_modified_at = entry.getJSON ("content_modified_at");
}
if (content_modified_at == null)
{
content_modified_at = "";
}
modified_by = "";
if (toString(entry).indexOf("modified_by") > 0)
{
modified_by = entry.getJSON("modified_by").getJSON("name");
}
if (((modified_by == null) || (modified_by == "")) || (modified_by == "null") )
{
modified_by = "--";
}
shared_link = "";
if (toString(entry).indexOf("shared_link") > 0)
{
shared_link = entry.getJSON("shared_link");
}
shared_link_url = "--";
if (((shared_link == null) || (shared_link == "null")) || (shared_link == "") )
{
shared_link_url = "--";
}
else
{
shared_link_url = shared_link.getJSON("url");
}
link = "https://app.box.com/files/0/f/" + box_folder_id + "/1/f_" + id;
if (type == "folder")
{
link = "https://app.box.com/files/0/f/" + id + "/";
type = "Folder";
}
else
{
type = "File";
}
if (content_modified_at != "")
{
content_modified_at = content_modified_at.replaceAll ("T"," ");
}
size_str = "-";
size_str = ((((size).toDecimal() / 1024))) + "";
if (size_str.indexOf(".") > 0)
{
pos = (size_str.indexOf(".") + 3);
if (pos > size_str.length())
{
pos = size_str.length();
}
size_str = size_str.subString(0,pos);
}
size_str = (size_str) + " KB";
//Construct the xml using the above responses
recordsXmlStr = recordsXmlStr + "";
recordsXmlStr = recordsXmlStr + "";
recordsXmlStr = recordsXmlStr + "" + type + "";
recordsXmlStr = recordsXmlStr + "" + description + "";
recordsXmlStr = (recordsXmlStr + "" + size_str) + "";
recordsXmlStr = recordsXmlStr + "" + content_modified_at + "";
recordsXmlStr = recordsXmlStr + "";
if (shared_link_url == "--")
{
recordsXmlStr = recordsXmlStr + "--";
}
else
{
recordsXmlStr = recordsXmlStr + "Shared Link";
}
recordsXmlStr = recordsXmlStr + "";
}
recordsXmlStr = recordsXmlStr + "";
return recordsXmlStr;
}
}
else if ((folder_items_status == "401") || (folder_items_status == "404") )
{
xmlList = ("You need to be invited to the Box root folder. already linked to this record.");
return xmlList;
}
else
{
xmlList = ("Unable to get files related to this record from Box.");
return xmlList;
}
}
|
Topic Participants
Vijay Surya
administrator
Vinoth Kumar
Sticky Posts
Introducing Kanban Board Extension for Zoho CRM
Zoho CRM has been helping you with your business in many ways. The foundation of it all is that it is keeping all your data well organized and maintained. It makes work easier for you but what if that was not all. Yes! That is not all; we now provide the Kanban Board extension that provides a visual management for your CRM data. It is a great way to view all the records segregated the way you want to see them. Be it based on deal status, lead pipeline stage, or campaign type or any other pick listHere's what you can do with your DocuSign Extension
Contracts, agreements, and other documents have always been an integral, concluding part of any sales process. With the free DocuSign Extension for Zoho CRM, we've made certain that your signing process is entirely digital, and there is no need for copies,Contact Info Extractor Chrome plugin
Just trying out the Contact Info Extractor plugin and had a quick observation. Since a target website for this plugin would be LinkedIn, I'm very surprised that the plugin cannot determine that if the selected text in question includes... Joe Smith Vice President at ABC Corporation ... the plugin can recognize the name and title but not the company. I'd assume that the term "at" would give it the needed clue but on several contacts I tried to add, it's just not catching it. Would love to see theEasily send documents from Egnyte to your leads in Zoho CRM
Understanding your customers and educating them about your product are two sides of the same sales coin. During a sales process, to educate your potentials about your product, you may have to send them user guides, help documents, comparison sheets, andEmpower Your Sales Team with Email Marketing Insights Using the Mailchimp Extension
Email marketing is one of the most powerful tools available for engaging leads. It’s low cost and high ROI makes it a top choice for marketers who want to establish contact with leads. But these leads can only be turned into actionable deals when pursued
Recent Topics
Organization-Tiered Support in Zoho Corp Help Center
Dear Zoho Team, Greetings! As the focal point for all Zoho-related matters in our organization, we would like to request the implementation of an organization-tiered support structure in the Zoho Corp Help Center (Zoho's internal Zoho Desk). This featureHTTP Error 500 when creating E-Mail Draft with API
Hi, I tried to create an email draft for a ticket using the Zoho Desk API (v1); however, I continuously receive HTTP Error 500: An internal server error occurred while performing this operation. I've tried both curl and Python implementations, but neitherRecording overpayment?
So a customer just overpaid me and how do I record this? I can't enter an amount that is higher than the invoice amount. Eg. Invoice is $195 and he sent $200. He's a reccuring customer so is there a way to record so that he has a $5 advance for future invoice?Function #10: Update item prices automatically based on the last transaction created
In businesses, item prices are not always fixed and can fluctuate due to various factors. If you find yourself manually adjusting the item rates every time they change, we have the ideal time-saving solution for you. In today's post, we bring you customCalculate BMI
Hello, Could you please help me with the following calculation: Height registration is in feet & inches. Weight registration is in pounds & LBS. I want to calculate the BMI for example: //Calculate pounds dec = row.Today_s_Weight_st_lbs.toDecimal() * 100; num = row.Today_s_Weight_st_lbs.toLong() * 14; pounds = (dec + num); //Calculate inches dec1 = X.Height_ft_ins.toDecimal() * 100; num1 = X.Height_ft_ins.toLong() * 12; inches = (num1 + dec1); //BMI Calculation row.BMI = (pounds * 0.45) / ((inchesZoho Recruit - Blueprint and ZIA
If I activate the Blueprint for Jobs in Zoho Recruit, Zia disappears for matching canddiates, why is that?E-mails duplicados
Ao enviar e-mails, uma das contas de nossos usuários, mostra dois e-mails enviados iguais. Como faço para exibir somente um e-mail enviado? Obrigado,Zoho 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 myZoho Creator - Install app from Gallery takes too long
I'm trying to install the 'Volunteer Portal' from the app Gallery of Zoho Creator. It has been busy installing the app for over 2 hours now. It might be okay, but how long is something like that supposed to take? I never installed anything from that GalleryWhy Trident?
Maybe a strange question, but I was wondering why Trident is being developed. It looks fine and is working better and better, but I can't see what you want to achieve what isn't already in Zoho Mail? Zoho mail is already an (webbased I suppose) app thatEmail não baixa nem anexa arquivos
Boa tarde. Não consigo baixar, visualizar nem anexar arquivos no e-mail Zoho. Já baixei a permissão para o Chrome, mas não adiantou. Tentamos no Windows 7 e 10, e mesmo assim não baixa nada. Somente pelo app do celular consigo baixar. O que posso fazer?Email zoho não baixa nem anexa arquivos
Não consigo baixar, visualizar nem anexar arquivos no e-mail Zoho. Já baixei a permissão para o Chrome, mas não adiantou. Não baixa nada. Somente pelo app do celular consigo baixar. :(Problem adding emails to my account / Email Address already exists or associated in another Organisation
Hello, I am trying to create 3 emails that I previously deleted, but it gives me the message that you see on the screen below, I tried to write to support but I still have no response, what else can I do?"Processing"
Hi, All emails outgoing are showing "processing", any issues? ThanksFor each loop with available time slots
I am very new to Deluge, and this question was unable to be answered by Zoho Creator tech support upon request. Task at hand: I have a Form with 4 fields: - Date Start - Date End - Dropdown: Time Start: contains time slots (12:00PM, 12:15PM, etc) - Dropdown:Auto forward after moving email from spam to inbox
Auto forward is generally working fine, however it does not forward mails landed in the spam folder. I can move important mails from spam back to inbox, is it possible to automatically forward them once they are in inbox? Obviously I can manually forwardProjects Task List Bars not Showing
Im in my Projects template and the grey bar for the Task Lists is not showing and the tasks cannot join to it. I have it open in a job and it works. Anyone know why its not showing in the template?Restriction in assigning signer fields for the "Approver" role in APIs and internal integrations
Hi, Zoho Sign's intended design is offering two actions to the recipient - Needs to sign (if you wish your recipient to add information to the document; signature, for instance) or Approver (someone who has to approve the content of the document and mustSearching Notes & Attachments
Is it possible to have the search in CRM search the Notes and Attachments for key wordsno me llegan los correos a Zoho mail
No puedo recibir correos pero sí enviarlos, ya hice la modificación de MX y la verificación de teléfonos, qué es lo que ocurre? gracias553 Relaying disallowed SMTP Error: data not accepted
I am configuring my website to use my zoho mail for my contact form. I am using phpmailer but this exits with the following error: SMTP ERROR: DATA END command failed: 553 Relaying disallowed SMTP Error: data not accepted. Mailer Error: SMTP Error: dataRebrand your CRM with the all-new custom domain mapping setup
UPDATES TO THIS FEATURE! 19th Jan, 2024 — Custom domain mapping has been made available for portal users in Zoho One and CRM Plus. 23rd June, 2023 — Custom domain mapping has been made available for all users, in all DCs. Hello everyone! We are elated'Find duplicates using :'
I just discovered (and thought I would share) that you can import candidates to Zoho Recruit and define the field you want to use to find duplicates. I have used the email address all this time. But I think a better field to find duplicates is a contact'sChart View group X-axis values above a value
I have a data set with X values ranging from 0 up to 300-400, the Y values are an AVG of the values for the given X. I am interested in the values at the low end of the scale, say 0-10 and want the X values 10 and greater to be grouped into a single categoryTerritory management and roles hierarchy
Hi everyone, we are facing a problem with territory management. Our roles hierarchy is quite simple: - Area sales managers - Sales executives (reporting to Area sales managers) - Backoffice "Sales executives" can see only accounts/contacts/etc based onDataPrep Bigquery Connection failed
Hello everybody, I want to create a connnection beetwen Bigquery and Dataprep but when I try to connect my project I got this error Loading tables has failed. Table list fetched from the data source expired.Can Send Emails But I am not Receiving emails in Zoho Account
Hello, I have configured a Zoho email account for the domain pentexqatar.com and I can send emails but am not receiving any emails in Zoho account. can I please let me know what could be the issues? Thank YouDisable Multiple Submissions by same Employee
Dear All, I am creating a form to be filled by employees. Is it possible to restrict submission of the form if that employee has already submitted it once?Whatsapp Notification For Cliq
We have integrated WhatsApp Business into Zoho CRM, and messages are coming through to the CRM. However, I want a notification message to be sent to the data owner in Cliq when a new message arrives. This doesn't seem possible through rules. Is thereZoho 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 aPrefill Zoho Bookings form fields when using 'Email Booking URL' button in Zoho CRM
I'm utilizing the 'Email Booking URL' button in Zoho CRM, linked to the 'Contacts' module. After the contact sets the meeting details and receives the email, I want the Zoho Bookings form to automatically pre-fill with their information (name, email,Call Counter
For context, our Leads Page is configured with three separate phone number fields. This allows us to store multiple contact numbers for each lead. We've also integrated a click-to-dial feature in our CRM system, which enables us to make calls directlyPower of Automation :: Incorporate your desired tasklist into a new project automatically
Hello Everyone, A custom function is a software code that can be used to automate a process and this allows you to automate a notification, call a webhook, or perform logic immediately after a workflow rule is triggered. This feature helps to automateHow to delete Inactive users?
We want to delete inactive users from our system, but went you deactivate still the names are shown at the inactive section. How to get really rid off these names? Thanks for your response! Fabian van den BarselaarEvents disappearing in Calendar
To reproduce the bug: 1.- Add a new event in Calendar 2.- Type any name for the Event 3.- Click "Create" 4.- The event appears 5.- Click on the event to open it 6.- Optional: Edit the event 7.- Click OK 8.- After two seconds, the event disappears Now, click on another day and then come back to the inserted event's day. The event appears.Variable time for consultation.
We would like to be able to not set a predefine time for the consultation. We wont be using this for the customer it's going to be use internaly to keep track of workers on the road that have appoiment and installation. Something in the line of a FSMIntegration Zoho Books in CRM
Hi, I integrated the CRM with Books. This allows me to display accounting documents assigned to a customer directly in the CRM. This is a very convenient option. Unfortunately, I can't find a solution to properly set permissions for my sales department.Scheduling Actions by Date and Reusing Webhooks in Journey Builder
Hello, I’m trying to use the Journey Builder feature, but I noticed that it only allows scheduling actions forward in time, not based on a specific date. It would be very helpful if we could schedule actions ahead of time based on predefined date fields.New Customization options in the module builder: Quick Create and Detail view
Hello everyone, We have introduced two new components to the module builder: Quick create and Detail view. The Quick Create Component It is a mini form used to create a record and associate it to the parent record from a lookup field. For example, if you have a Deals lookup in the Contacts module, then you can associate existing deals or create a deal and associate it with the contact. You can customize this Quick Create form by adding standard as well as custom fields. There is no limit to the numberProject Change Orders and Additions
We are in the process of migrating from QuickBooks Online to Zoho Books. We have Zoho One and like the ability to sync all of our data across everything. And I like that projects work in a way that's less dumb than QuickBooks. I'm trying to figure outNext Page