Date triggering Workflow rule

Date triggering Workflow rule

I have a function triggered by a workflow rule. The function takes a date and creates a task for that date and fills in a field with the name of the day for that date. It also updates the status field of the record. The workflow rule is set to run whenever a record is created or edited. If the date field is empty and I enter a date, it works fine. However, if I merely change the date, nothing happens. If I clear the date, and then enter a new date it works. Is there a way to make it trigger the function just by editing the date without having to clear it first?
    • Sticky Posts

    • Function #46: Auto-Calculate Sales Margin on a Quote

      Welcome back everyone! Last week's function was about displaying the discount amount in words. This week, it's going to be about automatically calculating the sales margin for a particular quote, sales order or an invoice. Business scenario Where there is sales, there's also evaluation and competition between sales reps. A healthy rivalry helps to better motivate your employees to do smart work and close deals faster and more efficiently. But how does a sales rep get evaluated? 90% of the time, it's
    • Zoho CRM Functions 53: Automatically name your Deals during lead conversion.

      Welcome back everyone! Last week's function was about automatically updating the recent Event date in the Accounts module. This week, it's going to be about automatically giving a custom Deal name whenever a lead is converted. Business scenario Deals are the most important records in CRM. After successful prospecting, the sales cycle is followed by deal creation, follow-up, and its subsequent closure. Being a critical function of your sales cycle, it's good to follow certain best practices. One such
    • User Tips: Auto-Create Opportunity/Deal upon Quote Save (PART 1)

      Problem: We use quotes which convert to sales orders but Users / Sales Reps do not create opportunities / deals and go straight to creating a quote. This leads to poor reporting. Implementing this solution improves reporting and makes it easier for users.
    • Custom Function : Automatically send the Quote to the related contact

      Scenario: Automatically send the Quote to the related contact.  We create Quotes for customers regularly and when we want to send the quote to the customer, we have to send it manually. We can automate this, using Custom Functions. Based on a criteria, you can trigger a workflow rule and the custom function associated to the rule and automatically send the quote to customer through an email. Please note that the quote will be sent as an inline email content and not as a PDF attachment. Please follow
    • Function #50: Schedule Calls to records

      Welcome back everyone! Last week's function was about changing ownership of multiple records concurrently. This week, it's going to be about scheduling calls for records in various modules. Business scenario Calls are an integral part of most sales routines.. Sales, Management, Support, all the branches of the business structure would work in cohesion only through calls. You could say they are akin to engine oil, which is required by the engine to make all of it's components function perfectly. CRM
    • Recent Topics

    • Can we connect Zoho Billings with QuickBooks?

      Hi, On the old page of Zoho Billins (Zoho Subscriptions), it mentioned that we could connect Zoho Billings with QuickBooks. I don't find QuickBooks on the list of integration on Zoho Billings page now. Is it still possible to connect Zoho Billings with
    • Zoho emails not being delivered to Hotmail accounts!!

      Hi, I have this problem I already posted yesterday. My emails are not being delivered to hotmail accounts. They do not even appear in the Spam folder. I already enabled the Domain Keys for my domain and setup the SPF record in my domain manager v=spf1
    • Data migration Limits

      We are in the process of migration from Global version to Mexico. We have downloaded all the information ( 5 years) and are stopped with the transtaction limits. We have over 30,000 Sales orders. and we can only upload 7,500 in the zoho finance plus verison.
    • Best Way to Extract Structured Data from Emails in Zoho Desk/Flow

      I am trying to automate the processing of NSF (Non-Sufficient Funds) notices received via email in Zoho Desk. Specifically, I need to: Extract specific details from the email body, including: Account Number (e.g., "Account Number: 987654321") NSF Amount
    • Reusable Custom Functions Across Department Workflows

      Dear Zoho Desk Team, We appreciate the powerful workflow automation capabilities in Zoho Desk, particularly the ability to create and use custom functions within workflows. However, we have encountered a limitation that impacts efficiency and maintainability.
    • Why are Deals from ZOHO CRM not synced to ZOHO Desk?

      We are working with Deals in ZOHO CRM to register new assignments from our clients. I would like to service the execution of these Deals via ZOHO Desk, but apparently ZOHO Desk does not automatically show the Deals connected to Clients as registered in
    • Invoice Line Item Report

      Is it possible to run an 'Invoice Line Item Report'? The 'Invoice Details Report' shows one row per invoice. I would like one row per Invoice Line Item.
    • Allow Validation Logic to Prevent Merging Specific Tickets

      Is there a way to add a validation to the "Merge" process such that if one of the tickets being merged meets a specific criteria, the system prevents the merge? We have run into issues where a team member merged a ticket that clearly should not have been
    • Add second Help Center [resolved]

      Hi, I need to create a second help center. My two help desks must be independent, each with a custom subdomain, and no common base for users. I don't want in center A they can send a ticker to center B, and vice versa. The first one is functional, and
    • Images not showing up in Desk tickets

      Customers are trying to send us screenshots to diagnose their issues. But Desk seems to be stopping the images/breaking the link when the ticket comes in. (We can see them in an email box getting cc'd on all tickets...so it's not our mail system). Help!
    • Hide/Remove Zia search bar in Mobile app

      How do i hide the Zia Search button " Search across Zoho apps " in the app?
    • Perform mail-merge operations in Zoho CRM right from your iPad and Android tablet web browsers too!

      Dear All,  Greetings! Writer's recent update offers unrestricted access to all its features via the web browsers of iPad and Android tablets as well. This in turn makes it possible to perform all mail-merge related operations from Zoho CRM, even from
    • Automating Follow-up Email After Call Ends – Best Approach?

      Hey Everyone, I want to set up an automated follow-up email that gets sent to a client right after a call ends in Zoho CRM. I checked workflow automation, but I’m not sure if there’s a direct way to trigger an email based on call completion. Has anyone
    • Adjusting the company logo size within an email template - how?

      We try to use the company logo that we have in Zoho CRM in our standard emails from Zoho CRM. The Logo however is very "large" and as such looks to large if we just use the code: " ${companyLogo}" What would the code be to resize the logo above in the
    • Sales without Invoice refund

      I have a sales without invoice in my stripe account from April. This is a double entry as the customer paid the invoice and that was recorded in Stripe. I cannot delete it as it was included in a VAT return. I need to remove it or refund it to balance
    • Zoho Creator App used through Zoho Connect/Workplace Account - Issues - Formulas & Connecting Zoho Forms

      Good evening! I am having trouble connecting Zoho Forms to my Zoho Connect App (Workplace subscription - so not full Creator account). Does anyone have ideas on how to make the submitted form feed into the app to creator a record? Part of the trouble
    • hour() deluge function always return 0, how to get hour using deluge?

      I am trying to get hour from Date/Time field like this createdTime = lead.get("Lead_Creation_Time"); hour = createdTime.getHour(); info hour; // this line will returns '0' but the result will always zero, I expect it will return '13'
    • How to enter Bank Account details for Auto-Charge via API

      We need to add Bank Account info for a recurring invoice to enable auto-charge. Can this be done via the API? I know that we can add credit cards using the following: POST https://books.zoho.com/api/v3/recurringinvoices/<rec_inv_profile_id>/card/<customer_card_id>?organization_id=ORG_ID&authtoken=AUTHTOKEN
    • Close a task without tagging it as completed

      Hey everyone, I have a question which is bothering me for a while now. In our custom contact's record detail page view layout, we have a related list with all the open tasks for this specific contact (the system-defined one). A task can be 'completed'
    • Cannot set Subform Multiline field to read-only using Client Script

      I am using client script to set different subform fields as read-only It works for Single Line Fields, but when I try to set a Multiline field as Read-only it doesn't work var subform = ZDK.Page.getSubform("Subform_1"); var item_Code_old = subform.getField('Item_Code_Old').setReadOnly(true);
    • Log360 Cloud is now integrated with Zoho One!

      Hello all! We're excited to announce that ManageEngine Log360 Cloud is now available in Zoho One.This app is an SIEM solution developed by ManageEngine and below is an overview of the product's notable standalone aspects, which are now extended to Zoho
    • Can I trigger workflow rules only on weekend and certain hour?

      I want to trigger a workflow rules on the leads created between saturday 5 pm to sunday 5 pm. can I do that? i have tried to search but I cant find option something like that. is there any workaround to solve this?
    • "Extra keys limit has exceeded"

      Hello, Has anyone encountered the below message before in a workflow log failure: "Update Record Response is {\"code\":52,\"message\":\"Extra keys limit has exceeded\"}" The script is supposed to generate an invoice for a deposit when a deposit payment
    • Merge Fields in Email Templates using Custom Object Data

      I'm struggling with the following: MyCustomData has fields "serial number", "site ID", "chip number" Contact Has-a MyCustomData Account has-a MyCustomerData I want to email all contacts, or account contacts using an email template but I want to reference
    • Changing Customer Currency

      It seems so silly that you can't change a customer's currency after a transaction is recorded. We work with companies all over the world and sometimes they might request an invoice in a different currency. To do this I have to create another customer
    • How to Schedule onsite Estimate?

      I just want to schedule a simple onsite estimate. How do I do this?
    • Linking module does not allow Subforms

      The title says it all: I don't know why this is the case, but I start to hate the system and regret my decision of implementing it across our whole organization because of all the limitations we are facing. What should we do now?
    • Cannot receive Mobile Verification

      I cannot receive any mobile verification since today.
    • Report of Leads/Accounts/Deals with no open activities

      How can we replicate the option in filter to only show Leads/Accounts/Deals with no open activities ? The option is present in the filters (please find screenshot) but I am unable to find them in the report. Thanks
    • Unified Notes View For Seamless Collaboration

      To facilitate better coordination among different departments and team members, the notes added to a record can now be accessed in all its associated records. With this, team members, from customer service representatives to field technicians, can easily
    • Can I send Whatsapp template using Deluge function?

      Hi, Can I send Whatsapp template in Business Messaging using Deluge function? I have tried to search the documentation but I can't find it
    • Zoho Meeting very bad video quality

      Hello, I need 1080p HD on my Zoho Meeting as explained here: Low Resolution/Quality Video (zoho.com) Currently, video quality is lagging with 400mb internet which is not acceptable for my business. My 1080p 60FPS webcam performs well on platforms like
    • ZOHO CRM Canvas for Hebrew

      I would be happy if you would add the canvas form option to the Hebrew version as well. Moderation update (24th February 2025): We have an existing thread discussing the need to extend Canvas support for Hebrew (RTL), where users have been sharing their
    • Create Sticky Notes

      Hi, the on page option to create sticky notes is a great idea and very useful. One thing that is more of an annoyance for me is that the word wrapping doesn't work very well. There are too many orphans which make it look untidy and awkward. See image.
    • Zoho CRM, can a deal be reverted back to a lead?

      Zoho CRM, can a deal be reverted back to a lead?
    • Work Type - Limitation

      Hello, I'm setting up work types and have noticed, a limitation on the parts area to 10 lines. Can this be increased to 20 or greater? In addition to this, when I attempt to add the work type to a work order, the correct labour hours doesn't flow through.
    • Adding a New Project Template.

      I am currently using the ZOHO Projects Classic plan and am unable to add the new project template I have created. Could you please provide more insights on why I am unable to add the project template alongside the other templates?
    • Time calculations.

      Hi, I have the simplest of forms, with two option buttons either Kiln A or Kiln B, and submit button. This is used as a stime stamp at the start of a firing at the time eack kiln is started. What I need or want to add in the All Entries are a couple of
    • Create a new contact when a new record is added in a custom CRM module

      Hello. We created a new CRM module. We want to create a new Contact each time we add a new record to the new module. Can anyone suggest the best way to do this?
    • Découvrez Zia GenAI : l'IA générative native de Zoho pour Zoho Desk

      Nous sommes heureux d’annoncer le lancement de la version bêta de Zia GenAI dans Zoho Desk, désormais accessible via notre programme d’accès anticipé. Ce modèle d’IA générative est conçu pour optimiser l’efficacité et la qualité du support client, et
    • Next Page