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
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
"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
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.
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
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
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
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
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
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
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
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.
Fetch zoho projects via creator widget
Hello, I'm creating a widget for Zoho Creator that serves the client's need UI. The thing is, the requirement is to display all projects and their children e.g. task lists from Zoho projects in this widget. Locally I can make server-side API calls (that
Generate QR code to edit a form entry.
I would like to QR code scan to edit a form entry. I would like to take the URL of a submitted form entry and create a QR code with the URL. Once we have the QR code we would like to print a sticker with the information and QR code. We would then like
Criteria for Field Rules Not Working if Criteria is Based on a Disabled or Hidden Field
I have an issue where I have "Field A" that essentially serves as a reference field containing a unique ID. So that field, by default, is disabled. I am trying to create another field rule to hide or show "Field B" based on "Field A" value, but the criteria
How to update decision box field based on two criteria
Hi, I am trying to update a decision box field which will show an assessment record as "overdue" if it has not been marked. I want this to be based on if the due date is before the current date and the marked box is false. I am trying to use this code
Zoho creator form confirm success show message for multi language
https://help.zoho.com/portal/en/kb/creator/developer-guide/forms/manage-forms/articles/understand-showing-success-message#Understand_showing_a_message_on_form_submission How can I setup different language message ?
change font colour of certain items in lookup list.
Is it possible to change the colour of the font of certain items in a lookup list? I have form that allocates tickets. Once a school has recieved tickets, a field called 'Received tickets' in another form(Add/Edit schools) has its value changed to yes.
Getting an error on saving code that there is an error connecting to the service
While working on some bug fixes this morning we are running into an the attached error message. "Error occurred while saving the script. Could not establish a connection to the service." This is while saving the script for a Page
Creating URL in deluge/HTML
Having difficulty adding target=“_BLANK” to a URL I’m creating. I have dispLnk = "<a href='" + i.URL + "'>" + i.Title_Name + "</a>" + " - " + i.Description; where i.URL is a companies site, i.Title_Name is the company name and i.Description is their tag
Passing data to a form invoked by clicking the "create new" button in a lookup field.
Here is the scenario... I have a form called "order". In this form I have a lookup field called "ticket" which creates a relationship with a ticket form. In this lookup field I have turned on the ability to add new entries. What I'd like to have happen is that when a user is creating a new order (using the order form) if they click "add new" to create a new related ticket, I'd like to populate some of the fields in the ticket form from data the user has entered in the order form. Is this possible?
Passing parameters to "add new add entries" form
Hello, It will be great to have possibility to have property for each field in form (checkbox) "pass this to add new entries forms". For example: Form "Clients_Requests" Lookup_field: "Client_ID". Checked "Pass this to add new entries" Lookup_field: "Contact_Person" with checked "Show a link to add new entries in Contact_Persons" property. When you click "Add new" for Contact_Person, new form is loaded and Client_ID is setted to "Client_ID" from "Clients_Requests" parent form "Contact_Persons"
Image field pan, zoom and crop feature
It would be nice to let users arrange the images they input in image fields by allowing them to pan, zoom the image. Nowadays this is a standard input method used in most applications, so I think it will be very useful.
Check for Duplicate Date Range
I am trying to update my reservation application to check for units already booked. For a specific property, the unit is booked from a start date to an end date. What I am trying to do is to add code to check if some one tries to add another record where the from and to dates overlap. For example, Unit #1 (Unit) is reserved from (Check_In field) July 18, 2013 to July 25, 2013 (Check_Out field). If a user tries to book this same unit from July 20 to July 30, I want them to get an error message.
Update Subform items based on main form status
I am working on a deluge script to update the status of a subform ( "Samples"). The individual items have a "Status" that should be updated when the main form "Status" is updated. I have set up the workflow as a conditional workflow that executes only
Next Page