Best Practice for mapping Zoho Creator application before building
Dear all, simple feedback thread here, I'm genuinely interested in learning how you all map out your Creator applications before building (if at all). I.e. do you use UML or any other form or schematics? Please post your replies as well as screen snippets
PDF Export Header and Footer for Pivot Table Not Able to Editable
Hi, want to understand why I can't edit the header and footer for the PDF export for my pivot table? Thanks.
Using deluge in report filter
I'm trying to create a report filter that looks up a value in the user profile. But when I add the function to the report filter criteria, Zoho keeps adding quotation marks to it. I enter Container_ID starts with thisapp.get_user_containers(), but when
Geo code with postal code
Hello, I was hoping to get the longitude and latitude with the zoho geo code feature by just using the postal code/zip code but am having some issues with this as it keeps giving me errors. Has anyone had any success with this? postalCode = "M4K 3B9";
Include Image from Image Field in Record in EMail
I'm sending emails with data from a Creator database. Each email is the contents of one record in my Employees form. One of the fields in the Employees form is an image that was uploaded to an image field in the record. There is a different image stored in each record (i.e., a different image for each employee). What code do I use to display the image in the message body of my email? Thanks. Jon
Labels misplaced for subform fields in C6
Hi everyone, I recently moved to C6 and I noticed that the labels for all my subform fields are misplaced as you can see in the screenshot attached. Have you any idea of what happened??
Custom Report Layouts are TRUNCATING TEXT elements on Mobile and Tablet Views
I genuinely think this is a bug with Zoho Creator. I made a custom layout for a report view on Mobile and Tablet. For some reason, some text fields are randomly being truncated while others are not. If I refresh the report, a different set of records
Connect two forms and send email to customer
Hi, I would like to collect data from our customers using this 3 steps: 1. In our shop, our staff fill a form with an order number and customer email. 2. The customer receive an email with a link asking him to complete all the data, like name, phone,
Rounding does not fix character limit validation
Following this update ("Announcing strict validation for the max character length field property"), I have been working to fix character limits in my forms. I have introduced this code: input.Actual_Work_Time = input.Actual_Work_Time.round(11); The code
Code not working
Hello, I met a strange issue today, never seen this before. Last time (a month ago) when I used this part of the code, it was working fine. I am the admin, and did not change anything in the code. The flow is, that production form is opened from an order
Can I use Creator Form to upload files to Dropbox but not store the file within Creator?
Hello all, I'm very new to Creator so please bear with me if this is answered somewhere and I can't find it. I'm creating a database of sorts within Zoho Creator to store information on items I deal with in my work. Each item will have files associated
Is it possible to auto populate a sub form on load?
So i want to auto populate fields in a subform based of data passed when the user opens the main form.
Images in Reports suddenly no longer loading (except on an older computer)
I have several Zoho Creator reports w/ images hosted via Godaddy web server. Last week, all of a sudden, all images in all reports stopped loading on all up-to-date Macs and PCs within our company. The only computer able to see the images is a 2011 Macbook
How to fetch html element using deluge
Sir i am facing problem in fetching html element by using deluge. Like in javascript we can use document.getElementById() Can deluge do the same?
insert list into multi select look up
Hello, how would I insert multiple values into a multi lookup field in deluge?
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
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
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
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
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?
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
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
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.
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