Dashboard customization
HI, I have been working on a project feedback managment system. In that the manager dashboard should only list his projects, where as in admin dashboard it should list all the projects can we display the dashboard contents based on the logedin user ?
Insert fields into Record Summary from Subform
Hi, I'm trying to insert the rows of data from a subform into a record summary template. Right now it puts all the entries together separated by a comma like below (Burton, Salomon). I'd like to see all the fields for row one grouped together, then all the fields for row 2, etc. Thanks! How it is: I'd like it to look more like this: Jack McBlack - PO Please create SKU(s) for the following product(s). Thanks! Burton Slipper liners 1234
ticketsCountByFieldValues
Hi Zoho Team, Just to check how can I include customfields to the url string. currently I'm using this. url :"https://desk.zoho.com/api/v1/ticketsCountByFieldValues?accountId=xxxxxxxxxxx&departmentId=xxxxxxxxxxxxxx&field=statusType,status" If I add customFields
Custom Page title
Hi how can we set a custom page title? like<title> in html Now it displays my username as the page title for dashboards and all other forms. It should be good if the user visits the dashboard page then the title is Dashboard.
Public form
Hi, I have been trying to develop a project feedback system using zoho creator. The feedback form should be public for that I have created a feedback form and published it so anyone with the link can submit an entry. The problem is im using lookup field
Receiving "API request's body is either missing or incomplete." error
Hi, I am attempting to call the Creator API V2 Delete Records function from a CRM function and receiving the error " {"code":3020,"message":"API request's body is either missing or incomplete."}". Below is a code snippet with some URL variables removed:
Zoho Creator Tab Code
hide College_Details; hide Employee_Details; hide Bank_Details; if(input.Radio == "Personal Information") { index = 1; show Employee_Details; hide College_Details; hide Bank_Details; } else if(input.Radio == "College Details") { index = 2; hide Employee_Details;
Zoho Creator Tab Code
hide College_Details; hide Employee_Details; hide Bank_Details; if(input.Radio == "Personal Information") { index = 1; show Employee_Details; hide College_Details; hide Bank_Details; } else if(input.Radio == "College Details") { index = 2; hide Employee_Details;
Users field - active and inactive filter
Currently there is no option to filter the dropdown in the the 'users' field by active/inactive users. The capacity to filter this field to only include active application users would be a useful addition.
Show a Field in a Subform Based on Selected Item
Hello everyone, I'm trying to dynamically show a field inside a subform based on the selected item, but I’m running into issues. My Setup: I have three forms: "List of Documents" → Stores the master list of documents with: Document Name (Single Line)
Report Options Improvements
Currently there a number of, let's call them quirks, when trying to setup reports for an Apps users. There are often times when hiding the "Add" button on a particular report for all users would be useful. However to achieve this we must embed the report in a page, now we get an extra page every time we need this functionality. If you need to remove the 'SpreadSheet' option but keep the 'Timeline' you would need to add an edit workflow with an "On Load or On User Input" code block. To remove the
How to make a string variable with multiline value?
Hi, I want to declare a string variable which has more than one line of strings. I have tried myString = `Line one of string Line 2 of string And so on....`; But it seems back tick for multiline variables is not supported by deluge "programming language". Is there any way to declare multiline string variables in deluge?
Inquiry About Read-Only Function for Form Fields and Request for Development
Can the fields in the current form be set to a read-only function now? I sincerely need this feature. If it is not available at the moment, could it be prioritized for development?
File Renaming and PDF Export Issues
Using the Zoho Creator app on mobile, I need to rename draft files and export them as PDFs, then forward them to the LINE app. 1) Is it possible to set the file renaming as a variable (from the form's variables)? For example: Customer Name + Date. 2)
[Free Webinar] Learning Table Series - Creator for the Manufacturing Industry
Hello Everyone! We’re excited to invite you to another edition of Learning Table Series, where we showcase how Zoho Creator empowers industries with innovative and automated solutions. Each month highlights a specific sector, and this time our focus is
Attach Subform images from Zoho Creator to CRM Module
Good afternoon eveyone. I am having a difficult time trying to find a way to attach a subform image from a creator app to a CRM module. I have tried so many ways that I don't even know which way was on the right track because none of them worked. If anyone
Displaying multi-line field values in ZML
I'm sure this is obvious, but I can't find the solution... I have a Form which has a multi-line field called 'Description'. I can capture the field values using: // Get idea ideaDetails = Idea[IdeaID == input.ideaID.toLong()]; // Define fields ideaID
How to show dynamic icons on Zoho Creator page
Good day! Suppose I have three KPI panels at the top of a Zoho Creator Page. Each panel compares a current year metric to a prior year. How can I dynamically display an up or down arrow icon next a metric? 1. I tried creating a page variable with the
How i find out day from date i.e. Monday, Sunday etc
I have all 30 days of month ,and as i am holiday approval ,I want to add holidays of my company is on saturday and sunday and government holidays also.How i know from date it is which day..
Fetch each workday date between two dates
Hello! Is it possible to fetch each workday date between two dates, and then insert a record on each of those dates on a calendar report?
Zoho Creator's 2025 Release Projection 1
Hello everyone, This is Prakash, senior product manager at Zoho Creator. Today, I'm absolutely thrilled to pull back the curtain and give you a sneak peek at our first release projection of 2025, with an exciting lineup of features set to roll out in
Dynamic Dropdown on Search Page
I'm trying to create a search form that allows users to search based on fields from the main form. I've tried using deluge to get the values and that didn't work. Now I've used a lookup field but it is populating multiple entries in the dropdown with
Report workflow on multiple records only passes one id...
I have a list of assessment records, and a report workflow that opens a stateless form so the user can choose who to assign one to and when it is due by. It also updates the status, and all works nicely, as long as it's one row at a time. But when I try
Automatic Refresh on Page?
Hi everyone, We use a page as a dashboard which shows data for the laboratory and tasks pending etc. Is there a way to set the page to automatically refresh on a X time? Many thanks TOG
Using HTML for input
If I add a button to an HTML snippet on a page, how can I trigger an action when it is clicked? <button onclick=???>Click Me</button> I've tried calling a script within the HTML, and I've tried calling a Deluge function, but neither seems to do anything.
count unique records
how to count only unique record with "aggregate records" task in script builder? something similar to .distinct but that return total number of distinct not the list. Example: I have multiple entries with the same date in a date field. I want to count days (duplicate days just count ones)
URL shortener service
Does Zoho have an API-supported URL shortener service?
Pagination help
Hello everyone. I have this code below that gets all accounts based on specific criteria. I just discovered that it's not pulling in all of the accounts due to the 200 item limit. I've been trying to follow some pagination examples but can't seem to figure
Parent Form -> Subfrom with Lookup Field - Desync on Parent Form Viewport
I have a Parent Form (Accounts) with a Sub-from (Documents). The Documents form contains a lookup field for Accounts, however when the "Related Account" Lookup Field is updated via the Documents form, the change is not reflected in the Accounts Form's
Hide/Remove Zia search bar in Mobile app
How do i hide the Zia Search button " Search across Zoho apps " in the app?
Produce application url to be common for all the Creator application Stages
I am trying to develop an application using the 3 environments steps like development, stage, production. I am trying to pass in a variable url like which redirects to a Report inside the application URL = "https://creatorapp.zoho.eu/insurancemarket/environment/development/all/#Report:Sign_Up_Form_Report"
Zoho Creator not loading
Hello. I can not access my Creator account. After I login, it wont load to my pages, Has been doing this since Friday. I have checked with my I.T dept and cant see a problem on our side. I have also tried logging in via my private laptop and PC and have
submit/upload form as csv
Hello Everyone, I've created a form in Zoho Creator to capture notes, details and images from a monthly meeting. I can't seem to figure out how to ensure the form is uploaded via CSV and into the Zoho Database. Any guidance would be GREATLY appreciated.
Display Record Image on Custom page in html widgets - Environment issue
Hi, I am trying to display an image from a record on a detailed record page. The page is created with a html widget. I noticed that the default retuned image url has to be processed. Something like : carImage.replaceAll("sharedBy","accountname").replaceAll("appLinkName","appName").replaceAll("fieldName","Fieldname").replaceAll("viewLinkName","reportname");
How to update a custom field in zoho inventory?
I have a custom field in inventory that I'm trying to update through deluge in creator but I keep getting a strange error. Here's my attempt at updating the custom field. The name of my custom field is "cf_substatus" and I noticed that it was contained
Unchecked an option in a checkbox when another option is checked
Hi, in a Creator form, I have around twenty checkbox fields, named for example "cb1", "cb2", "cb3", etc... Each of these fields have two options: Done and N/A. I would like to be able to for each field, if I check "Done", "N/A" is unchecked, and if I
How can I format numbers in an html table?
I am building an html table to display how much people have paid, but the numbers are losing their formatting: application_table = application_table + "<td style='text-align: right;'>" + payment_row.Amount_Local + "</td>"; Amount_Local is a decimal field,
Closing a Stateless Window
Hi! I have a stateless form that I'm displaying with openUrl("https://creator.zohopublic.com/company/application/form-perma/ISN_Stateless?Trade_Order_Id1=" + input.ID,"popup window","height=300, width=500"); and that works great. The form has an 'OK' and a Cancel button. At the end of either event (OK & Cancel) script I put openUrl("http://creator.zoho.com" + zoho.appuri + "#Script:script.close","same window"); but the popup window merely 'refreshes' and the window stays. A cancel will not kill
Attachment Template as PDF from Another Form Zoho Creator
Hi Everyone, have a good day. I have question, below my script for put the attachment into email. But my template PDF from another form ("Form B"). I get errror because template PDF not exist in the form "Alasan Reject". The form name for example "Form
Customer Portal Users Metrics
Hi, Is there any way to know who and when a specific customer portal user accessed? without having to use the metrics page.
Next Page