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
Webhook to creator
Hello I am trying to send a webhook to creator from an ai scanning software. I was wondering how do I do this so it creates a record. I have not been able to find any resources for it, is this something that is possible? I would need a url to send the
SaaS / Stage / Issues / Horror
I have been trying to use the new SaaS platform, and it is fair to say, a lot of effort for zero business benefits - so far. I tried to raise these issues through online support, but it keeps responding there is an issue... they are right, quite a few. Rather than wait for online support to work, I have posted here... I need to take comfort from the community as my already grey hair.... The are: on pricing i cannot say it is an annual plan, only provide an annual discount on pricing the text box
Calendar Report - Day/Week View - "all-day"
Dear support, It would be nice if you gave us the option to remove the "all-day" section at the top of the "Day" and "Week" Calendar Report since this feature is inoperable if we're using Date-Time fields. It would be even nicer if you made it operable
How can I create a list of dates between start and end dates?
I have the Start_Date and End_Date variables. I would like to create records for each day between those two dates. Is there any workaround to create the list of dates and then iterate it? I would really appreciate any help or workaround you may know.
How can i customize app theme color?
Hello, Am using Zoho Creator Professional Edition. I have created a app, but am unable to customize my theme color. After search around the forum i found some solutions https://help.zoho.com/portal/en/community/topic/how-do-you-make-a-custom-theme-in-zoho-creator But, i didn't see the "Customize" option under the "Application Settings" menu (see attachment). Where can i find these settings in Zoho Creator? Thanks in Advance.. Thanks, Selvamuthukumar. R
Add report button to card layout
I can add a report button in list view - is there anyway that I can also use it in the card layout ?
Deluge Calculations
My application has a main form and two subforms. Main form = deployments Subform 1 = incidents - incidents responded to during each deployment. Subform 2 = staff - employees who worked on each deployment. I have successfully linked the relationships using the main form's ID. The main form uses a look up field to show which employees were deployed on a given day. Then the Incidents form has a lookup to show which staff responded to which incidents. The main form has a formula field calculating
Report filtering with functions : show all or ignore filter
I would like to know if there is a way to conform a repor filter to show all as well as a single value. Context : I have a function that will return the ID of a single organisation based upon an option chosen by a user that's stored in a form called client_access_form
Edit record link in Customer Portal
I have an application and I am using the following script on my form "Contact_Information" > on load: (I have inserted <appuser> and <appname> in place of the correct code below) record = Contact_Information [Sponsor == input.Sponsor]; if (Contact_Information[Sponsor == input.Sponsor].count() > 0) { openUrl("http://creator.zoho.com/<appuser>/<appname>/#Form:Contact_Information?recLinkID=" + record.ID + "&viewLinkName=Contact_Information_Report", "same window"); } When I am logged in, this
Lookup field filtering
Hello, I have a lookup field that I need to filter based on input in another field. I have already filtered this by setting the filter in form builder to Model(look up field) contains input.Model(single line text field) and this filters it almost the
BCC address or character limit?
Has anyone else encountered a BCC address or character limit? I'm trying to BCC 144 addresses (3424 characters) at the same time, and while the Sendmail task completes successfully, nothing is received on the other end. I was able to BCC all 144 addresses
why i am facing problem in uploading Zoho plugin on Wordpress website?
I am facing an uploading issue of the Zoho plugin kindly give me the solution. regards:
WARNING! Don't upgrade to C6 if you have apps with lookup fields to other apps
After many months of being bombarded by the great new "environment" functionality, I could finally migrate to C6 on my Zoho One account. One of the items on the checklist to migrate is "Sandbox enabled in applications". I deleted my sandbox and upgraded,
Format for adding to a multi-select field via Zapier/API
I am using Zapier to act as an intermediary between a chatbot and Zoho Creator - to allow our clients to add records to the database via a communication. I have it working well, however when trying to pass a value to a multi-select field (it will only
Currency Exchange Rates
To enable me to calculate currency gains and losses, I wish to use today's exchange rate as published by organisations such as XE.com in my multi-currency accounting package. So, I would like to automatically update a table of currency exchange rates every day. I know Zoho provide a number of accounting/invoicing etc. solutions; does any of these provide automatically updated currency exchange rates and if so, can I access these data from Creator?
Dynamically adding sorted record IDs to a multi-select Lookup field
EDIT/Solution: instead "equals to" or ui:add, use .select (https://www.zoho.com/deluge/help/client-functions/select-deselect.html). IDs = Form1[Criteria].Lookup.getAll().distinct(); IDsSorted = Form2[ID in IDs] sort by SortField; input.MultiSelectLookup.select(IDsSorted);
how to send email or sms for all customers ?
Hi, This is like i am thinking ; let me know if it is possible like this or is there other solution for the same. first form lookup field may be - for all customers which has name -- so we can take email , phone then message - we willl put message in
Next Page