Needing help with coding workflow
I'm not great at coding and haven't been able to get a lot of help. I'm struggling to get this coding right and nobody has been able to solve it yet. I will try to summarize and explain as best as I can. We have a parts form with all of our parts that
How to find out Leap year using Deluge Script
We need to find out the given year is Leap year or not in some calculations. any one Suggest ways to find leap year via script or any functions in the Deluge Platform. Thanks & Regards Thisai Moorthy.
Basic API Help
I've been learning Creator/Deluge for a few years. I don't have any other development experience, so I might just be in over my head right now, but...I think I've made a very basic API call from Creator to the music database Discogs.com. I can select
"Multilevel" lookup
Hi, I'm dealing with the following scenario: -I have a form to manage customer registry, containing fields like name, surname, telephone, email, etc. -Another form is used to manage contracts. Here, I input contract data and reference the customer using
Zoho Creator - [Free Webinar] Creator TechConnect Series - Customizing mobile applications in Zoho Creator
Hello Everyone! We welcome you all to the upcoming free webinar on the Creator Tech Connect Series. The Creator Tech Connect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into
[Free Webinar] Learning Table Series - Creator for the Logistics Industry
Hello Everyone! We welcome you all to the upcoming free webinar - Learning Table Series. The Learning Table Series is a free monthly webinar that runs for around 45 minutes. It's offered to our Community users and aims to provide a dynamic learning experience
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
Next Page