Checkbox Field Operators not working in a Conditional Statement

Checkbox Field Operators not working in a Conditional Statement

I am trying to use the Checkbox field as a boolean instead of a text type field. I used the Checkbox (true or false) in an IF statement to determine what text to show, but none of the operators seem to return the result I am expecting.


Attached is a picture of my test document to showcase the problem.
I could use a text type field over a checkbox for booleans, but the boolean data passed in does not come as a string and I was hoping that Zoho Writer had support for boolean data instead of needing to convert the boolean data into strings.

Can anyone help on how to fix this or have insights on the same issue?

    Access your files securely from anywhere


            Zoho Developer Community





                                      • Desk Community Learning Series


                                      • Digest


                                      • Functions


                                      • Meetups


                                      • Kbase


                                      • Resources


                                      • Glossary


                                      • Desk Marketplace


                                      • MVP Corner


                                      • Word of the Day


                                      • Ask the Experts



                                          Zoho Marketing Automation
                                                  • Sticky Posts

                                                  • Deprecation of certain URL patterns for published Zoho Writer documents

                                                    Hi Zoho Writer users! We'd like to let you know that we have deprecated certain URL patterns for published and embedded documents in Zoho Writer due to security reasons. If the published or embedded documents are in any of these URL patterns, then their
                                                  • [Announcement] Insert image from URL changes in Zoho Writer

                                                    Hi Zoho Writer users! We'd like to let you know that we've changed the behavior of the Insert image from URL option in Zoho Writer for security reasons. Earlier behavior Once you inserted an image URL in a Writer document, the image would be fetched from
                                                  • Introducing plagiarism checker in Zoho Writer

                                                    Zia, Zoho Writer's AI-driven writing assistant, now highlights plagiarized and duplicated content in addition to offering contextual grammar and writing suggestions to help you write clearly and concisely in English. Zoho Writer's plagiarism reports Here
                                                  • [Important announcement] Impact of Google's new email guidelines for Zoho Writer automation users

                                                    Hi users, Google has recently announced new guidelines for sending emails to Gmail and other Google-hosted domains. These guidelines will be effective starting Feb. 1, 2024, and can impact the delivery of emails sent from Zoho Writer. Your organization
                                                  • Transitioning from MS Word to Writer: A complete walkthrough

                                                    Hello everyone! We understand moving to a new word processing tool can be difficult, especially if it means switching from a legacy software like MS Word. That's why we've organized an exclusive webinar where we talk you through ways to make your switch from MS Word to Writer as easy as possible. In this webinar, you'll learn: - Why Writer is a simple yet powerful alternative to MS Word. - How to locate your favorite MS Word features and functions in Writer.  - How to migrate your Word documents


                                                  Manage your brands on social media



                                                        Zoho TeamInbox Resources

                                                          Zoho DataPrep Resources



                                                            Zoho CRM Plus Resources

                                                              Zoho Books Resources


                                                                Zoho Subscriptions Resources

                                                                  Zoho Projects Resources


                                                                    Zoho Sprints Resources


                                                                      Qntrl Resources


                                                                        Zoho Creator Resources



                                                                            Zoho CRM Resources

                                                                            • CRM Community Learning Series

                                                                              CRM Community Learning Series


                                                                            • Kaizen

                                                                              Kaizen

                                                                            • Functions

                                                                              Functions

                                                                            • Meetups

                                                                              Meetups

                                                                            • Kbase

                                                                              Kbase

                                                                            • Resources

                                                                              Resources

                                                                            • Digest

                                                                              Digest

                                                                            • CRM Marketplace

                                                                              CRM Marketplace

                                                                            • MVP Corner

                                                                              MVP Corner





                                                                                Design. Discuss. Deliver.

                                                                                Create visually engaging stories with Zoho Show.

                                                                                Get Started Now


                                                                                  Zoho Show Resources


                                                                                    Zoho Writer Writer

                                                                                    Get Started. Write Away!

                                                                                    Writer is a powerful online word processor, designed for collaborative work.

                                                                                      Zoho CRM コンテンツ






                                                                                        Nederlandse Hulpbronnen


                                                                                            ご検討中の方





                                                                                                  • Recent Topics

                                                                                                  • ZOHO Expense API Documentation - Can't see anything about Purchase Requests

                                                                                                    Hello, I am reading the API Documentation for Zoho Expense but can't see anything about Purchase Requests - This is one of the modules we use the most. Has anyone had any luck getting Purchase Requests data from Zoho Expense via API? Thanks,
                                                                                                  • KPI Widget - last month sales vs same period last year

                                                                                                    I would like a KPI Widget that might compare data with the following date ranges: This month to date (meaning all of February through the current date, for example the 14th, if today was the 14th. So Feb 1-14th 2018)vs. last year this month to date (Showing
                                                                                                  • Client Script event on any field of a Detail page

                                                                                                    Hi everyone! I'd like to trigger a Client Script when a user modifies a field - any field - from the Account Details page, how can I do this? I don't want to trigger it on a specific field, but on all of them. Thanks in advance!
                                                                                                  • Zeptomail Support

                                                                                                    My zeptomail was blocked and i was notified to contact support. I have opened five tickets and no one is responding to my queries. I went through possibilities of the block and discovered the issue was due to suspicious mails sent through one of the mailagents.
                                                                                                  • GSTIN Public Search API

                                                                                                    Does zohobooks have an api using which i can search GST numbers and get their details?
                                                                                                  • Restrict Past Date in Zoho CRM Module

                                                                                                    How can I restrict from selecting a previous Date? I want only future dates to be selectable
                                                                                                  • Pushing GCLID info from Gravity Forms to ZohoCRM

                                                                                                    We are switching to Gravity Forms from Zoho Forms and I cannot find any good info on how to make sure my GCLID tracking info is pushed through to the CRM through my new forms. There was an article in the documentation about placing something within the
                                                                                                  • Add tasklist from a template to Zoho Project using Deluge

                                                                                                    I have some tasklist templates that I want to be able to add to a project under certain circumstances. So if a project meets Condition A, add the tasklist from Template B to that project. If it meets condition C, add tasklist from Template D, and so on.
                                                                                                  • 'Add Tax To Amount' not reflected in Invoice

                                                                                                    Hi Zoho Support, I'm experiencing an issue with tax calculation display in my invoice template. Despite having "Add tax to amount" box checked in the template settings, the Amount column is not showing the tax-inclusive total for line items. Current behaviour:
                                                                                                  • Enhancing self-service capabilities with AI-based Zia Answer Bot

                                                                                                    Hello All, Zia Answer Bot is available with better accuracy to enhance the self-service capabilities of the platform and to empower the users to resolve queries independently. By leveraging knowledge base (KB) resources, the Answer Bot provides accurate
                                                                                                  • Rounding off rate in quote

                                                                                                    Hi team, Please help me to rounding of rate amount in quote
                                                                                                  • Zoho Flow custom functions "Error occurred while processing this request. Contact support for more details"

                                                                                                    Any ideas why this is happening? Zoho Flow custom function...
                                                                                                  • Introducing our latest privacy enhancement - Hiding email IDs in Zoho Cliq Networks

                                                                                                    Hello everyone, Zoho Cliq Networks offers a powerful collaboration platform that allows businesses to create dedicated digital workspaces for external vendors, partners, or individuals you want to communicate with professionally without adding them to
                                                                                                  • I need to add difference for Average Row at the end

                                                                                                    (Confidential data hidden here) Guys, hello! I have this graph, it calculates the averages of Retention and then shows the delta (2024 - 2023). In the 3rd column with delta Churn %, I want to show the difference between averages too, which would be (16.99
                                                                                                  • No encuentro la opción para crear una orden de compra

                                                                                                    No encuentro la opción para crear una orden de compra, soy nuevo, ya busqué tutoriales, pero no me aparecen dichas opciones.
                                                                                                  • Post on behalf of employees as well as business socials

                                                                                                    Is there a way to give our sales team access to social to add their own LinkedIn accounts, so that when we schedule business posts, we can also post on behalf of them at the same time so they don't have to repost etc.
                                                                                                  • Alignment of Company Information Page Structure in Zoho One and Zoho Desk

                                                                                                    Hello Zoho One Support, We appreciate the continuous improvements across Zoho products. Recently, Zoho Desk restructured the Company Information page into three distinct sections: Company Profile – Includes Company Name, Logo, Alias, Description, Website,
                                                                                                  • Trying to setup a record to automatically create on a weekly basis

                                                                                                    Hello all, I need multiple records to be automatically created on a weekly basis. What I'm trying to accomplish is, I have a maintenance database where I track when I work on IT related systems. Every week on the same days I perform backups on systems
                                                                                                  • Effortlessly advance through your CRM blueprints by including optional fields in transitions

                                                                                                    Editions: Professional edition and above DCs: All Release plan: This enhancement is being released in a phased manner to customers. It will soon be available to all users. [Updated on 5 Sep 2024] This enhancement has been released to all users in all
                                                                                                  • How to merge duplicate products?

                                                                                                    merge duplicate products
                                                                                                  • How can I delete duplicate transactions?

                                                                                                    I want to delete the duplicates not simply exclude them. I have duplicates, because I had automatic bank feeds turned on (had to make sure this critical functionality was working before migrating to Zoho). Now when I import my csv's exported from Wave,
                                                                                                  • Automate posting to job site boards via Deluge/ or Schedule

                                                                                                    Hi Zoho Recruit Community, I'm working on automating a recurring job posting for a long-standing labor hire role that we update monthly. Right now, I can automate the creation of the job opening using scheduled tasks and Deluge scripts. However, the challenge
                                                                                                  • Customer Statement Template

                                                                                                    Hi. how can i add order number "customer LPO number" in the customer statement. regards
                                                                                                  • Is it possible to select the methods of inserting a signature (Not provider)

                                                                                                    Hi, I tried to search through the help pages and application interface trying to find if there's a way to limit the assigned signees, for example, allowing only images or drawing, and disallowing the automatic signature creator as per their name. It'll
                                                                                                  • How To Sync 'Deals' data To The Related Contact In The 'Contacts' Module

                                                                                                    Hi there! I'm looking to be able to sync Deals and Contacts. Basically, when someone places an order we have it syncing the order data to Deals, complete with the customer's name and email. Is there any way to have that Deal synced to the matching contact in the Contacts module? Presumably matching by email address. I'm familiar with Workflows, however it doesn't seem that Workflows work across different modules. We're looking to be able to run reports based on what the customer bought, but can't
                                                                                                  • Zoho CRM Appointments and Services

                                                                                                    The Appointments and Services modules are nice but very limited. Is there any chance that Zoho will make these more customizable or expand the fuctionality? Appointments Allow "Appointment For" lookup to the Deals module. For us and I'm guessing others
                                                                                                  • How to separate Vendor custom fields from Customer custome fields

                                                                                                    Hi, Customer and Vendor form are separated in Books. We are synchronising them with (respectively) CRM Accounts and CRM Vendors. We add Customer Fields in Customer & Vendors Fields in Books as the CRM has some we need to synchronize. But Books shows Vendors
                                                                                                  • Auto scan receipt multiplies values by 1000 where decimal separator is comma

                                                                                                    This is a new problem as it worked properly in the past but not since Jan 2025. Where receipts use comma as the decimal separator values are multiplied by 1000 when auto scanning which means the user must go back and edit the expense.
                                                                                                  • Free webinar! The Zoho Sign Masterclass: The basics, latest features, and mobile apps

                                                                                                    Hi, Are you new to Zoho Sign or looking to brush up on its capabilities? This webinar will help you master Zoho Sign from the ground up, covering everything from the basics to the latest features. Whether you're an individual managing personal documents,
                                                                                                  • How to upload image from Creator field to CRM File Upload Field or Module Notes section

                                                                                                    Hello,  How can I upload an image from Creator Image Upload Field to CRM Module Image field (or Notes section).  The file upload field type would also work. I just cannot seem to find a way to upload the images from one application to another. Case: Field record requires images as part of the report. I would like the image from the field record form in Creator to be uploaded in the CRM as well as.  All of the other fields from the Creator Field Record Report work perfectly. Thank you very much for
                                                                                                  • Write-Off multiple invoices and tax calculation

                                                                                                    Good evening, I have many invoices which are long overdue and I do not expect them to be paid. I believe I should write them off. I did some tests and I have some questions:  - I cannot find a way to write off several invoices together. How can I do that,
                                                                                                  • Unable to pay bill from Prepaid Expense account

                                                                                                    Our transport vendor requires us to use their prepaid system.  We have paid R1150 upfront into the Prepaid Expenses account: As we use their services, we get billed.  These bills must obviously be settled by from our prepaid account.  I am unable to record
                                                                                                  • Whatsapp Integration not working

                                                                                                    Hello. My whatsapp integration does not seem to be working. I have created templates, but whatsapp messages do not go through. They keep telling me to use a templete, even though I do so.
                                                                                                  • Unable to import data into zoho analytics using the post man APIs of udemy for business

                                                                                                    Hi Can some one help me with the following Unable to import data into zoho analytics using the post man APIs of udemy for business through API beta feature, I have created the sample report in zoho analytics through the table structure but i am unable
                                                                                                  • errorCode":8504. What is wrong with my CONFIG?

                                                                                                    I can't determine what is wrong with my config. It worked properly until I added an additional field, but the additional field is just a number and shouldn't effect the config. I am attempting to do a bulk update add to an existing table based on this
                                                                                                  • Analytics report issue

                                                                                                    Hey, does anyone know why suddenly our Analytics report goes blank whenever we add a field from the contacts module? It shows when adding fields from all other modules. Thanks.
                                                                                                  • Send emails directly via Cases module

                                                                                                    Greetings all, The ability to send emails from the Cases module, which users have been eagerly anticipating, is now available, just like in the other modules. In Zoho CRM, Cases is a module specifically designed for managing support tickets. If your organization
                                                                                                  • Zoho CRM Calendar View

                                                                                                    Hello Zoho team, We need desperately a calendar view next to list, kandan and other views. I think it should be easy to implement as you already have the logic from Projects and also from Kanban View in CRM. In calendar view when we set it up - we choose
                                                                                                  • COST CENTER

                                                                                                    Hello, Is it possible to add cost centers.
                                                                                                  • High cpu load on client side by process sessionaudit.exe

                                                                                                    Hi, as stated above. This happens every time with different clients. Now, the first thing I have to do after making the connection is to go to taskmanager on client computer and kill the process 'sessionaudit.exe' If I don't their cpu is very high and
                                                                                                  • Next Page