Can I call a custom function in a formula?
I have created a custom formula to calculate the current balance of an account and I would like to use that in a formula so that I can display it to the user when they are filling out a form. When I try to reference it like I would in a workflow script
Zoho Creator App, Go Back option
Hi, I am working on a creator app with multiple forms, reports and pages. On the main page, users can direct to the sub-page where they can see previous data and then redirect to fill out a form from that page. I simply created a page and form and then
Help passing form data to function
Hi I'm new to functions and am struggling to understand how to pass arguments relating to forms/subforms. I have written the below function. This executes within the form Projects, which contains the subform Schedule, and each record in Schedule contains
For Each Returning Null
Hello, I am new to Deluge and am running into an issue with a For Each of a Map variable. It is probably a simple fix, but I am perplexed that I receive two different results depending on whether the code is run in Zoho Creator or the Tryout section of
Popup window adding new entry on Lookup Field
Is there a way to change the height and witdh of the popup window that opens whenever the "Add New" button is clicked on a Lookup field? The form that opens has a subform with around 10+ fields and the popup window that opens is really small. It will be great if we can edit this. Thanks.
Zoho Creator LookUp field Clickable
Hi I have 2 forms in my app (Zoho Creator). One of this form have look up for another one. And my problem is how make this field like link, when you click it it will open in new Tab my another form with this record. I search any info about, i found how
Zoho Creator Deluge - dynamically change fields depending on user input of field1 or field2
Hi everyone and happy holidays! Hope that someone will help me figure out a solution to my problem… In my form there are currency, formulas and lookup fields. I’m well aware, that formulas fields if marked visible on form, cannot be hidden anywhere (like
String functions in report filter
It works fine to use an int function if the filter criteria is based on an integer field, like this example where ID is integer: When trying the same with a string field, this happens: The problem seems to be the added "" and the function becomes a
Filter a Customer-Portal report
I have a customer portal with a report, where the report is based on a form containing records referencing the customers. I want to filter the report so each customer will only see the records relevant to him (the records with the same email as the logged
Recover Deleted Form?
i have Accidentally my Form. How can i recover it....
Hoping to pull-down menu, plus sub-folder in the folder where you can add sub-menu
Hi Hoping ZC on pull-down menu, plus sub-folder in the folder where you can add sub-menu.. like this: Thanks Stanley Guo 2011-11-10
Zoho Creator 6: How to publish my app?
I'm helping a friend make a simple application in his Creator account. He uses Creator 6 but I've always used older versions. When I make edits to a form they are not updating live...Can someone watch the video and let me know how this works? Can I switch
Access existing record URL with embbebed link or perma link
Hi, I'm trying to access an existing record through URL, its possible to use the report or the form with an embbebed or perma link. In both cases we get this report is not accesible. In order to try to get the record we are using: (Embbebed or permalink)?recLinkID=<ID>&nameLinkView=<report.name>
Formulas - referring to results of another formula
I am attempting to create a formula. I'd like to do it in multiple steps (e.g. result 1, result 2, result3 = result1 - result2). According to https://help.zoho.com/portal/en/kb/creator/developer-guide/forms/add-and-manage-fields/articles/fields-formula-understand-expression#Building_blocks_of_expressions
error at null
Hi, *New to Zoho creator. Im trying to copy input from one field to another, and I'm getting "Error at NULL." ybeRecords = Yellow_Bird_Employee[ID in input.Salesperson_s]; ybeStringLists = ybeRecords.Email.getall(); if(input.ybeStringLists.contains("Mike
Global search
Hi! I think it would be great to have a global search that would give you results from all records of a database, no only for a single field of a single form as we have now. Thanks!
Where can I find tutorials on how to create custom snipets in Zoho Creator for HTML or ZML? Or Custom Dashboards?
Where can I find tutorials on how to create custom snipets in Zoho Creator for HTML or ZML? I've create a custom application and how I'm running in to issues of having the content displayed the way I want through the Dashboard. The issue I'm running into is that there are nearly no tutorials or guides on how to properly use the markup language or how to combine Zoho Creator's variables with HTML. Are there any tutorials, guides or other services that can assist with this? SC
Update Radio Button using workflow based on lookup field
I have a field that I use to determine the status of a customer order. The three selections are: "HEDGE" (If I'm putting an order into my system based on historic order patterns but not an actual order from the customer (i.e. a blank in the [Customer
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"));
Create local variable that persist until form is submited
Hi, is possible to create a variable that persist until the form is submited ? I know is possible to create helper variables in the form, but sometimes this lead to having a lot of useless variables that persist with the form. So Im looking for a way
Impossible to connect Zoho Creator to a SalesForce sandbox enviroment, unless...
Hi folks! We have too many clients who are asking to us for integrations with their actual SalesForce data. The problem is Zoho Creator is only able to connect with SalesForce LIVE enviroments. And our clients can't give us access to the live enviroment. This is something we really need.
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 ?
How can I remove double quote from a string in a formula field ?
Thank You.
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
I don't understand why I get this error?
I don't understand why I get this error? In my mind both fields are TEXT.
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
Export from Creator to Word Doc
Is it possible to export to a word doc from Zoho Creator?
Zoho Docs Integration with Zoho Creator
Hello All Happy New Year! I have purchased Zoho Docs and Zoho Creator. I have made an application in Zoho Creator. I want to integrate Zoho Creator fields in Zoho Docs/Writer. Any idea? Thanks in advance! Best, Farzana
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
How to get current day of the week?
I want to have a field that automatic show the current day of the week. I already have working a field to show the currente date; i used "Data=zoho.currentdate", but don´t figure how to use the day of the week (? .getDayOfWeek() ? ). Where I put it? What is the right code? For the working field I choosed: Form actions > On Add > On Load Field actions > On User InpuAnd for the day of the week? Tks
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
Next Page