IF-THEN write formula
I am having trouble creating a simple IF-THEN statement that will yield a text description of a number field. This is a common Excel formula and it may be easiest to show how I'd write in it Excel: =IF(Number_Field<100,"Under 100",IF(Number_Field=100,"Equal to 100", IF(Number_Field>100,"Over 100"))) This formula looks up the number in Number_Field and writes, in another column, whether that number is "Under 100," "Equal to 100" etc. Is there a way to do this using the built in formula generatorCreator Page that Has Charts Filtered by CRM Account
We use Zoho CRM. We also have a Creator application called Reports that captures monthly reports with detailed metrics for each CRM Account. We use the Creator integration widget to pull the Account from the CRM and make it part of the Creator recordSubforms added after main records creation have "null" IDs.
Hi Zoho Community, I added a subform (pre-populated) to my main form. I want all existing records to have this pre-filled subform. When I manually edit an existing record, I can see the subform and the pre-filled values. But it does not show in the reportImplement an API call using Oauth 1.0
Hello Everyone; I am trying to communicate with another web application using an app in Zoho Creator, which happens to use Oauth 1.0... The problem is, i am able to test it using Postman successfully, but i can't write the code in deluge to authenticate, specifically to produce the nonce and timestamp needed in Oauth 1.0 protocol... Has anyone successfully wrote a code to authenticate using Oauth 1.0 protocol? Can you share how to make my code succeed? Thanks in AdvanceKanban doesn't trigger workflows
Hello, Im trying to use a Kanban view of my list, but i'm noticing that moving my objects on the kanban doesn''t trigger any workflow, anyone else having this problem? I have a form edited sucess workflow, and it doesn't work if i edit the "deal stage" trought the kanban view, only if i edit it.Populating a picklist another form
I am creating an App for ATTENDANCE MANAGEMENT for a School. I have the forms: - Students (Form1) - Classes (Form2) - Attendance Management (where I monitor the ATTENDANCE of students PER CLASS) (Form3) In the ATTENDANCE FORM (Form3) I have the fields:Get the future date a number of days from the date in a column in a Pivot Table
Hello, I hope that someone can help me. I have a pivot table which has a column with dates in it (Date A), I wondered if it is possible to create a new column that shows the date 180 days from Date A. Is this something I can use a formula for? If so howiframe code: diff between view-embed and report-embed
Using Zoho Creator to enter local nonprofits and sort them, then displaying them on Zoho Sites. A while back a developer helped our sister site get up and running. I noticed that they were not publishing reports and using the iframe code to display themInquiry Regarding Accessing Multi-Select Field in Pivot Chart
I'm currently working on a project and would appreciate guidance on accessing and utilizing a multi-select field within a pivot chart in Zoho Creator. Could you provide instructions or resources to help me implement this feature efficiently? Your assistancePrint Option Accessibility Issue in Zoho Creator
I hope this message finds you well. I'm encountering an issue within our Zoho Creator application where I'm unable to access the print option when combining forms and reports into a single page. As printing is vital for our workflow, resolving this matterPage - Gauge - Target Values
Is there a way to make the Target and Maximum values say a formula or query? For example, total sales for the month = 109 and I want to make my gauge today's percentage.Zoho Creator how to publish forms specific to each client in the Zoho Creator App.
Hi I see how you can publish a specific form to be able to access it externally. But what if I had a Zoho Creator App that multiple clients on it and I wanted to publlish public forms that are specific to each client? Such that I can embed those formsZoho Creator - [Free Webinar] Application Development BootCamp 1.0 - 3 Day Series
Hello Everyone! We are thrilled to announce the addition of another exciting webinar for all of you, titled APPLICATION DEVELOPMENT BOOTCAMP 1.0. About Application Development BootCamp 1.0 Application Development BootCamp is a dynamic three-day webinarPassing Data about a record through a custom button
I am trying to pass data from the record where the custom button is pressed. Do you pass them through the arguments of the function, but the function is outside and not linked to that particular record. How do you go about doing that? Thank you for your helpHow can I get records from zoho people in zoho creator?
I try to get all employees from zoho people in creator using deluge I faced this errorNesting one searchRecords function inside another
Hi all, I am trying to nest one searchRecords function inside another, but when I attempt to save the Deluge I get the following error: Error at line number: Improper Statement Error might be due to missing ';' at end of the line or incomplete expressionSupport Inquiry for Website Development Issues
Hello, If I encounter any issues with the website I have developed and launched on the internet, how can I contact you to request a programmer to address a problem I have on the site and receive a prompt response? Do you have a WhatsApp number or customerHow do you add pagination to a Zoho Creator Page with zoho.crm.searchRecords
I have the following Deluge query which is correctly searching my records of up to 20 records per page, up to 5 page: l_Pages = {1,2,3,4,5}; m_SearchParam = Map(); m_SearchParam.put("sort_by","Registration_Date"); m_SearchParam.put("sort_order","desc");Amount in words in Indian format
Hi, I had coded the following code to convert amount in words. But in the code in the format of US like million. But i need in Lakh and Crore. So pls suggest ideas r post corrected code string Num2Words(int val) { val_s = input.val.toString(); th = {"", "thousand", "million", "billion", "trillion"}; // uncomment this line for English Number System // th = {"","thousand","million", "milliard","billion"}; dg = {"zero", "one", "two", "three", "four", "five", "six", "seven", "eight",Zoho Creator - [Free Webinar] Creator TechConnect Series - Custom widgets and extensions in Zoho Creator - Part 3
Hello Everyone! About the Creator Tech Connect series The Creator Tech Connect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into key essentials and technical nuances while buildingInquiry About Zoho Creator Free Trial and PROFESSIONAL Version
Hello Zoho Creator Team, I'm right now using the free trial of zoho creator and I am interested in upgrading to the PROFESSIONAL version, Will my existing applications receive PROFESSIONAL version advantages upon upgrading? Regarding the "No.of Users"Best way to add custom CSS to Zoho Creator App
Hello, I'm using Zoho Creator to develop a custom app and I was wondering: what is the best way to add custom CSS? I'd like to use classes and ID's in HTML Snippets so I can control styling from a custom CSS file I'll create. Thank youHow to use deluge scripts to insert rows to subform
I have 2 forms, Box form with Seed_Packs entries that links to another Form Seed_Inventory entries. After I have use the import functions, the entries did not link from Seed_Inventory to Box.Seed_Packs, I want to use scripts to do the linking by creatingCan Creator integrate with a CRM Sandbox
zoho & Creator Noob - I would like to build a Creator App and integrate it to the CRM Sandbox. Then, when I have the bugs worked out integrate it to the production CRM account. Can Creator do this ? I built a test Creator App and integrated it to the CRM in a test zoho account fairly easily.Stateless Close Pop-Up Window
Good day, I have a pop-up window with a Stateless form, when I click a button it should close the window, initially it works fine, but now the window stills open, I use the following script openUrl("javascript:window.close ", "Same window"); Best Regards,How to create grouping a report in scripting ?
Hello Guys, Is there any possibility to group the records in the report by scripting. Scenario : If the user click the panel in the page .the report will shown as popup . I am also set a criteria by using Query parameter. Is there any option to groupVerify user permissions for form or report
I'm trying to write a custom function to determine if the current user has access to a report or form. Something like variable = canAccess(<report_link_name>); Is there a function that returns which roles have permissions to access a particular reportCreating a Unique ID (GUID) in deluge
Hi, Is there way to create GUID in deluge? I will have to use this Creator. https://en.wikipedia.org/wiki/Universally_unique_identifier Thanks PSI would like to develop an installment plan
Hello, I'm inexperienced in the field, but I'm trying to develop an expense app and I would like to add the option to pay in installments, so that the expense goes automatically to the following months, if anyone could help me?focus on form field
when you click the edit button on a record the first field of the form needs to have the focus so i can type or tab to the right field without clicking again... tonythomasLong multi line field. Page break in template
Hello. When I have a multi line field in my report that occupies more than one page, a previous page break occurs during printing and exporting to PDF. How can it be avoided? I have inserted in the template, the value div, both "page-break-inside: avoid"Grouping or Summarizing Records
First, I accidentally came across ZOHO the other day. I must say the Creator is VERY impressive. I'm a programmer by trade but have no time use/learn .net or whatever to develop "quickie" type apps that I would use mostly for me. Zoho Creator seems to fit the bill for what I want. Congratulations. I have developed a little small time tracker type application (for me only) that allows me to enter data, hours worked and a category ( and a few other things). It works great. The only question I haveDefault audit log on forms/reports/workflows on Zoho Creator
Namaskaram Zoho Creator team, There is no default audit log on forms and reports for finding that who and when the changes were made in a form/report. It is very important feature to track the form and report history.So basically we need to be able to switch on audit logs for any workflow. If I just go and tap on a checkbox, then all the activity happening in that workflow or using that variable should be captured automatically without any extra scripting. Crafted with ❤️ Zoho Gurus | Zoho CreatorDeleting from a Collection Variable
Hi All I have a collection variable, obtained like this course_Options = Schedule_Courses[Start_Date_Time == time]; This give me a collection variable of courses starting at the above time. If I wanted to remove one of the results from that collection"If data has changed" function ?
Hi Zoho, I have a form with a name, date and type of a certain product. I need Zoho to run a function on "On Success" on Edit mode, ONLY if the date has changed (not if the name of the product has changed). Is there a function that can check "data before edit" or something like this? Thanks RavidAccessing Subform Data using getRecordByID
I am getting data from Zoho Creator using deluge zoho.creator.getRecordByID task, from another application. The report contains a subform, and that subform is in the detail view of the report. I do not appear to have any subform data in the JSON response,Open another form as a Pop-Up
Hello, How do i open another form as a Pop-up Dialogue on click of Button which is a custom button in report? Can anyone help me with a code? Thanksnotification(send mail) when users delete record
The system notifies adminusers by email when users change or delete data from a report. It need to include the data in email so that adminusers know what data users have changed or deleted. When users make a change, the data is attached, but when delete[Free Webinar] Learning Table Series - Creator for the Real Estate Industry
Hello Everyone! We welcome you all to the upcoming free webinar - Learning Table Series. The Learning Table Series is a free monthly webinar that runs for around 45 minutes. It's offered to our Community users and aims to provide a dynamic learning experienceExplain About Parameter In Zoho Creator Custom App
Hello, Please Explain Me About Parameter. Any Custom App > Open Any Page,Form, Report or Anything. > Click On Setting > In Setting In Last Module Is Parameter. So Explain About This & Explain How To Use This. I Attach Screen Shot For Where Found ParNext Page
Access your files securely from anywhere
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
Zoho Creator Upcoming Updates - October 2024
Hello all! We continuously strive to enhance and improve Zoho Creator with new capabilities. Continuing with this journey, we're excited to share the latest developments and progress with you. Now, let's dive into the updates for this month: Widget JSAnnouncing Zoho Creator's 2024 Release Projection 2
Hello Creators! Greetings from all of us here at Zoho! We hope you’ve been having an incredible journey with this low-code platform we all love. And here’s a gentle reminder that it’s that time of the year again—where we open up and give you a sneak peekInteGreat 03: Integrating Zoho Creator with Zoho Books
Hi everyone, Today, we'll look at how to integrate your Zoho Creator app with Zoho Books. This is one of the most popular Zoho integrations that our customers use. You can use this integration to automate processes like: Creating quotes and invoices in Zoho Books from within Zoho Creator Accessing quotes, bills, and invoices from within Zoho Creator Linking bills and invoices to a project and performing profit calculations With Deluge, you can use the built-in integration task to connect with theImportant updates to your connectors
Hello everyone, Greeting from Zoho Creator! We're excited to announce that we'll be rolling out significant backend updates to Zoho Creator's built-in connectors to enhance security by following the latest frameworks. The existing version of some of the[Free Webinar] Creator Tech Connect Series - Directory stores and device management in Zoho Creator using Zoho Directory
Hello Everyone! We welcome you all to the upcoming free webinar on the Creator Tech Connect Series. The Creator Tech Connect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into
Most Discussed Topics
Adding a customer specific record to customer subform
Hi, Can anyone point me in the right direction I have customers as a form with all their details on it. I also have separate jobs, tasks & assets forms that I can also fill out, now when I create one of these records let say for Customer A - I fill outError creating an XML file
I am creating an xml as string in the function Employee.generatePartA_XML_String, and then I want to save it as a file to the field "Part_A_XML", but I get the response: {"code":3700,"message":"Unable to upload a file. Please check and try again."} HowCreate list dropdown of all form names
Hi everyone, Can i create dropdown list by all form names? Thank youDesign custom page
When it comes to designing a page, you have basically 2 options either using "Html snippets" which has a limitation of not being able to render JavaScript meaning that you can't call specific action when a user clicks a button or modify the DOM afterHow do I get a hot link to and an updated field to be send via email
So when I new record is created there is a url shortcut to the new added record, thanks :)
Zoho Developer Community
Zoho DataPrep Resources
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus Resources
Zoho Campaigns Resources
Migrate to Show’s New Community
A place to share, discuss and stay updated about everything relating to Zoho Show presentations.
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Zoho Inventory Resources
Zoho CRM Resources
Sticky Posts
Share your success story
We would like to hear from our passionate users how much Zoho Creator has changed the way you work and benefited you. If you would like to share your story to us and be featured as a proud user of Zoho Creator, then this is for you. Fill up the form below and if you want to be included in a case study, we will get in touch with you to get further details. So what are you waiting for? Tell us your story. CharlesIntroducing Creator Simplified: An exclusive learning series to enhance your app development skills
Hey Creators! Welcome to Zoho Creator's new learning series, Creator Simplified. In this series, we'll dive into real-world business use cases and explore how to translate your requirements into solutions in your Creator application. You can also expectANZ In-Person Zoho User Group Meetups: Focusing on Zoho Creator & Zoho Flow (September 2024)
Hello, Zoho Community! Calling all Zoho users in Australia! We're thrilled to announce the next series of Zoho User Group (ZUG) Meetups, continuing the success of our previous sessions. These meetups are a great opportunity to learn, network, and engageMerge and Store v1 API depreciation
Hi Zoho Writer users, The Merge and Store v1 API allows you to store the merged document in Zoho WorkDrive. The response of this API will be returned with the document's ID only after the merge is complete. In Deluge, the maximum timeout for operationZoho Creator - 2023 Release Projection 1
Hello everyone! A very Happy New Year to you and your family. Hope you're all good and having a great time using Zoho Creator to make your lives easier and your businesses prosper. 2022 was an action-packed year for us at Creator, and we hope to continue
Top Contributors
Damien Cregan
Gordon Mankelow
Sriram U
peter.fraser
Muhamad Bilal