Dynamically calculate the difference between two dates with a DATEDIF function in Zoho Office Integrator

• Topic Participants

• Varadarajan AR

  

• Sticky Posts

• Latest updates to Zia in Office Integrator

  Hello Zoho Office Integrator users! We’re pleased to share exciting updates to the proofing capabilities of Zia, our AI-driven writing assistant, in Office Integrator. With these updates, you can now get spell and grammar check in Brazilian Portuguese,

• Role management in Zoho Office Integrator

  Hey Office Integrator users! We're pleased to announce that users now have the ability to assign role-based permissions, which empowers them to execute specific operations within Office Integrator and manage tasks like adding or removing user accounts

• Introducing post-paid billing in Zoho Office Integrator

  Hey users, We're pleased to announce that you can now maintain uninterrupted business operations even after API calls associated with your Office Integrator subscription plan have expired. With our new flexible post-paid billing option, you have the flexibility

• Recent Topics

• Zoho CRM CPQ NOT in criteria patern

  Hi, It would be great to have the logic-block of "NOT" in the criteria patern. Currently, only "AND" and "OR" are valid criteria when using the product configurator. Often, a "NOT" logic-block would greatly increase the usability of the CPQ. Example:

• Filter by Portal User Reports no longer work

  I've had multiple reports that filter the data that shows based on the portal user - thisapp.portal.loginUserName(). They have worked fine for years but a few months ago they stopped working. Currently, no records appear in the report. Also, this is the

• Quickly migrate attachments to Zoho CRM without having to restart the process multiple times

  Hello everyone, Customers often want to transfer all their data and attachments to Zoho CRM when they're switching CRMs (or moving from one Zoho CRM org to another). Admins use the built-in import tool to perform these migrations. There's a common source

• Numeric Field Issue

  Hi We are trying to import deals but hitting a roadblock every time. If I create a single line field, the data imports fine for this field (it's a currency field in csv). I have found I can't sum this field though when trying to do a revenue report. When

• Transfering Creator data to Books

  Hello, I am working on a new app that will have suppliers, products, customers, order, etc. When I will be finished, I will want the end result (an order of goods) to be transfered to Books for invoicing and accounting. I will also use the supplier order

• Your Incoming has been blocked and the emails will not be fetched in your Zoho account and POP Accounts

  Can some on help me regarding our account . thank you so much

• Custom code ass to header and footer code doesn't appear

  I am trying to insert custom code into both the header and footer of my Zoho site. I edit the site "general settings" as demonstrated in the various articles, click save, but the code does not appear on my site. Is there something special I need to do

• Geo-Powered Retail Intelligence with Zoho Analytics

  In today’s highly competitive retail landscape, data-driven decisions are no longer optional — they’re essential. While businesses collect vast volumes of data across regions, stores, and customer segments, the real value lies in how effectively this

• In the Pivot table in the value section i want to the actual value instead of sum or count

  I am creating Early/late Check and check out in pivot report based on Zoho analytics I need the data to include: Employee Name Late Entry, Early Entry, Early Exit, Late Exit, First In, Last Out, and Total Hours.

• Outgoing blocked again.

  Hi Dear, My outgoing mails are blocked again. I am just using it as normal business emails going in and out. Could you please help fix the problem? I am happy to support where I can do to make it work properly. Thank you very much. Aurora

• Tip of the Week #54 – Automatically assign emails to your team members.

  Managing incoming emails can feel exhausting at times. But what if you could ensure that every email reaches the right team member — without lifting a finger? That’s where automatic email assignment comes in! With Zoho TeamInbox, you can easily set up

• Keep your forms spam-free with CAPTCHA

  Is your online form getting loads of unwanted responses? Tired of spam ruining your valuable form data? CAPTCHA is the solution you are looking for. CAPTCHA (Completely Automated Public Turing test to tell Computers and Humans Apart) is a simple yet effective

• how to get the first word in string using deluge?

  let say I have string "David Beckham". how to get just "David" using deluge? I need to get the first word in string using deluge?

• Access a field from incoming webhook Zoho Flow

  I would like to further process an incoming webhook in zoho flow. How can I access a field in the script / custom function. I tried this in many variations but not working: exfield=${webhookTrigger.payload.AnalyseErgebnis}; I would be very grateful if

• Possible Bug: ZML Editor code in Panels not rendered successfully.

  I'm using Panels in my Zoho page because they allow clickable interactions like opening URLs or navigating to other pages. However, I'm facing two major issues: Persistent White Background: Despite multiple attempts, I’m unable to remove the default white

• How to Find and Merge Duplicate records in Zoho CRM

  Hello Everyone,   Today, let's see how to find Duplicate records in your Zoho CRM account and Merge them.   Eliminating duplicate records in CRM seems to be a frequent issue for many businesses. Duplicate records can affect your productivity, increase manual work, and more importantly show incorrect data when it comes to reporting. Hence, it is crucial for businesses to have the ability to avoid creating duplicate records and the ability to merge duplicate records in CRM. As a first step, we need

• Is Zoho Tables part of Zoho One

  Cant seem to add the app as part of my Zoho One Subscription?

• Sending a Link to a Record in an Email template

  I recently introduced CRM Blueprints for the Deals module in my organization, and since our sales process involves several people from different departments, I created a few email templates to be used in the Email Notifications of some of the transitions, to let a user or group know that they need to take action or just be informed of a status change for that deal. Even though everything was working as expected, shortly after setting this up, some users came up to me asking if the notification email

• Payroll in Saudi Arabia

  Zoho is a popular software platform that offers a wide range of business solutions, from customer relationship management to finance and accounting tools. However, one major drawback for businesses operating in Saudi Arabia is the lack of a payroll feature

• How I can export emails from zoho crm ?

  Hello, I am looking for the workaround for exporting the sent e-mails. We use the Zoho crm free version (with upgrated storage) - and the e-mails are written/sent within/out of the crm feature. For our cases we only use 1) companies and 2) contacts -

• Pre-loading related contact lookups to a subform

  Hello, I'm trying to create a module to track group meetings and field data for each group member. Subforms appear to be a good fit for this but I don't want to add each contact every time manually. Can anyone suggest a good solution for this scenario?

• Fetching Comments From A Zoho Ticket Comment using Zoho Desk Api

  Hi I've been integrating Zoho Desk API into our product however, I'm unable to fetch any ticket comments when using your API. I get the following response => { "data": [] } The URL I'm hitting is https://desk.zoho.com/api/v1/tickets/ticketIdHERE/comments.

• What are the formulas behind the system default dashboards?

  We want to know the exact formulas especially for the "time based dashboards". For example the "First Time Closure" logic for the "First Call Resolution" dashboard is not very clear. How does the system calculate that a ticket has been closed at the first time? Please elaborate with further details.

• Grouping payments to match deposits

  Is there a way to group multiple invoice payments together so they match credit card batches and grouped deposits in the bank account? Basically, we are creating invoices for each of our transactions, and applying a payment to each of the invoices. Our payments are either credit cards or checks. We want to be able to group payments together so when our bank account reflects a credit card batch made up of many transactions, or the deposit we took to the bank that has multiple checks from different

• How to create groups in Zoho People?

  I want to create groups and add users.

• Deleted Blog Still Visible on Zoho Site

  I deleted the blog on the Zoho site and permanently removed it from the trash, but the article is still visible. Please make sure it does not appear. The URL is below https://seeds.tech-manage.co.jp/blogs/post/WL-04550

• Data Import validations

  Hi, I currently have a CSV file download from a 3rd party SFTP server prior to performing the data transform. When we don't have any transactional data, a file is still uploaded by the 3rd party to the server, but it is blank. This causes the transform

• Is Setting Up Sub Domain for Email Sends Good Idea?

  Hi there, our team just bought a dedicated IP for our email sends. We send more than 100k emails/month. Because we face deliverability issues and also because of the mass sends, we decided to get a dedicated IP. My question is, should we set up subdomains

• Abandoned Cart Recovery doesnt work on Woocommerce

  Hi, Does someone have implemented ACR with Woo successfully? My connection seems to be established but no user entered the workflow since I'm running the integration. I also faced problems in reinstalling the plugin on my wordpress. I simply cant uninstall.

• Vault extension for Chrome rarely works anymore in Brave browser

  Hello, Until about a year ago the Vault extension for Chrome worked very reliably in the Brave browser. Since then, though, the extension fails to open, more often than not. Is there a known fix for this? I love Vault - it is, by far, the best password

• Discussion : How are you sharing your Zoho Analytics Dashboards/Reports?

  I have all of my companies data in Zoho Analytics and now want to use it to prepare regular reporting for my SLT. They currently produce a Word document with screen shots of various reports… Analytics own dashboard engine is not great and doesn't fit

• Collaborate without compromise, with Ticket Sharing.

  We often hear that the ability to move tickets is a big benefit. That kind of flexibility is great to have when your tickets require expertise across departments. But there's often a price to pay: Moving tickets across departments could result in a (well-intentioned) battle for access. When tickets move between departments while agents are working on them, chaos ensues.   To put an end to all these worries, Zoho Desk brings out a new ticket action: simply share. With ticket sharing, everyone gets

• How to get Monday as 1st day of the week?

  Hi, The first day of the week is Sunday in Zoho Creator calendar.So it is hardly usable as in Europe the 1st of the week is always Monday. How can I get Monday as 1st day of the week? Best regards, Chris

• What's New - April 2025 | Zoho Backstage

  Hello there, Phew! It’s been a busy month—and it’s all for you. You know that feeling when your to-do list is long, your coffee’s gone cold, but your team is absolutely crushing it behind the scenes? That’s been us this month. Between brainstorming, building,

• Mi cámara se desconecta permanentemente.

  Buenos días. Tengo una cámara web de última generación. En concreto el modelo W4DS de VIZOLINK. Realiza una primera conexión pero después se desconecta con el mensaje de que no es compatible con ZOHO. Me extraña mucho que una aplicación tan reciente cometa

• Overall unsubscribes from mailing/contact lists

  Hi, I’m looking to track how many people are unsubscribing from our mailing/contact lists overall — not just from individual campaigns. Is there a way to access this total unsubscribe number on a weekly basis for internal reporting? Thanks in advanc

• Tips and Tricks #40: Find and add YouTube videos to your slide from within Show

  Hi Everyone!  When using the right videos in a presentation, you can easily capture your audience's attention and help them connect with your message. This is useful especially when you want to explain any complex concept. For example, you can use a video

• I want to add a button in Zoho Creator that, when clicked, opens a Zoho authorization window and then redirects to my website to obtain API tokens.

  Here's the translation of your text into English: "I want to add a button in Zoho Creator that, when clicked, opens a Zoho authorization window and then redirects to my website to obtain API tokens. When running in the developer environment, I get the

• Enhance Data Visibility with Mapping Fields from Lookup Module

  We’re thrilled to announce an exciting new feature in Zoho Recruit: Mapping Fields from Lookup Module! This powerful addition is designed to display additional details from a related module when using lookup fields. This enhances data visibility and provides

• Feature Request – Support for Stripe Direct Debit for Canadian Customers in Zoho Books

  I’d like to request support for Stripe Direct Debit as a payment option for Canadian customers within Zoho Books. Currently, while Stripe credit card payments are supported for Canadian businesses, there is no option to enable Direct Debit (ACH/EFT) through

• Next Page