Bidirectional sync between Zoho Bookings and Zoho CRM - Part 1
Hey, community members!
The default integration between Zoho CRM and Zoho Bookings is unidirectional, which means that any appointments booked, rescheduled, or deleted in Zoho Bookings will be reflected in Zoho CRM. However, any modifications made to events in Zoho CRM that originated from Zoho Bookings will not be reflected back in Zoho Bookings. Hence, as we're announcing in this community post, we've made the sync bidirectional.
This community post will cover the process of configuring appointment bookings from Zoho CRM in Zoho Bookings, as well as managing appointment statuses such as Canceled, No Show and Completed. We have addressed the rescheduling action in a separate post. To view it, please click on the following link: Reschedule Action
This community post will be beneficial for active Zoho CRM users who handle all their meetings within Zoho CRM. Additionally, you can use this community post as a reference to explore various automation possibilities tailored to your business requirements. For instance, with this post's guidance, when you update a booking's status field to "Completed" in Zoho CRM, it will automatically sync with Zoho Bookings and trigger an automated "Mark as completed" email to customers. This enhancement will improve your Zoho Bookings and Zoho CRM synchronization experience, making appointment management easier.
Prerequisites of bidirectional sync:
- Zoho Bookings Premium subscription
- Zoho CRM paid subscription
- Enable Zoho CRM integration within Zoho Bookings
The purpose of enabling the Zoho CRM integration within Zoho Bookings is to transfer booking details from Zoho Bookings to Zoho CRM. In this configuration, the mandatory field is the Booking ID, which is passed from Zoho Bookings to Zoho CRM through the integration. Whenever an appointment is booked, customer details will be sent to the designated CRM module, and a corresponding record will be created in the Meetings module within Zoho CRM, which will help in automating the workflow.
Here's the complete demo video that covers all the configurations discussed in the community post below:
Timestamps for your reference:
0:35 - Purpose of this community post
Here's the complete demo video that covers all the configurations discussed in the community post below:
Timestamps for your reference:
0:35 - Purpose of this community post
1:26 - Zoho CRM plugin installation
4:43 - Custom field creation
7:20 - Function creation
9:22 - Connection creation
10:24 - Configuring arguments
11:06 - Workflow creation
13:33 - Argument mapping
14:41 - Output verification
17:41 - Conclusion
How we're approaching this bidirectional sync
1. Booking an appointment from Zoho CRM
Install the Zoho Bookings for Zoho CRM plugin within your Zoho CRM application. This plugin enables the creation of a "New Appointment" button within the Zoho CRM Leads and Contacts module, which enables you to select the desired booking page you wish to open. You can choose from various workspace, service, or staff booking pages. After configuration, you can initiate the process of scheduling bookings directly from within your Zoho CRM account.
- Guide on Zoho Bookings and Zoho CRM plugin installation: Booking page selection for Zoho CRM plugin
2. Booking status: Completed or No Show
To update a booking's status (Completed or No Show), we've added a new picklist properties field named "Booking Status" in the Meetings module and configured it with two options: "completed" and "no show". Depending on the booking status chosen, the corresponding booking in Zoho Bookings will be updated.
- Details on how to add a custom field to the Meetings module : Customizing modules
- Here's a video that demonstrates how to add a field to a module in Zoho CRM: Adding fields
Reference:
3. Booking status: Canceled
Whenever a meeting is deleted from the Meetings module, the corresponding booking in the Zoho Bookings app will also be canceled automatically. The meeting can be deleted either from the Meetings module or directly from the calendar.
To enable bidirectional sync between Zoho CRM and Zoho Bookings
Complete these steps in Zoho CRM.
Step 1: Creating connections
You first need to establish a connection between Zoho CRM and Zoho Bookings. Zoho Bookings is listed as one of the default connections in Zoho CRM, making it simple to set up. Select the Zoho Bookings connection, define the connection name and scope, and you'll be all set. This connection will enable you to link both applications and facilitate the seamless transfer of data.
Read here for more details on how to create connection in Zoho CRM: Connections
Step 2: Creating functions
In this context, we'll be creating three functions: one for marking appointments as completed, another for canceling appointments, a third for marking appointments as no shows, and a fourth for rescheduling appointments. For each function, we must also configure arguments, which pass values or data into a function when making a call. Here, we'll pass the booking ID to the function as an argument to update the necessary booking status.
i. To create a function for marking appointments as completed:
1. Go to Setup > Developer Space > Functions.
2. In the Functions page, click + Create New Function.
3. Configure the function name, display name, and description.
4. Set the category as automation.
This opens the Deluge script page.
5. Next, configure the function's arguments:
A. Click on Edit Arguments on the Deluge script page.
B. Set the Parameter Name as bookingID. (Please note that the "bookingID" value is case sensitive and must match
the term used in the code).
C. Set the type as string.
Reference:
Please configure the below code in the Deluge script page.
By completing these steps, we've configured a function that will mark appointments as completed.
ii. To create a function for marking appointments as no shows
1. Go to Setup > Developer Space > Functions.
2. In the Functions page, click + Create New Function.
3. Configure the function name, display name, and description.
4. Set the category as automation.
This opens the Deluge script page.
5. Next, configure the function's arguments:
A. Click on Edit Arguments on the Deluge script page.
B. Set the Parameter Name as bookingID. (Please note that the "bookingID" value is case sensitive and must match
the term used in the code).
C. Set the type as string.
Reference:
Please configure the below code on the Deluge script page.
Code link: No show
By completing these steps, we've configured a function that marks appointments as no shows.
iii. To create a function for marking appointments as canceled
1. Go to Setup > Developer Space > Functions.
2. In the Functions page, click + Create New Function.
3. Configure the function name, display name, and description.
4. Set the category as automation.
This opens the Deluge script page.
5. Next, configure the function's arguments:
A. Click on Edit Arguments on the Deluge script page.
B. Set the Parameter Name as bookingID. (Please note that the "bookingID" value is case sensitive and must match
the term used in the code).
C. Set the type as string.
Reference
Please configure the below code on the Deluge script page.
By completing these steps, we've configured a function that marks appointments as canceled.
Code explanation
Below is an explanation of the code that covers all the configurations present in the three functions mentioned above (cancel, mark as completed, and mark as no show).
Line 1: Based on the Zoho Bookings account's data center, we're setting up the API endpoint URL configuration.
Lines 2 - 4: To update appointments, we utilize the Zoho Bookings API. Within the update appointment API, there are two mandatory fields that need to be included: BookingID and action (completed/cancel/noshow).
Lines 5 - 10: We use the invokeURL task for API calls. To learn more about the invokeURL task, please refer to the following document: InvokeURL task for API calls
Now, let's proceed and learn about the process of creating a workflow and linking the established functions to it. This will enable us to automate the entire appointment status updating process.
Step 3: Creating a workflow
Workflow rules are sets of actions (email notifications, tasks and field updates) that are executed when specified conditions are met. Here, we'll generate workflow rules for each action to activate the respective function, thereby automating the appointment status updating process.
i. Creating a workflow for "canceling" appointments in Zoho Bookings when a meeting is deleted in Zoho CRM
Part 1: Creating the rule
1. Go to Setup > Automation > Workflow Rules.
2. In the Workflow Rules page, click Create Rule.
3. Select "Meetings" under Module and configure rule name and description as required.
More details: Create Rule
Reference:
1. Select Record Action > Delete > Done to execute the rule when meetings are deleted.
2. Configure condition > All Meetings.
3. Instant Actions > Function.
4. Click the New Function button.
5. In the Configure custom function page, select the "cancel" function you created from among the functions users in your organization have created.
Part 3: Argument mapping
1. Press # to choose an argument value.
2. Select Meetings under Module and BookingId in the field.
3. Click the Save and Associate button.
Reference:
Below is the final flow of the cancel booking workflow:
At the end of Part 3, we will have created a workflow that will be executed automatically when meetings are deleted in Zoho CRM. Simultaneously, the bookings associated with the meeting will also be canceled in Zoho Booking.
ii. Creating workflow for updating an appointment's status as "no show" in Zoho Bookings when the meeting's booking status is marked as no show in Zoho CRM
Part 4: Creating the rule
1. Go to Setup > Automation > Workflow Rules.
2. In the Workflow Rules page, click Create Rule.
3. Select Meetings under Module and configure the rule name and description as required.
Reference:
Part 5: Specifying the rule trigger
If you encounter difficulties while navigating through the steps mentioned below, please refer to Part 2 above, where we have provided step-by-step screenshots for clarification.
1. Record Action > Edit.
2. Enable the Specific field(s) gets modified and configure it per the screenshot below.
a. This is to ensure that the workflow is executed only when the booking status under the meeting module is
updated to "No Show".
updated to "No Show".
3. Configure condition > All Meetings.
4. Instant Actions > Function > New Function.
5. In the Configure custom function page, select the "no show" function you created from among the functions
users in your organization have created.
users in your organization have created.
Part 6: Argument mapping:
If you encounter difficulties while navigating through the steps mentioned below, please refer to Part 3 above, where we have provided step-by-step screenshots for clarification.
1. Press # to choose an argument value.
2. Select Meetings under Module and configure the field as "BookingId".
3. Click Save and Associate button.
Reference:
Below is the final flow of the "No Show" booking status workflow:
At the end of part 6, we will have created a workflow that automatically executes when the booking status field within the Zoho CRM Meetings module is updated to "No Show." This action will result in the associated bookings for that meeting also being marked as "No Show" in Zoho Bookings.
iii. Creating workflow for updating appointment status as "Completed" in Zoho Bookings when the booking status field of the meeting is marked as completed in Zoho CRM.
Part 7: Creating the rule
1. Go to Setup > Automation > Workflow Rules.
2. In the Workflow Rules page, click Create Rule.
3. Select Meetings under Module and configure rule name and description as required.
Reference:
Part 8: Specifying the rule trigger
If you encounter difficulties while navigating through the steps mentioned below, please refer to Part 2 above, where we have provided step-by-step screenshots for clarification.
1. Record Action > Edit.
2. Enable the Specific field(s) gets modified setting and configure it per the screenshot below.
a. This serves to ensure that the workflow is executed only when the booking status under the Meetings module is
updated to "Completed".
3. Configure condition > All Meetings.
4. Instant Actions > Function > New Function.
5. In the Configure custom function page, select the "completed" function you created from among the functions users
in your organization have created.
Part 9: Argument mapping:
If you encounter difficulties while navigating through the steps mentioned below, please refer to Part 3 above, where we have provided step-by-step screenshots for clarification.
1. Press # to choose an argument value.
2. Select Meetings under Module and configure the field as "BookingId".
3. Click Save and Associate button.
Reference:
Below is the final flow of the "Completed" booking status workflow:
At the end of part 9, we will have created a workflow that is automatically executed when the booking status field within the Zoho CRM Meetings module is updated to "Completed." As a result, the associated bookings for that meeting will also be marked as "Completed" in Zoho Bookings.
Conclusion
We've reached the end of this community post. With the integration mentioned above in place, you'll be able to book, cancel, and update the status of appointments in Zoho Bookings directly from your Zoho CRM application. This will help you effectively manage your appointments in one place. As mentioned above, we've covered the rescheduling action in a separate post, which you can access by clicking on the following link: Reschedule Action
Furthermore, we've outlined a method for automating appointment statuses in detail. You can use this document as a reference to explore the various possibilities that suit your needs.
If you have any questions or need assistance with your configuration, please email us at hello@zohobookings.com or support@zohobookings.com.
Topic Participants
Kaushik S
Recent Topics
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 rightSchedule 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. ThanksZoho 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, ourRecurring Events Not Appearing in "My Events" and therefore not syncing with Google Apps
We use the Google Sync functionality for our events, and it appears to have been working fine except: I've created a set of recurring events that I noticed were missing from my Google Apps calendar. Upon further research, it appears this is occurringMultiplying Weight of product by Quantity
I am facing an issue with creating a report that consolidates the total sales volume in kilograms. I have already specified the weight for each product. I have also aggregated the total sales quantity. The key question is: how can I create a report thatConfirmation prompt before a custom button action is triggered
Have you ever created a custom button and just hoped that you/your users are prompted first to confirm the action? Well, Zoho knows this concept. For example, in blueprint, whenever we want to advance to the next state by clicking the transition, it isFrontal interview scheduling - room availability in office using Google Workspace?
Hi, We're using Zoho Recruit as our ATS and Google Workspace as our email, calendar and resources management. We want to use the interview feature to schedule an in-person (frontal) interview with the applicants. How can we sync the room resources availabilityAdd and Remove Agents from Departments and Groups in Zoho One
Hi Zoho Flow Team, We hope you're doing well. Currently, Zoho Flow provides an action to add an agent to a group in zoho one, but there is no action to remove an agent from a group or a department. Another action that we find missing is the option toIntroducing Hiring Pipeline for Vendor Portal
Keeping vendors informed about candidate progress is often challenging, leading to communication gaps and repeated follow-ups. To address this issue, we've released an update to the Vendor Portal feature that lets you choose to display candidates' hiringAddress Grabber function for Zoho
I converted from ACT to Zoho. With ACT, I used an add-on called AddressGrabber to scrape the contact information from leads that I buy and contact information contained on emails and websites and directly add it as a new lead or contact. Does anyone knowIntegrate zoom with zoho bookings please; or add optional times in zoho meetings
Just like events - these online meetings like zoom need to be integrated with zoho bookings, and there needs to be option for customer to book a time slot. It should not be dictated by CRM user.Add Owner to deluge-created module record note
Is it possible to include the "owner" aka "creator", of a Note when creating it via delulge? This sets "superadmin" as the Note creator. I need to override it. notemap = Map(); notemap.put("Parent_Id",program_contact_id); notemap.put("Note_Content",program_contact_data.get('Note'));Unique and Random IDs in Zoho Forms: Organize and Secure Your Data Efficiently
When it comes to form submissions, organizing and identifying entries effectively is crucial. Zoho Forms offers two versatile ID generation options for submissions: Unique ID and Random ID. Each serves distinct purposes, providing flexibility to meetSort By Date - Deluge
I have the following code, which normally works to sort calls by created time. Every once in a while, it doesn't work and something sneaks through in the wrong order and I can't figure out why. calls = zoho.crm.searchRecords("Calls","(Owner:equals:" +Iteration through a list - Coming up against a "Failure to update function" error
Hi there! I've been attempting to get a deluge script working and am running into an error that I have been unable to resolve. The error I am getting is Failed to update function Error at line :18. Improper Statement. Error might be due to missing ';'Can you modify "Last Activity Time" in deluge? If so what's the field name?
I need to perform some bulk modifications on records in the Leads module, but I need to avoid changing the "last activity time" or "date modified" because I am using those fields to filter and sort leads for follow-up action. I cannot find an answer anywhereHow do I define a weekend
I noticed the default for weekends does not seem to include Saturdays. How can i define weekends to include both Saturdays and Sundays? Thank you.【Zoho CRM】ポータル機能のアップデート
ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 今回は「Zoho CRM アップデート情報」の中からポータル機能のアップデートをご紹介します。 今回の機能アップデートにより、CRMのポータルへのログインがより簡単にできるようになりました。 【目次】 SAMLベースのシングルサインオンについて ポータルへのアクセスリンク送付について 今回のアップデートにより、アイデンティティプロバイダー（IdP）を利用している組織において、SAMLベースのSSO（シングルサインオン）を有効化できるようになりました！Getting error during inserting a record in form of zoho people using zoho api
import requests import json # Set your access token and Zoho People API base URL access_token = '1000.XXXXXXXXXXXXXXX.XXXXXXXXXXXXXXXXXXXXX' api_base_url = 'https://people.zoho.in/people/api/' # Set the form name and data to be inserted form_link_nameUI Arabic
can i change the member portal UI to arabic in zoho community?Resume template to include profile photo
Hi, We would love the Resume Template to be able to include their profile photo. How can this be done? MiriamMarking a form as 'done'?
Hi! I've got a form that staff fill in when moving stock from location to location. I see the entries they've sent across and I input them into my stock control system. Is there a way to mark a form as 'done'? So that I know which entries I've input,Zoho CRM - best way to search an account and assign to a deal
Hi Everyone I am looking for some advice. I want to find the best way to complete the below steps. We have a deal and once it reaches a certain stage we need to allocate a supplier / vendor to this deal along with the salesperson. I want to add (ideallyZoho Rating
When I close a ticket, the zoho system automatically sends an email to the customer for them to leave a rating. When they leave a rating, the ticket re-opens and I have to close it again. When I close it again, the zoho system sends the customer an emailZoho GC Flow is not showing in IM Channels
I have added my social IM channels in zoho desk. Created a GC Flow to automate conversations. But Guided conversations are not showing in any platforms I have chosen; WhatsApp Instagram Messenger Web (Business Messaging) In the flow I mentioned theseSharing Knowledge Base articles across multiple departments
It would be useful to share some Knowledge Base articles across multiple departments where they are applicable, rather than having to go into other departments to find the article you're looking for. For example. Our reception uses the 'Admin' desk whereas our IT guys use the 'Support' desk, however both divisions would find KB articles about our company intranet useful. Reception does not have access to the support desk, so cannot see articles created in the Support KB. Perhaps you could installContacts marked as Spam are shown as Contacts in tickets.
Hi Zoho, If a ticket is marked manually as Spam you get an option to set the contact as Spam as well. It would be great if there was another option to delete this Contact. This would be based on the understanding that it wouldn't be marked automaticallyIs possible to use ${webhookTrigger.payload.street==null?"No street":${webhookTrigger.payload.street}} for to detect inline a null parameter
Hi Team I need to know if it's possible to evaluate inline the following parameter, with the objetive to detect a null value ? I would like to use ${webhookTrigger.payload.street==null?"No street":${webhookTrigger.payload.street}} Regards, PabloReal Estate CRM
How can I tailor my CRM for real estate? I had seen an image where the CRM included property tabs.Issue with Bulk Edit Triggering Function Multiple Times in Zoho Report
In our Zoho report, we have observed an issue where executing a function during a bulk edit operation runs the function multiple times—once for each selected report entry. This behavior is causing errors due to overlapping or redundant executions. OurSet recurring tasks in Zoho Support?
Hello, We use the task function in Zoho Support to set reminders for "due dates" of important events, such as lease expirations, etc. Is it possible to set some of these as recurring yearly? As of now, we have to reset every task manually after one year. Is there a way to have it reset automatically? Additionally, is there a way to import a list of tasks and their dates into Zoho Calendar? I have not been able to do it from Zoho Support to Calendar. I tried exporting tasks from Zoho Support,Help - How Can I Enter a Hourly Rate (Global Cost) for our Team for Profitability Reporting?
Hi everyone, I'm hoping someone can help as I am at a loss and am quite shocked (if true) at the lack of functionality in Zoho Books. We run a company in which we do hourly jobs for clients and we bill based on the hours of work completed. Projects areSchedule a regular backup
In CRM I have a regular backup setup. I cannot find an option to backup Desk? I would like to take a backup before I test syncing products between CMR and Desk.Limit who can submit a support ticket to your site?
Does anyone have a use case for needing to limit who can submit tickets via your help portal? Some of our customers want to have end-users view our knowledge base articles and see tickets their IT groups have submitted but they do not want end-users toIs there a way to request a password?
We add customers info into the vaults and I wanted to see if we could do some sort of "file request" like how dropbox offers with files. It would be awesome if a customer could go to a link and input a "title, username, password, url" all securely and it then shows up in our team vault or something. Not sure if that is safe, but it's the best I can think of to be semi scalable and obviously better than sending emails. I am open to another idea, just thought this would be a great feature. Thanks,Allow us to disable the Reopen Ticket button after a ticket is closed
Disabling the Reopen Ticket will allow us to have more control over the ticket's flow. According to support, this is currently not possible. Please add this to let us, the customers, mold the ticketing system into something that we can use for our businessHow to Enforce Mandatory Fields (Category/Sub-category) Before Closing a Ticket?
Hi, I'm currently using Zoho Desk and encountering an issue where agents are able to close tickets without filling out mandatory fields, specifically Category and Sub-category. I’ve already set them both as a mandatory field, but it can still be bypassedAdmin Control for Default Email Templates in Zoho Desk
Hi Zoho Desk Team, We would like to request a feature enhancement related to default email templates. Currently, agents can select and set their own default email templates when replying to tickets. However, we believe this setting should be managed centrallyLock out of account after password update
This is a bit of a catch 22 situation. I updated my account password using password generator in ZohoValut. Now I am locked out of everything, as I cannot get into OneAuth for 2FA, as the password is randomly generated, without getting into ZohoValut,Guidance on Making Zoho Desk Connections Available for All Data Centers
Hi Team, I’m currently developing an application using Zoho Desk connections to manage OAuth for my third-party products. Could you please advise on the steps required to make it available across all data centers? Looking forward to your thoughts onNext Page