Automation#18: Automatically Fetch Values from Contacts to the Tickets Module

Hello Everyone,

Welcome to this week's edition, where you can seamlessly sync fields from the Contacts to the Tickets module. For efficient business operations, it's crucial to have details mapped across different modules.

Zylker Secure offers antivirus services with various pricing plans for its customers. Each plan purchased is stored in the Customer module. Every time a customer submitted a query, it was challenging to refer to the plan and process the requirements accordingly. Zylker Secure solved this by mapping pricing plan data from the customer record to the tickets module. This automatic sync streamlined their business operations. Let's see how to implement this automation in your Desk portal.

Prerequisites

1. Create a custom field in the Ticket and Contact layout.

    1.1 Go to Setup >> Customization >> Layouts and Fields.
    1.2 Choose the required Department and select the Ticket layout under it.
    1.3 Create a custom field in the Ticket layout. Click Save.

    1.4 In Layouts, choose Contacts from the drop-down list for the same department.

    1.5 Click on the Contact layout and create the same custom field type in the Contacts layout.

          Click Save.  

Note: The field type in the Contacts layout must match the field type in the Tickets layout. For example, if one layout has a single line field, the other must also have a single line field. Similarly, if one has a picklist field, the other must have a matching custom picklist field.

Create a Workflow Rule

1. Go to Setup, choose Workflows under Automation.

2. Under Workflows, click Rules >> Create Rule.

In the Basic Information section,

3. Select Tickets from the drop-down menu under Module.

4. Enter a Rule Name and Description for the rule.

5. If you want to activate the rule right away, select the Active checkbox. Else, create the rule and activate it later.

6. Click Next.

In the Execute on section, follow these steps:

7. Select the Create checkbox to execute this rule every time a new ticket is created.  

8. Click Next.

9. Leave the Criteria blank and click Next.

10. In the Actions section, click the + icon and select New next to Custom Functions.

11. Enter a Name and Description for the custom function.
12. In the script window, insert the Custom Function given below:

1. orgId = "6*********0"; // replace orgId
2. ticketAPIName = "cf_name"; // replace API name of the custom field in Tickets layout
3. contactAPIName = "cf_name"; // replace API name of the custom field in Contacts layout
4. getContact = zoho.desk.getRecordById(orgId,"contacts",ContactID);
5. customFields = getContact.getJSON("cf");
6. updateTicket = zoho.desk.update(orgId,"tickets",TicketID,{"cf":{ticketAPIName:customFields.getJSON(contactAPIName)}});
7. info updateTicket;

Note: In line 1, place your OrgId. To access your OrgId, go to Setup >> Developer Space >> API.

In line 2, replace the value with the API name of the custom field created in the Tickets layout.

In line 3, replace the value with the API name of the custom field created in the Contacts layout.

 

To access API name of the custom field, Go to Setup>>Customization>>Layouts and Fields >> Fields List. Select the module, and you can find the API name of the custom field created.

13. Click Edit Arguments and include the argument mapping as below: 

13.1. In the Name field type ContactID, and from the Value drop-down list select Contact Id under Contact Sections.

13.2. In the Name field type TicketID, and from the Value drop-down list select Ticket Id under Ticket Sections.

14. Click Save to save the custom function.
15. Click Save again to save the workflow.

Implementation

When a ticket is created, the custom field in the Tickets layout is updated automatically by fetching the value from the custom field in the Contacts layout.

 

See you next week with another custom function coming your way!

• Topic Participants

• Lydia | Zoho Desk

  

• niazb

• Shivani | Zoho Desk

  

• Abdelrahman

• Sticky Posts

• Zoho Desk Virtual Meetup: US Central, October 5 - 7, 2021

  After the interactive Virtual Meetups in the other regions, we are starting with the US Central and Midwest regions from October 5 to October 7, 2021. The dates for other regions will be announced soon.  At this event, we will explore the topics which

• Register for Zoho Desk Beta Community

  With the start of the year, we have decided to take a small step in making the life of our customers a little easier. We now have easy access to all our upcoming features and a faster way to request for beta access. We open betas for some of our features

• Ask the Experts 10: A 5-hour online Q&A on Zoho Desk Best Practices

  Welcome to Zoho Desk's Ask the Experts session! This is a monthly discussion on our  forums; wherein a panel of experts will take on questions  specific to topics related to Zoho Desk. The panel will be available for a 5-hour period and will answer any questions posted here.   Let's begin the year learning some best practices from our experts. In this month's ATE we are opening the floor to questions on how to use Zoho Desk the best way.  If you have a business use case but not sure if Workflow is

• Share your Zoho Desk story with us!

  Tell us how you use Zoho Desk for your business and inspire others with your story. Be it a simple workflow rule that helps you navigate complex processes or a macro that saves your team a lot of time; share it here and help the community learn and grow with shared knowledge. 

• Ask the Experts 7: A 5-hour online Q&A on Telephony and Call Module

  Welcome to Ask the Experts session! This is a monthly discussion in forums; each session, a panel of experts will take questions on specific topics related to Zoho Desk. The panel will be available for a 5-hour period and answer any questions posted here. In this month's Ask the Experts, we will take questions on everything related to Telephony and the Call Module in Zoho Desk. We will discuss the following aspects:  Integration with different Telephony vendors Routing calls to agents Converting

• Recent Topics

• Zoho vault uses only password to unlock not a TouchID

  TouchID works when normally openning app but when called from keyboard while browsing or trying to log to another app it shows only password option to unlock. This behaviour is only on iPad Mini witch latest 18.2OS

• Unable to add Guest Members

  We are having issues adding Guest Members to our Cliq account. We have sent out a number of request but it seems that only some people are able to access the platform. Others have received a message stating that they need to be granted access from an

• Webhook when estimate is refused is not firing

  Hello, I use a workflow through make that sends estimate with zoho books (I paid books and sign). -Those estimates when accepted are firing the webhook that I create in zoho sign (photo 1) -However when refused they are not firing the webhook that I created

• Invoice status on write-off is "Paid" - how do I change this to "Written off"

  HI guys, I want to write off a couple of outstanding invoices, but when I do this, the status of the invoices shows as "Paid". Clearly this is not the case and I need to be able to see that they are written off in the customer's history. Is there a way

• Create a custom button to modify custom fields in zoho Inventory

  I am needing a script for two buttons, 1. Button will add todays date to a custom field named cf_sent_to_sov 2. Button will mark a checkbox or unmark a checkbox field named cf_parts_ordered I have been trying to figure out deluge but have not got anywhere

• How to add a record for a different report

  I have one form and it has two reports I need to programmatically add records to both reports For example one report is draft and other is processed After the user performs some action on the draft report I want to create a new report in Processed and

• Webhook 'when estimate is refused' is not firing

  Hello, I use a workflow through make that sends estimate with zoho books (I paid books and sign). -Those estimates when accepted are firing the webhook that I create in zoho sign (photo 1) -However when refused they are not firing the webhook that I created

• Amazon Integration

  Hi, I am seller on Amazon , & I would like to sign up for Zoho books. However my question is can we automate/integrate invoicing, charges and returns in amazon with Zoho using API? Do you have a developer for this? I did take a look at zapier however it just has a create Invoice function nothing else.

• Link project tasks to tasks in CRM and/or other modules.

  Hello, I have created and configured a project in Zoho Projects with a set of tasks. I would now like to link these tasks (I imagine according to the ID of each one) to actions in the CRM: meetings, tasks, analytics). The aim is to link project tasks

• Count the NUMBER of Contacts for an Account automatically

  Hello. Is there any way Zoho can count the number of CONTACTS for a particular ACCOUNT and have a field in the ACCOUNT module update itself automatically? Currently we use Zoho to administer our language school and the Contacts represent students and Accounts represent Grupos (Classes). It would be very useful for us to have a feature like this enabled, and I can see other similar applications requiring something like this. The solution would be even better if the Contacts met a specified criteria,

• How to use Twilio to send appointment notification and reminder SMS in Zoho Bookings

  Hit no-shows out of the ballpark by combining Zoho Bookings and SMS providers. SMS notifications help you remind customers of their appointments and reduce no-shows by reaching out where they are. In this guide, we'll configure an SMS provider called

• geographic search filter in map view

  Hi, I have a recruiting and timesheet system built in Creator. The client wants to enhance the search for candidates based on their location and filter by job skills - currently they look on the Map View which uses the geo location or post code of the

• Announcement: Upcoming changes to the permission grant flow for OAuth apps

  This announcement is intended for app developers who use the Zoho API console. We're going to implement an important update to the way users grant permission for the OAuth apps created through the API console. What’s changing? Currently, users can grant

• Add Google Workspace Module to Zoho Flow

  Dear Zoho Flow Team, I hope this message finds you well. We’d like to request the addition of a dedicated Google Workspace module in Zoho Flow. Currently, there are no triggers or actions for Google Workspace, which limits our ability to integrate and

• How do i remove the Powered by Zoho logo from my careers page

  Can I remove this? ​

• Totals on Pivot Table

  Is there a way to change the way the subtotal calculates? In this example I have a formula to give me the average monthly attendance ....but I want the grand total of the month to be the sum of all the average attendances...any ideas? Thank you!@

• Team Inbox is not working AGAIN

  I like Team Inbox in general. It makes using a collaborative inbox easy - when it works. The problem is that it doesn't work at times - and it seems to not work, a lot. It's not catastrophic failure, it's little things. Unable to send messages Unable

• HOW TO USE ZOHO

  IDK

• Zoho account sign in with passkey

  Hello, I am trying to sign in using passkey, but the option doesn't show up in the web and is disabled in Oneauth on mobile, saying the admin has restricted the use. On the Admin page in Security MFA I can find no option for passkey. Help would be greatly

• Pivot table with Text values - "Matrix Report"

  User Story - As a user, I would like the ability to display textual data in a two-way table, matrix format (text datatypes, not numerical datatypes displayed as a dimension) One major feature missing from the Pivot tables in Zoho Analytics is the ability

• Canvas View in Zoho Recruit

  Is it possible or would it be possible to have the new 'Canvas View' in Zoho Recruit?

• Can Wisestamp email signature be use with Zoho mail?

  Does a Wisestamp email signature work with Zoho mail?

• WiseStamp

  WiseStamp is an excellent social media signature tool. It integrated seamlessly into Gmail and Thunderbird, plus a few more. Are there any plans to get this incredible app integrated into Zoho. check it out here: http://www.wisestamp.com/ thanks Tim

• Power BI connector (Zoho Creator) to Zoho Projects

  How can i connect power bi to Zoho Projects? domain is zoho.com How can i find workspace name, application link name and Report link name?

• Update your Google connection with Zoho TeamInbox

  Dear all, Wishing you a Happy New Year! Google has recently updated its security policy to enhance user protection, requiring all third-party apps and services to use OAuth authentication and password-less login methods. This update impacts users who

• Easy way to delete attachments

  I've reached my data limit and would like to run a view/report, and mass delete attachments. Is there an easy, fast way to do this? Moderation Update: Post Summary: There are two features the post discusses a) Easy way to remove Email attachments Will

• Sites Speed and Performance Grades

  I noticed that there are no recent inquiries or complaints about load speed or performance issues with Zoho Sites websites. However, I wanted to understand what Zoho has done to ensure that speed remains optimized, images are compressed and lazy loaded,

• Integrating Quotes with leads Information

  Our business requires giving a quote to a lead (not Account / Potential - as we define it differently). Currently, Zoho CRM's Quotes are integrated with Accounts / Potentials and not with Leads. Is there a way I could get the Lead information to the Quotes

• Unknown error occurred

  Hi, When we want to publish or edit a page in our website, we encounter with "Unknown error occurred" problem. I share a screenshot here. Our website is www.essoft.com. It happens every page. We want to solve this ASAP.

• Zoho one

  I am starting Zoho one as a beginner and there is Zoho crm and Zoho sales which i needed to work on but it appears in unassigned apps. What Should i do now?

• Dialing Microsoft Teams Phone Service via Zoho CRM

  I am using the VOIP option in Microsoft teams for my office phone system. I was hoping to have a way to dial numbers directly from Zoho CRM, but don't see anything in the Teams Integration or in the Telephony integration that will enable this. Does anyone

• Emailing lookup field but placing this as an ID or number rather than text

  Hi there, First time poster and have been a user of Zoho Creator for approx 6weeks so forgive my ignorance as I learn to code. We have a need to send an email to a specific email address with some of the fields triggered by the submission of a form. In

• Search mails in shared mailbox

  Hi everyone, is there a way to search mails in shared mailbox's? Search in streams or mail doesn't return anything from mails in shared mailboxes. Thanks! Rafal

• User Emails Blocked

  Community: I keep running into issues where our users stop receiving notifications from CRM because their email addresses get blocked in on the backend some how. I reach out to support, they confirm, they fix, and we carry on, but then it happens again.

• Why wont Zoho Support Grammarly!! --- PLEASE VOTE FOR THIS to show Zoho we need this

  The spell check and grammar in ZOHO are so buggy and a waste of time. Please support Grammarly! I'm sure I'm not the only one — there are other CRMs that support this. If you're not planning to add this feature, Please let others know before accepting

• Is it possible to hide Developer Space for all user in Zoho Projects

  Hello! I am Zoho admin in a company and we want to use Zoho Project to manage projects, but after a few days of testing we are not able to "hide" the Developer Space from all kind of users except the admin. To sum up, I want to hide this for all users.

• API (v2) Search Criteria using CONCAT

  With API I can search for a contact using First_Name and Last_Name. However, when I need to search the Contact Module using a full name — and because CRM does not provide an API for full name — I am not finding a way to do this in the traditional way

• Weekly Tips: Stay Focused with Email Snooze!

  New Year, New Resolutions Being back at work also means being back to the constant barrage of messages from work and clients. The constant flood of incoming emails can lead to the missing of important messages, especially when you can't respond right

• Schedule Zoho CRM reports only on Business Days

  Hello, Is it possible to schedule reports only on business days ? We currently get daily sales reports on weekend which has no value since the sales team doesn't work on weekends. Thanks

• Zoho Payroll's Year in Review 2024

  As we roll into 2025, we'd like to pay tribute to all the milestones we hit in 2024! From releasing out new features that streamlined your workflows to updates that made payroll management smoother, we’ve had a prolific year—all while keeping you, our

• Next Page