BI & Analytics in Zoho Creator 6.0
An online database called Zoho Creator was first proposed 15 years ago. Its most recent version, Zoho Creator Platform, Zoho Creator 6.0, released on March 3, 2022, seeks to allow everyone to develop application solutions on a unified platform swiftly.
insert list into multi select look up
Hello, how would I insert multiple values into a multi lookup field in deluge?
how to restrict a lookup field
Hi, I have a lookup field in order form for customers. I'd like to publish the form, but I do not want customers to see the list of customers behind the lookup field. Is it possible to do it? Thanks a lot! George
Zoho Creator Report - Including Multiselection type fields.
Hi, I have created a table which captures information about client companies. One of the field, "FieldA", offers a selection of 5 options. Now when I try to create a report, this field does not show up on the left hand side of the screen which list the other fields. I also notice that a checkbox field also is missing from this list. Is this a limitation with the report module? If not how do I include these fields in my report. Thank you. Prabha
Any existing integration with Zoho Calendar?
Hi there! Is it possible to send data from Zoho Calendar to Zoho Creator? I mean, directly via an integration made by Zoho, or if the only possible ways at this time are through third-parties, such as Zapier, Make, etc. I tried to find the answer to my
Using a Function to call info based on entered variable
Hi all So heres my case, any advise is appreciated. Im making a calculator for Duty/Tariff rates USer inputs the HTS code, and i need the system to provide the Duty ad Tariff rate. I want to make a single function (or maybe two, one for duty and one
Automatic field update
Hello, In Zoho CRM we are using a custom field to specify a customer "Account Type" with 3 options : - Active - Not active - Prospect We are using Creator Application to make reports on a specific Account that is selected by a lookup field. When an Account
Any way to force delete items without having to delete first every referred occurrences?
Is there a way to force delete items (forms/fields/other) without having to delete first every referred occurrences? If not, is there any existing features in Creator that could help with locating those occurrences faster and more easily? I mean, besides
Fetching multiple fields to create a neat and orderly list (formatted and not empty)
I have 3 email address fields in a form: Email_1, Email_2, and Email_3. I'd like to: fetch all 3 fields based on certain criteria, combine them together into a single list, lowercase everything, then remove empty elements. ... all while using the least
Known Issues and Limitations --> Workflow execution throttle
Hi, I have lookup fields that do not find selectable values in a form. Sometimes they do and sometimes they don't. Sometimes only half of the filter code is executed and not the complete check of a lookup filter values and thus presenting more values
Tip 21: How to dynamically auto-populate rows in a subform
Hi folks, In our last tip we discussed how to autopopulate values in subform rows while clicking on Add New. As promised, in this tip, we'll show you how to dynamically insert rows in the the subform without clicking the Add New button, using our new feature—Insert rows in Subform dynamically. Let's say you have an application where you have the product name in the Mainform field, and you need to automatically display the price of the product in the subform field based on the choice selected in Mainform
Zoho Creator HTML Page
Im currently displaying filtered records from zoho creator to display on a html page. As the records increase the page becomes slower and i know there's a limit to how many records i can display before there's an error. Is it possible to display a set
All You Need to Know About The Brand New Zoho Creator 6.0
Zoho has introduced the Zoho Creator 6.0 as a unified platform that is capable of solving all the digital needs of creators. It has been made to help businesses accelerate their digital transformation and modernization efforts. Packed with a strong and
Can I be migrated to Creator 6 yet?
Hi Can I be migrated to Creator 6? It has been 6 months since my previous request. Do you have a solution? Kind regards Neil
How to enter values for input arguments for my function in Page?
I'm creating app to record lessons and homework completion. I wanted to copy schedule: on day 1 I want to copy lesson1, lesson2, lesson3 to day 2. Function works fine, when I click "Execute", because it asks for arguments (from, to). But when I assign
"Allow New Entries" button for lookup field enhancement
Hi, When using the "Allow New Entries" option for a lookup field it is sometimes necessary to default certain fields in the related form based on field values in the current form. Would it be possible to add an option to set field values in the Field Properties of the lookup when "Allow New Entries" is selected? This would insure data integrity. Thanks, Damien Cregan Hire an Expert
Export on More options disappear when open personalized report view
Hello everybody, I have a public report and I can export my report on More options After I hide some columns on my report, I save changes to create a personalized report view. I saved it with the test view name But, if I open personalized report view the
null vs ""
I was checking for null and the logic failed. I then checked for "" (the empty string) and it worked. So what is the difference between null and the empty string?
How to check for an empty field
I want to set a custom filter to search for records where a certain field is not empty. Effectively, "Field does not contain [blank]" Can someone tell me the syntax for empty or blank please?
Reports - Criteria with is null not working
I have a form with an approval date field (Type Date) and an approved by field (Type text) which is populated using a stateless approval form through a custom action. To create a pending for approval report that lists only the records where approval date is null, I have created a report and set the criteria where approval date is null. The report shows no records even though records exist. Alternately I tried using the approved by field and set the criteria to where approved_by = "" (the option
Conditionally mandatory field??
Hi, Ive seen similar threads on this but none of the examples shown have worked for me. Say I have text fields “Name” and “Description”; and a drop down called “Status” that has 2 choices: “Save” and “Ready”. My Name field is always Mandatory, that’s
Option to protect application
Day before yesterday I was working on my client account in which I had published my application. Since it had some mistake i decided to delete it and accidentally I deleted the original app I had in my account. Before deleting I was prompted to confirm but I didnt realise that I am in my own account There should be an option to password protect the application where in application can be deleted only after the admin enters a password for that particular app. I think this is an important issue and
Zoho Creator Widgets
Hello Guys, So i developed widget it consists a form with fields, in that if I select any particular values from dropdown field, respective values should auto populate in below fields in the form. Using Zoho API I got all records from the respective reports
Use a mobile device (phone app and its camera) to record the check-out or check-in of a physical item.
Use a mobile device (phone app and its camera) to record the check-out or check-in of a physical item. Using a Creator app, User scans the QR code on a physical item: App finds the corresponding record in Creator app. The record auto-populates (via code
Count Days for Page Report Panels in Zoho Creator
I have a form that I use for recruiting. It follows the applicant through various stages of the process. I want to display on a page report how many running days an applicant is in a current status. For example, let's say there are four levels of the
Zoho Pages Embedded Report - Relative Date Filter Based on Parameter
I have a report (bar graph) embedded in a page with months along the x-axis. I want to apply a relative date filter (e.g. trailing 13 months based on a parameter passed to the report. I see the built in relative filter like last or previous n number of
Inserting a report into a from in creator
I've have a form I am building for service calls. I want to have a look up field in the service form filter the report from the service forms by the job name. Is it possible to have the filtered report shown in the service form so techs have the history?
Zoho Creator: How can i use my widgets in my react app ?.
Dears, I'm developing my front-end application using React Js, and I use Zoho Creator to create forms, tables and data dictionary, So how can i use these forms in my react app except using it as an iframe Regards
Display output of a function in ZML Snippet
Hi! I have a function that counts "Yes" string occurrences from a collection of form records //Function to count "Yes" string from "ResponseField" Field in "CustomerSurvey" Form int CustomerResponse() { count = 0; //initialize variable for each rowVar
Post JSON to External Service
I'm looking a various ways to optimize a service on an external server. One of the ways would be to have ZC send a JSON file nightly to this service. Am I correct to say that ZC's POST method cannot do this? Cheers, John Whitney
Issue with Human Resource Management Application
Hi, I have installed the Human Resource Management application from creator gallery. As it have so many things which requires more time to understand, but to get start with basic ones, the attendance buttons on Profile page are not working correctly.
Rearrange how Apps appear on the Dashboard in Zoho Creator?
We would like to rearrange how our Apps appear on the Dashboard in Zoho Creator. Is this possible? They only seem to be listed in order of date added. Is there any other way to sort? Such as "most used" or "most recently used" or "starred"... Or by manually dragging them into a static order. Anything would help...
update field in Form A after change of field.status in Form B
Developing simple tool for Vacation scheduler. Form A (Employee) has a field "vacation days taken". Form B (Vacation Request) has a field "vacation days requested". When request is 'approved' in the Vacation_Request report (I've added button), and status
Creator Pick List Values Cannot be Edited
I have created a connection from Creator to CRM (Accounts). In Accounts I have changed the picklist options for the field Account Type. In Creator I created a form page based on the connection for Accounts. Unfortunately, when I add the Account Type field
Record Summary Footer Problem
Hi All, I am using record summary to generate invoices. My problem is the footer doesn't act like a footer and doesnt appear at the end of the page when I generate a A4 size PDF. so if you just put the footer without other records it will appear at the very top of the page acting like a header:) I have mentioned this issue to support a month ago and still waiting... its crutial for me right now, is there any work around for this? Also wouldn't it be nice to have deluge scripting or some more advancements
Colour From A Drop Down
How can I get the background colour of a cell in a report table to change when a certain option is selected from a drop down box? Thanks, Fraser
Resizing of signature within a record template
Hi There I have two signature fields that get dropped onto a record template, my issue is that they get imported at a huge size which means they run off the report and then don't even appear in the PDF or print options. Is there anyway I can control the
Form publishing
Hi, I want to publish a form. I can see, that the appearance of the form can be set. That's fine. But I want some fields to behave differently than for application users, or just want to hide some fields in the published form, because they were created
Javascript / HTML5 / React UI
I like Zoho Creator, however, I'm not particularly a huge fan of the built in themes. Is it technically feasible to build an app, by using a premade HTML 5 / React / JS dashboard such as: Live Demo Preview - DashboardPack Does anyone have a good example
openURL fetch report
I'm wondering if you can fetch a report with openURL that has a search parameter for added time. I have a working openURL: (- personal information) openURL("https://creatorapp.zoho.eu/export/-/-/pdf/report/?isc5page=true", "same window"); and i want
Next Page