Global Lists?
I'm interested to know if I can create one application that contains nothing but picklist data which I could reference from all other applications. For example, a list of countries and states. This data could be used across multiple applications but I only want to maintain the data from ONE application. Picklist Application Forms: countries states tax rates Application "A" Forms: Mailing List (name, address, city, state, zip, country) References states and countries from "Picklist" application Application
Change height of report embedded in page?
I have a page in Zoho Creator that contains a report that is embedded using <div elName='zc-component' viewLinkName='Open_Corrective_Actions' params='zc_Header=true'>Loading View...</div>. When viewing the page, the report is only about 15-20 rows high, and there is just empty space below it (see screenshot below). I was wondering if there was a way to make the embedded report fit the page, or increase the height of the div without publishing the report?
Field value being set to blank
Users are reporting strange behaviour with the AGREEMENT form that contains an ASSET subform. Here are the steps to create the behaviour Go to https://creator.zoho.com/essistmgmt/assets/#View:CONTRACTED_ASSET_View. Note there are 29 records Edit the A059 record at https://creator.zoho.com/essistmgmt/assets/AGREEMENT/record-edit/AGREEMENT_View/896426000014604156/ Change some of the fields and update the form without adding or deleting from the subform Go to https://creator.zoho.com/essistmgmt/assets/#View:CONTRACTED_ASSET_View.
Lookup Field in Creator From CRM -- search doesn't work
Hello all, I have a Creator Form with a lookup field connected to CRM. It is connected to the Deals module. Until today it worked great, but now when someone tries to search for their deal in the creator form, no results appear when that deal definitely
Adjust embedded chart in zml snippet
Hello, on the help page (https://www.zoho.com/creator/newhelp/pages/parameters-for-page-elements.html#chart_param) I noticed that we can embed simple charts in zml snippets. That's the code: <chart type='Column' title='test' xtitle='X-Title' ytitle='Y-Title'
Permissions - form level restriction, edit restrictions
I'd like to restrict access to certain forms to admin users only. Is that possible to do at the form level? Is it possible to create read-only records? i.e. Once the record has been created, it is not possible to edit it. I am working in a sandbox right
Filtering an Analytics report when embedding it into Creator
I have a Creator app where organisations can track their projects for groups of young people. I want to report back to each organisation a nice set of stats about the impact of their projects and the young people's demographics, so I have created a dashboard
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
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
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
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"));
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
Next Page