Add condition to only fetch active items from Zoho Books
Hi, how would you modify the following Deluge code to only fetch Items from Zoho Books that are "active" status: response = zoho.books.getRecords("Items","111222333444"); itemList = response.get("items").toJSONList(); for each item in itemList { input.Items:ui.add(item.getJSON("item_name"));
Creator Storage usage
Is there a way to see the app storage usage. I'm with Express Plan and I have 20 GB. thanks
How to send email to multiple records from List Report?
If I have a list of records in a List Report, how can I bulk select and send an email? Please see the 1 minute video I made showing where I'm stuck. Thanks for your help! Chris VIDEO: https://www.loom.com/share/1c348548b8394a788fdbe39afa40770b
Add custom button to form or detail view
Is there a way to add a custom button to either the form or the detail view from a report? I have a function I'd like to execute when the button is clicked that needs the record ID of the item being viewed. I'm not asking about adding a button to each
External API in widgets
Hi, Can we use external APIs inside widgets in Zoho creator?
Is posible to submit a form through deluge ?
Hi ! Im trying to submit a form through deluge. I need to save/ write the form state and then proceed to open other related forms modify them and comeback. Is this posible ?
Include button to perform custom function in sendmail
Greetings i have a sendmail function where i want to include a custom button in the html of the message, when that button is clicked i want to invoke deluge code to update a record in my app. how would that be possible? something similar to this is zoho
Backups failing
Recently during a large enhancement of a suite of applications I am working on for a client. I have thought it prudent to make backups daily before working on any of the applications. Over the past couple of weeks whilst the backup has been taking place
Widget will not run JS.
Hello, I have installed the nodeJS application and it works great. I created a package with it for a widget. A simple one. When I add the widget to a creator page the JS won't run. I also downloaded the JS SDK but wasn't sure where to put that. Does it
Automatically export a view and send as an attachment
When a user clicks a button, I am setting a value on a record to show that funds have been issued. The user now wants to receive an email with an Excel report attached so that they can import it into Sage. I have created the email with a link to a published
Send email notification containing link to record on record creation/update
Hello, I'd like to send a notification email when a record is created or updated on a Zoho Creator App. For what I see, there's no option to do that: Any hint or workaround? Thank you
Importing subform data to Zoho Creator App
Hello, I'm trying to create my firts App using Zoho Creator and I just saw there's no option to import subform data (Import data to reports (zoho.com)) I was wondering: is there any other way to import subform data? I.e.: via custom function Thank y
Function to get URL of current stateless form
Hi, is posible to get the URL of an active stateless form, from a script called by a custom button in the same form ? I dont think hardcoding URL is a good idea, because if I change the development envoirment URL is going to change
set field form in page through URL parameter
Hi, Im trying to set a field form in a page through URL, "exampleField" is inside a form, and the form is inside "PageName". URL example: creatorapp.zoho.com/userName/environment/development/appname/#Page:PageName?exampleField=foo This doesnt seems to
Create a Business Procedure Manual using Zoho Creator
Hello, I've seen is it possible to use Zoho Creator to create a Business Process Management app (Free BPM Software | Business process management in the cloud - Zoho Creator). Is there any tutorial on how to do that? We need to create an app where we can
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
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
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
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
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
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
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
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
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
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
Next Page