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

    • Zoho Mail - Import Event from the main page (not options)

      Hello, If you need to import an event or invitation in Zoho Calendar, you need to go in the options/parameters to do the import. We would suggest to have a "import" button and pop-up on the main calendar page. It would avoid to go in the options to do
    • Syncing Fields Between Accounts AND Deals

      Please don't email me, I will check this thread for updates daily. I have a custom set of 10 fields (CFSET) in my account pages and deals pages. I want to fill them out on accounts pages per each, then when I make a new deal in an account, I want to copy
    • Getter error message Number of statement execution limit exceed Line:(216)

      Hi, this script is giving me error message "Number of statement execution limit exceed Line:(216)". Please advise htmlpage Pay_Period_Details(PayPeriodID,AgentID,ShowPrint,start_range,end_range) displayname = "Pay Period Details" content <%{ /* Get The current Pay Period Record */ Int_Pay_Period_ID = PayPeriodID.toLong(); Current_Pay_Period_Record = Pay_Period[ID == Int_Pay_Period_ID]; Previous_Pay_Period_ID = thisapp.Application.GetPreviousPayPeriodID(Current_Pay_Period_Record.ID); /* Checking Agent
    • How to Add Portal Users in Zoho Creator's Development Environment for Testing?

      Hello, I’m working on a Creator app with a customer portal and implementing filters based on the logged-in user (customer). To test these filter functions, I'd like to simulate or add customer portal users in the development environment/database. Is there
    • 2024年度 Zoho Champion 決定のお知らせ

      ユーザーの皆さん、こんにちは。Zoho コミュニティチームです。 Zoho コミュニティでは、2024年の1年間でコミュニティに貢献し、他ユーザーの役に立つ活動・情報発信を特に積極的に行ってくださった4名の方を、 「Zoho Champion」 として表彰させていただきます! @西尾真言さん、 @Kunio さん、@岡安裕一(Yuichi)さん、@Suzuta さん ユーザー交流会の事例セッションへの登壇、フォーラムへの投稿 / 質問への回答や各活動についてのフィードバックなど多くの貢献をいただき、大変感謝しています。
    • Report support List data.

      Hi Could Report support use list data? I hope I can create a list with deluge and push to a report. It will increase efficiency .I don't need insert data to a form.
    • Unique Use Case?

      We operate a lawn care & landscaping company and are developing an instant estimator on our website based on a lot size api. Is there any way to pass a monthly subscription price onto a hosted payment iframe? Every user will have a different price so
    • API to Apply Retainer invoice payment to Invoice

      Hi Team, I could not find  API to apply the Retainer invoice payment to existing Invoice. Can you please help ? Attaching the screenshot
    • Enhance Zoho Flow's Jira Integration

      Hi, I hope you're doing well. We would like to request an enhancement to the Jira integration within Zoho Flow. Currently, Zoho Flow allows us to create and fetch users in Jira, but it lacks essential functionalities related to user management within
    • Zoho Show Slide Decks Not Accessible

      Hi. Currently, my Zoho Show slide decks are not accessible. Please fix it. My Writer files are still accessible, so I'd think something Zoho Show-specific has happened. Thanks!
    • Unable to see clients/accounts from my CRM on Zoho Recruit.

      I am wanting to see my clients/accounts that are on my CRM within Zoho Recruit. CRM and Recruit seem to be integrated as I have access to all of the candidates, but there is no option to get my clients on there. I have activated the extension in marketplace
    • Auto-Create OneDrive Folder Structure Upon Lead Creation

      Hello, New to Zoho and looking for help on a critical process automation I'm looking to implement. My company currently utilizes OneDrive for file management and the folder structure is Proposals -> Client Name -> Address (where I need to initially create
    • Images uploaded onto text notes through the mobile app won't render

      When uploading am image onto a text note, exiting the note and going back in, the image is gone and shows an error icon in its place, and also won't display directly on other devices, including on the desktop version. Uploading the same image on the same
    • Internal Support and Assigning Tickets

      I want to set up an Internal Desk Support system. Here is what I need... We need our internal "Support" staff to be the Ticket Owner We need to be able to identify who the "Account Manager" is on that client and get emails as part of the ticket. I'd like
    • No table view in "All departmens" mode

      Hello, I would like to have an overview of all tickets, so I have to switch to "all departments". But here I don't have the possibility to activate the table view. But this is mandatory, so that I can see certain fields without having to open each ticket
    • Get Creator Form Record ID and Subform ID's

      Good Afternoon everyone. I have a Creator form with a on success workflow. I'm trying to get the form record ID and the subform record ID(s) but they keep coming up null. There is data in the subform I use it elsewhere. Can anyone help me pull the ID's.
    • WhatsApp and Zoho Creator Integration

      How we have integrate WhatsApp App with Zoho Creator without using external application ?
    • Ability to use Dynamic goals in Motivator

      Is there any way to create dynamic goals in Zoho Motivator? By "dynamic" I mean: not the same target every period, but varying from period to period. For example, in our organization, sales reps are supposed to target beating the same month's sales last
    • Calendar - "super compact" week view

      every time i go to my calendar i have to re-engage the "super-compact view" for the week view...is there a way to make "super-compact" a default view so I dont have to keep on setting it manually?
    • zoho calendar week view - "super compact by default"

      every time i go to my calendar i have to re-engage the "super-compact view" for the week view...is there a way to make "super-compact" a default view so I dont have to keep on setting it manually?
    • Allow submitter to type a choice in a 'Multiple Choice' field

      Is there any way to allow the person filling out a form to manually type in a choice in the 'Multiple Choice' field? So like have the option of allowing the last field to be 'Other' with an input field...
    • Instagram reset password email not getting through

      Recently joined Zoho. I have the free version. I have a domain registered with Fasthosts, without a hosting package, (no website, no email). I have sent emails to my Zoho email from Instagram to reset my password, but they are not getting through.  Can you help? PS please dont ask me to get any info from Instagram, as they only give stock answers on their help site and I cant find any way to ask them specific questions or to request data. Cress
    • Pages Limit of 5 on Zoho Sites with Zoho One Trial account

      Hello, I was building my website in Zoho Sites (I have a Zoho One Trial plan) and seems like I've reached a page limit of 5. I then checked the Zoho One limits and looks like the limit is 50 pages per website. I can't seem to find a way to correct this. Is there something you can do on your end to increase the limit on my account? The error I get is "Oh no! Your current plan does not support this feature. Upgrade your subscription to use this feature." when trying to add a new page. Kind Regards
    • How do I configure network solutions to work with zoho sites

      Hi, I have a domain with network solutions and have my zoho mail all set up and working. I cannot get zoho sites to work with my domain, I cannot change the cname to point to zhs.zohosites.com Can you please give me a walkthrough for this? Mick
    • Mapping a custom picklist to another picklist when creating a connected record with a workflow

      Hi, I have some workflows that move records between pipelines, the issue is that when setting up the workflow that creates the connected record, there is no option to map the value from a picklist in one pipeline to another. Please watch: https://www.loom.com/share/4e5fa969b21043748414154c036cdd47?sid=dca0fd16-73f2-4fe6-a9d3-7a4c0c40c2e6
    • Initiate data import using Deluge script

      Is it possible to open the screen to begin the importing of new records using Deluge? So for example, my users would click a button on a form that starts a workflow action. This action would then open the screen to "Import Data for Current User Projects".
    • Lookup field - Can I avoid using advanced search?

      I have a lookup field in my app that has surpassed 500,000 records, now basic search is disabled and I'm forced to use advanced search. That adds multiple steps to what used to be very simple. Before: Select field > Type last digits of product code and
    • Forced Tooltip on Maps View

      Please remove the forced tool tip data points and ONLY include those listed in the "Include Columns for Tooltip" area. Also, disable the tool tip if no fields in there. With a lat/lng map, it forces showing those (and color field, lat count) and will
    • Last sync date/time as a widget

      Is there any way to get the last date/time that the data shown (reports and dashboard) was last updated. For example, If I have our data being synced every 3 hours and the last was done 2 hrs ago, I would like to show date/time of update OR updated #{hrs}
    • Function #19: Associate invoice templates automatically based on branch

      Much like the custom function we shared last week, today's function also aims to facilitate the automatic association of invoice templates. When you're managing business operations across various branches, there may be a need to create and send invoices
    • Milestone

      New to Zoho and trying to get acquainted. According to PMI a milestone "anticipates what the project is supposed to achieve at a pre-set date. It should describe a desired state of affairs, a desired future situation. There are two important aspects to this. First, the concept refers to a point in time, not a period of time. Second, it looks forward to what we want to create, not how we create it." Why are Zoho milestones defined between two dates and as bins for tasks? Why would you even consider
    • How to send mail with js SDK

      Hell o I'm using https://live.zwidgets.com/js-sdk/1.2/ZohoEmbededAppSDK.min.js, for my widget in CRM (built with sigma) Is it possible to send email from js file, I try ti use that ZOHO.CRM.API.sendMail({ "Entity": "Accounts", "RecordID": sharedVariableEntityId,
    • Report to see committed stock vs quantities on order with suppliers

      Hello Zoho Community, I am looking for a report in Zoho Books / Inventory that will show the committed stock from sales orders, and show what quantities of the same part are on order from purchase orders. I have found the committed stock details report,
    • Zoho Projects Currency fields in Deluge script

      I have several functions I've written in Zoho Projects that take one or more currency fields as input parameters (arguments). These functions have been working just fine for months, and I made no changes to any of them. Today (Jan 21, 2025) I noticed
    • Kaizen #174 : Client Script Commands

      Hello everyone! Client Script Commands feature is a highly anticipated functionality that enables users to trigger Client Scripts anywhere within Zoho CRM, extending the scope of client script beyond standard pages and events. In this Kaizen post, we'll
    • Zoho CRM - Zoho Creator - NFC Tag

      Hi, I'm looking for support for Zoho Creator and NFC. I have read the existing knowledge base, however not all is clear. We have Zoho CRM with custom module 'Equipment' where we have around 1000 records. Our idea is to attach physical NFC tags to the
    • Transformez vos interactions événementielles avec l’intégration WhatsApp dans Zoho Backstage

      Un des plus grands défis de l'organisation d'événements est de garder les participants informés et engagés tout au long de l'événement. L'intégration de WhatsApp dans Zoho Backstage permet aux organisateurs de communiquer directement avec les participants,
    • Getting the Record Id to appeal in the Deals Module

      Hi, I am looking to get the record ID to appear on a deal record. I need to get recrod ID to appear on a document so when they are returned they can be match up with the record we hold in a seperate case management system. The record ID is uploaded to
    • Sandbox for consultants who are helping me develop a report

      Hi. I occasionally need to hire someone who has a Zoho skill I don't have and I need to give them access to my account so they can work. It makes me a bit nervous, but I need them to get a work product done. I set their access as "User" and it turns out
    • I there any way to use a digital pen with a digital desk like Wacom to take notes in Zoho Notebook?

      Hey, guys. I wonder if there's any way to handwrite something and it pull down on Zoho's notebook as a readible image or something like that. Imagine the situation: I don't want to write with a keyboard, but with the digital desk, and I want to the text
    • Next Page