creating Unique Ids
what is the easiest way to create a unique id consisting of 6 numbers that are sequential that appear as the form is getting filled out. the ID needs to attach to each record created
Modify form fields though button
Hi, I’m trying to create a page with a form and a button, when the button is pressed, I need to retrieve the fields from the form and modify them through a deluge script. Is this possible ? I realized I could use stateless form, this allows me to get
Delete Blank Records
Hello, I'm very very new to database and Zoho. I imported a spreedsheet from Excel and when I do, it brings tons of blank records. Now that those bland records are on my report, how can I I do a mass delete to delete all blanks. When responds...please don't get too technical. I'm very new to all this. Donna Z
Problem with new line "\n"
i have been using "\n" for a while. It works fine but just has problem for an hour ago. After i submit the form, new line "\n" in my text box (multi line) does not work anymore For example "Small Pizza" + "\n" + "- Pepperoni" + "\n" + "- Sausage" Here
Week numbering
Does Zoho e.g. getWeekOfYear() calculate week numbers according to ISO-8601? If not then has anyone implemented a function to calculate ISO-860 week numbers?
Insert to From not working
Hello everyone, So I wrote this code below. However, it is not inserting the date into my new form. I have four forms with customer data, and I need to insert specific data from each form into my new form. Thank you in advance; Annette void AuditBillingsheet.createUpdateSheet(string
Deployment Method
We have a client with 2 different Zoho Creator accounts. And we are developing Zoho Creator apps in our own account. We are developing a Zoho Creator app incrementally meaning releasing features when the development is done for some functions incrementally.
Open Questions URL In Creator
I've been using Zoho Maker for about a year and am incredibly happy with the value you offer and the niche expertise you provide. I'm prepared to research online responsibly without spending every last penny on website design and development. However,
Saving pages as an MHT
Greetings we're looking for a way to export pages created in our creator app, we tried exporting them as PDF which is the available option currently but the page gets split into multiple pages and we get unacceptable page breaks that break the content
Custom Application for clients
Hi I am trying to understand how we as developers are paid for the work we do developing an application that is privately published. Here are the things I am trying to clarify: 1. Who owns the application we develop? The developer, the client, or Zoho?
Creator Environments - Failed to Public
I have an app in Creator and now I am trying to edit in the Envirnments settings. I am trying to publish to Development however keep getting "error in publish" Is there a way to find the specific errors and make fixes as at the moment I have no idea
Add Entry and Subform Record from Deluge Scripts
Hi all, I would like to know how do I add a new entry and also subform records from a deluge scripts. I can use the insert into to add a new entry to a form, but how do i insert a collection into the subform of the entry? I am using a deluge script
The Power to Create Cookies
There isn't any way for Zoho programmers to create and monitor a session, except by registering and having a user log on with their own ID. This is not practical for many applications where you do not want to impose upon the user. While Zoho does issue its own cookies we developers don't have any way to read them. The below snippets can be used to create cookies on the client's computer which will allow us to create sessions, know who is returning, set preferences etc. It would not be hard to
Use of browser Cookies to track sessions
Seeing that Zoho stopped Javascript support in 2009, does anyone know how I can set and retrieve browser based cookie values in Creator?
Error Importing number fields from an excel file
Hi I am having trouble importing number fields from an Excel file. In my form I have two Number fields, one for the ID number and the other for the phone number. In the excel file the columns are defined as number columns and they have numbers like 1144035567 for ID´s and 3155467898 for phone number´s for example. When I want to Import the file I get an error alert for this two fields saying that those are invalid numbers for numeric fields. The numbers in the excel file are not decimal numbers
Conditional Workflow
Hi all, I'm trying to create a workflow that if an entered PIN number matches a number on a different form, then all the records with that number are shown. I've got the conditional but sorted, but I cant find a way of getting the action to be to display
Boost Your Productivity and Agility with Zoho's Manufacturing ERP Software
Zoho Creator Zoho Creator is a user-friendly, low-code software platform enabling developers and company owners to create unique corporate apps. The platform considerably decreases coding complexity and offers a simple way to address cross-industry enterprise
Add data to Creator from external webform
I have an external form I created (HTML and Javascript). How do I send the data from that form to Zoho Creator? or even Zoho CRM?
User data: avatar, company name, login...
Hello, How can I have within the creator for the users (customers) to have their company data, address, CIF, etc. ?? Is it possible that the user, when accessing, can enter these data? Thanks and regards
projects api call work on zoho creator but doesn't work when called from other zoho app
Greetings i have the habit of creating and testing custom functions on zoho creator before moving them to the apps where i want to use them in automated workflows. i've been testing the zoho projects api call "get users" to get a list of all projects
Can I fetch and display Image in notes field
I have a form "Logos" which has a field "Image" which is an image field. This form allows the upload of image for each business in our database. I would like to lookup the logo for a business and display the logo in a notes field on a form. Is this possible? And if so, how would I do this? I tried using this code: Logo = Logos[Business == input.Business]; notes_field ="Logo" + Logo.Image; However all that renders is this (broken image link)
How to get logged in user zuid?
Greetings either in zoho creator or in other zoho apps, how can i get the currently logged in user zuid from my deluge script? i tried "zoho.loginuserid" but this returns the email of the user. Thanks
Records added through deluge script are not included within approval process
Greetings i'm working on a creator app where on form submission i need to process the input data and create multiple calculated records based on form input. after that these created records need to go through an approval workflow. the issue is that when
About Certification Exam
I recently written Zoho Creator Ceritification Exam But i failed in first attempt of exam. how to reset my account for second attempt of exam .
Dropdown Field Not Working in IE in embedded forms
Dear Team Need urgent help drop down list is not working in embedded form it was all ok till yesterday from today it stopped working below is the permalink for the form with out login , please help this is very important form used by us everyday https://creator.zoho.com/requestion/copy-of-online-requisition-beta-1/form-perma/Online_Requistion/YmWDJUbzBfxC9YF5344KuhsRHYvUTEUpOtFPX9ARbH0qy67eEuby5GThE1uUWDHepK9E9pN64yU7dYvxGXHDRr8q1Cxs5Ma5wjZk/ Thank you in advance
Deluge Count Function for Subform is it supported
Hi This var1 = count(SubForm_1[ID!=0 ]); Gives the error Form SubForm_1 does not exist in this application Is there a syntax mistake or is it no supported in such a manner
Auto regenerate Pivot Chart
Hi, I'm trying to find a way to have a Pivot Chart automatically regenerate itself, rather than having to do it manually for each pivot chart. I have embedded it within an internal corporate management website page and was hoping to be able to eventually add a couple of charts for other projects to the page. The goal was to track status of a project without having to individually go to different Creator applications to look at the charts. However, the charts seem to only update if I hit the
How do I combine zoho creator records from many different forms?
I will be importing existing data from another system, and I'm trying to use Creator's interface to create a items dispatch system for the warehouse or third party logistics (which I think is a pretty common use case). So we have an item table, an order
change the submitter user when adding a record
greetings generally when adding records from deluge to any zoho app the submitter/added_user is usually assigned to the currently logged in zoho user. i'm now adding expenses to zoho expense and creating reports based on them and the submitter is being
Zoho Expense API receipt not attached error
Greetings Using the expense api i'm trying to create a new expense, according to the api docs there is nothing that has to do with receipts here https://www.zoho.com/expense/api/v1/expenses/#create-an-expense but when i send my post request i get response
Fields don't appear to update on bulk edit
I'm trying to make a bulk edit but only few columns appear in options. Is it a problem or zoho creator has a limitation? Thanks
getting improper statement error when using invokeUrl
greetings i created a custom connection with zoho expense and i wanted to start manipulating records in expense using the connection and the invokeUrl method.. my function looks like this: void createExpense() { data = Map(); data.put("date","2022-12-01");
Sorting of IDs in a lookup field
I am fetching IDs of records into a collection and sorting out the IDs according to the date field related to each ID. For example ID, Date 12345, 18 Nov 12346, 14 Nov 12347, 12 Nov 12348, 15 Nov by sorting according to date, I can get the collection
Changing the favicon on a Zoho creator app
Hi, How can I change the favicon on my Zoho Creator app? At the moment the red Zoho favicon is showing. I searched for Favicon in the help and didn't find anything. Thanks,
Accessing zoho Expense from deluge
Greetings I'm working on a creator app where i need to add records to zoho expense from deluge script, but i see that there is no direct connection between deluge and zoho expense unlike other apps like projects and people and books.. how can i go on
IMAGE-CHOICE PLEASE! for Creator Forms
Hi, I am really hoping there is a way to allow multichoice options in creator forms to be images? the same that is already available in Zoho Forms? Please tell me how... Thanks Cam
Adding an empty dropdown list to form and populate options using creator
Greetings i need to work on a form where an employee would be selected from a dropdown list and then have data assigned to them through other fields in the form (like salary, work time, etc)..the idea i have in mind is to have an empty dropdown list with
Run workflow on data import in Creator 6
How to run a workflow on data import in Creator 6?
button of stateless form
I want to use the buttons in stateless form to control the fields, i am sure the codes are right, but there is no response when click the button.
Dealing with Custom Fields in Deluge
Greetings I'm trying to add expenses from my creator app to zoho books, in zoho books i have some custom fields for the expenses that i'd like to set when creating the entry. but i'm unable to get it to work. i've checked the docs https://www.zoho.com/books/api/v3/expenses/#create-an-expense
Next Page