Send mail (on success) if new row added (subform)
Hi guys, Can someone help me out with the script for: On created or edited > on success Send mail if new row in subform added. I don't know if I'm just having a complete brain block today!! Thanks
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.
Upcoming Updates - August 2022
Hi all, Greetings from the Zoho Creator team! Today we've got news for you on some exciting updates. And rest assured— there’s more to come! In this post, we'll be going over the upcoming features and improvements for this month as mentioned below. A
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?
Sendmail function - enter a delay in e-mail sending - is it possible?
I have a custom action that when finishes it's job send a e-mail message to an address. My wish is that this custom action to send a second mail a half minute later, with another content. Thank anyone who can give me an advice in solving this.
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
Next Page