Item Quantity
So, I have a form to take orders. I would like a dropdown/multi select to select the items the customer is ordering. I need a way to also specify the quantity for each item they are ordering. What is the easiest way to do this? I have about 85 items to
Auto Number Field
I would like to have an auto number field in my form that automatically resets back to 1 when it reaches 31. Or, if I can't reset an auto number field, is there any way to do this with a number field and a deluge script?
How to mass update field in one form with information from another form in Zoho Creator
Hi, We have a database in our Zoho Creator app with thousands of records. We have a 'Waiting List' form for children who register for our programmes and once they are enrolled (there is a button that 'enrols' them) they are pushed through to 'Students'
Zoho Creator Widget readFile API is Responding with the Outdated File (cached file)
What is the issue: - The download API is responding with an outdated version of the file (cached file). How to replicate this issue: In a form with a file input, upload a CSV file. Download the file using readFile method. Replace the file of the same
Ability to define Custom Filter as a parameter in the URL
I would like to be able to construct URL in such a way so it applies predefined Custom Filter, which should be supplied as a URL parameter. Hypothetically it should look something like that: baseUrl?CustomFilter=my custom filter At the moment this is
Is there a Deluge way to DUPLICATE or COPY a record?
I have a need to duplicate a record from inside a Deluge script, and then modify one or two fields in the duplicated record. Is there a facilitated way to duplicate or copy a record in Deluge without having to manually do an Insert Record and set each field value, which is extremely tedious on long forms? Thank you. Datazen1 datazen1@gmail.com Santa Fe, New Mexico US
Endless loop after open a report on successful form submission
Hi there, I usually add records by clicking the "+" button from a report view. On successful form submission, I can open a report at my preference (example "openUrl("#View:Sales_Closed","same window")"). It works well. However, when I add a record directly
List function not working as expected, no idea why not
I'm trying to feed in a list to a function, perform another function on each item, store the results in another list, and then return that second list. However, all I get is the results from ONE item in the list I'm inputting, not the whole list of results. Can someone help? Here's the basic function idea: list myFunction (list firstList) { secondList = List(); for each topic in input.firstList { x = thisapp.anotherFunction(topic); secondList.addall(x); } return secondList; }
Multiple event dates on Calendar report.
So, I have a form that has 9 different date fields. When I go to create a calendar report, it only allows me to select a start, and an end date. Is there a way that I can just have it show the job name on each of the 9 dates specified in the form?
"Code sign failed" when trying to download Zoho Creator application as Android Mobile App
Hi All, I'm trying to download my Zoho Creator 5 Application as an Android Mobile App. I fill the form with keystore credentials, package name, Firebase config, FCM server key. After clicking "Code Sign" button the process of generating the mobile app seems to be started. After some time when I refresh the page I get an error "Code Sign Failed", "Error occured while connecting to the server. Please try again after some time." I have already tried couple times with same result. What could be the reason?
Marking records that haven't been update on a specific date
HI, I'm building a Creator app, with 2 forms "Work Orders" and "Helper". Every day, an excel sheet is uploaded / imported to the Helper form, where each row is added as new record. One column of the excel sheet is a unique number "WO number" and is saved
fishing warnings from gmail on zoho creator hosted apps
Hi, we are getting fishing warnings from gmail on the zoho creator domain. Other zoho services such as marketing automation are aware of this and offer workarounds. When will creator allow us to use a custom domain so we are not impacted by free (and
Any way to stop my lists / maps from being minified?
I did look around and didn't see any options for it and it happens even with syntax assist off but basically I want creator to stop automatically minifying my maps and such. Or is there at least some option to make it revert to the human readable when
Lookup between two forms
Hello group, I season with FileMaker but green with creator. Hoping someone can guide me on a database i am trying to create. i have two forms, one "(item list) that contain all the items in inventory and the other form contains the quantity on hand for
Multiple user updating inventory qty with deluge
Hi all, i have a scenario below I have a inventory product A with qty 10 and there are three users submit their order at the same time. user A ordered 10 user B ordered 10 user C ordered 10 i have script on validate to check if the qty goes less than
get last X characters from string?
hi how can i from string take last 6 characters? example: string "kjfhgklajhfgkjlahfklghalkfhg" need take "alkfhg" thanx
Fetching Purchase Order to Zoho Creator
Hi yalls. Pretty confused with the API documentation for Creator and Inventory integration. I am trying to retrieve a specific Purchase Order from my inventory account to Creator, but all I can do it retrieve all Purchase Orders (see img below) What should
Image not getting uploaded
Hi All, I have created one form for storing the images, with field names, 'ImgData' - Name of pic and 'Image' - Image loaded. Second form has a deluge script to fetch the image on the click of a radio button and the script is as below. It loads the image
How to Manage Number of statement execution limit exceed condition
Hello Team, we have to execute more calculation again and again at that time the error will shows like execution limit exceed how to manage this issues.
Checking for duplicate entries
I am using the below script, which I would think would work as intended, however there is something going on with the Name field. When I strip down the code to only check for Shift Start and Event, then it works fine. As soon as I add the Name field,
Zoho as an ERP, CRM, and more for a Manufacturing company?
We are looking at solutions for ERP versus an off the shelf ERP system. Our hope is to use much of the full suite of Zoho apps along with some custom build-out for our manufacturing company. I was wondering if there are users or developers on here with
Selling Zoho Creator's apps as a service
I've been thinking and working at several apps that i would like to sell as a service. So I've been studying the developper area to see if i can make a profitable plan. But, at the developer console, when i try to create a pricing plan, i see that the base price "will be decided during Review"... This doesn't allow me to make a business plan because i cant calculate the costs of using Zoho's platform. How do you suggest i should do my business plan?
Logs more useful
Hi, I'm a developer for a company that uses Zoho Creator for its internal management software. The application logs are too complex to use because they contain general references to errors or information, making it difficult for me to pinpoint the exact
How to add Zoho invoice features to my Integrate Zoho Creator
HI I hope to get some advice and guidance. I created several forms to complete some order functions as well as order entry and management, but I still want synchronization or collaboration with invoice functions. I think there is no need to create a new
Zoho Creator Upcoming Updates — February 2023
Hello all! A very happy new year to all of you! We're back with the very first monthly update of the year! Your support has made Creator's journey in 2022 both momentous and remarkable, and we'll be striving hard to make sure 2023 is even more incredible.
Choosing Between Zoho Creator Student Account and Regular Business Account for Website Development
Hello, Could you please help me understand the difference between a student account at Zoho Creator and a regular account with a business email? I am currently a student that working on my graduate project, developing a website for a medical company.
Lookup field in deluge
Hello, I'm trying to 'play' with the lookup field type and its 'fetch mode' in Deluge. So, I have a lookup field, 'user', in a form. When I use it in a Deluge script within a Workflow, I can access all properties of my 'referenced' field. For example,
Zoho creator and Zoho People Integration
Hi, we use Zoho creator extensively to track issues, incidents, etc. We currently have a table within creator that holds our crew, I'd like to drive this from zoho people, so that I can use the HR catagories, and organazational structure to drive aspects of our forms, for example, some fields would display for certain levels of managment.
Borders on ZML and Html Snippets in Zoho Creator Pages
Hi there I understand that is not possible to remove grey borders from html snippets, zml snippets and iframes on a Creator page. Could the ability do set the colour of these elements be added, as the default grey border gives quite an ugly output to
Help with Creating a Task and assigning a Lead.
Thank you in advance for the help. I am fairly new to Creator and have hit a road block. I have been able to create a form, and submit appropriate Account & Contact info using: taskinfo = { "Owner":Task_Owner, "Subject":input.lnSubject, "Description":input.mtlnTaskDescription,
Record summary link for Customer Portal
Dears, I'd like to ask what is the URL for the record summary view used for the Customer Portal? I have a blueprint and there is a stage that needs the customer to confirm via the customer portal. There would be an email sent to him/her with the link
Create Ticket in Desk on Creator Form submission.
So I read the post below and they discuss all sorts of integration except how to create a ticket: https://help.zoho.com/portal/en-gb/community/topic/integreat-04-integrating-zoho-creator-with-zoho-desk-part-1 My app sends an email to the Ticket channel
Vehicle Tracking
we have GPS devices that installed on our vehicles, and we would like to know if it's possible to get vehicle live location data from the GPS device To Zoho Creator App. Thank You
help with code
Hello, could anyone help me with the code, I would like when I enter the payment date it fills in automatically, monthly, on the correct date of the following months eg: 15/03, 15/04, 15/05 and 15/06. it's possible
Zoho Creator 5 API documentation
I'm looking for documentation on building API connections w/ third party sites/apps in Creator 5 - I only see documentation for Creator 6 in the Knowledgebase. I'm probably getting in over my head really - I have no experience w/ API or development other
Initial Loading Delay in Zoho Creator App
Our Zoho Creator application experiences a delay in displaying data and opening forms upon the initial load, impacting user experience. Could you please provide guidance or best practices to address this issue? Your help is greatly appreciated.
Is it possible to download record template without opining it in a new tap?
Is there a way to download multiply record templates without oppinging lot of tab. I'm using this code: openUrl(url + linkName + "/" + input.ID + "/" + fileName,"new window","successive=true"); An once I click to download the record template you can see
Augmenting subform capabilities
Greetings, everyone! Finally, the day has come for us to announce some of the most anticipated, requested, and exciting updates to subforms in Zoho Creator. As you're aware, subforms are an integral part of Creator forms, as they help in establishing
Suggestion: Setting field focus programmatically.
I propose a new feature that would allow you to programmatically set focus to a specified field. Example: setFocus Name; That is all. Carry on.
WhatsApp and Zoho Creator Integration
How we have integrate WhatsApp App with Zoho Creator without using external application ?
Next Page