Bulk Edit Issue
Now the record Bulk Edit execute the Script On Edit --> On Success, But it was just update the selected field in Bulk Edit. Sample: If I want to update the Status field only to "Canceled" but the Status will be updated to "Completed". based on the script. Please advice about new Bulk Edit behavior. Omar
How to bulk update lookup fields
"I have a primary key named Product SKU in one form called Master SKU (which contains details like price, color, size, etc.). I also have another form called FBA, which has the same primary key, Product SKU, and contains stock quantity information for
Integrating Zoho Creator with Google Drive
I am interested in using Google Drive as a convenient repository to push files from file upload fields in my creator app. I am wondering if people have come up with best practices for this or even how viable it is. https://developers.google.com/drive/api/guides/manage-uploads#simple
How to open a URL for current selected record from a button in a report.
Hi, Can you tell me how to open a pop up window for the currently selected record when pressing a button from a row in a report? I've seen very old posts but none of the solutions seem to work for me. Also how can i access details from another report
Why am i finding it hard to just allow my widget send data that are inserted to the Report section i need Help from experts am new
Am really finding it hard to send the data from my widget to the Report section can anyone Guide me Through?
Zoho creator app
I have created an asset verification application and it has been working fine the past few years on version 5. Now when I punch data or scan barcode then click send the system loads and try pulling the data information and brings it back but the submission
App Issue
I have created an asset verification application and it has been working fine the past few years on version 5. Now when I punch data or scan barcode then click send the system loads and try pulling the data information and brings it back but the submission
Line chart customization
Hi, is there any way to draw multiple lines on a single line chart. Now on te x-axis im displaying dates and on the y-axis dispalying total records count. I want to display multiple lines on the same chart. The sample image is attached
How to set default filter to CRM integration field
I have a products subform in my order form and I'm using the CRM integration field to connect the Products module from my CRM to this subform. I want to filter the data that is fetched to the field from the CRM based on a status field in the Products
Make function for repeating code
Hi, It's me again with my questions... 😅 In my Creator app, there's code that repeats itself in several places. And repeating code necessarily means optimization. So I'm trying to create a custom function to centralize my code in a single place and call
How to do the equivalent of object.Parent.Grandparent.Field in Creator?
I have a form with a parent form and I frequently want to access the parent form data from the UI. One concrete example is an Inventory report. The Inventory has a Product and the product has a classification. I would like to display inventory.Product.Classification
how to get the status of customer in the customer portal using deluge script
From the knowledge I knew, thisapp.portal.profileForUser(); This script able to get the permission of the customer. But, how to get the status of customer (the status I referred is Approved Customer, Pending Customer and Unconfirmed Customer) using the
[Resolved] Bug Subform delete row ?
Hi, I noticed that there was a delay when deleting a row from a subform. I have a script that updates price fields, but when I delete a row, the first row isn't updated, but it is updated on the second row deleted. Here's a video, as well as my script.
Scheduled Report Query
I have this scheduled workflow in Zoho Creator that emails a report named Stocks_Details which uses the Add_Stock form. In the report, I also added a field called Threshold from the Add_Product form and it's connected through the Product_Code field. Now
OCR for PDF
Is there a way to OCR a PDF?
New to Zoho – Seeking Advice on Digitizing Course Evaluations
My company and I are new to Zoho (less than two weeks in) and are looking for guidance on setting up a digital evaluation process for our in-person training courses. Not sure if this is a Creator solution or can keep within Zoho Forms and other components
Make list from Workdrive Folder
Hi, Today, my challenge is to simplify and optimize my drop-down list where I retrieve the list of files present in a WorkDrive folder. I had to create a custom function to replace and display special characters. Then, I need the file ID to open it in
Need help in search with formula culums in reports
Hello, I do not know where to start with this one : I have a customer report with all that was bought and paid by my customers. It can be many records for one specific customer. Ex. Customer A has 1 record for a purchase of 1000 $, and 2 records of payments
[Resolved] Add rows in subform with Excel / Sheet datas
Hi! I'm trying to build an application where I can choose an Excel / Sheet file from a Workdrive folder, and for each data in the file, I create a row of a subform. But I can't do it, here is the code I have: inputString = input.choose_xls_file; separatorIndex
Create a CSV string from report and paste it on another form
After a search in a report, I want all email adresses of the selected records to be in a CSV string and pasted in another form using OpenUrl. The only bit I am missing is creating that CSV string. It might even already be made by a system function since
Is there a way to fetch emails from our support email and create records in Zoho Create with that?
Hello, I am looking for a way to be able to fetch new emails to send to out suppport email and create a ticket in our zoho creator App with? I thought of using the nodejs to create a function but we couldn't add the nodemailer npm packge. Regards,
[Free Webinar] Advanced UI/UX Customizations in Zoho Creator - Creator Tech Connect
Hello Everyone! We welcome you all to the upcoming free webinar on the Creator Tech Connect Series. The Creator Tech Connect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into
[Training] Zoho Deluge Online Training Workshop
Hello Everyone, We are much elated to invite you all to our upcoming Zoho Deluge online training workshop. Master deluge and automate Zoho applications The Zoho Deluge Online Training is an extensive 2-day workshop designed specifically for developers,
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 ?
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:
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)
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?
[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?
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
Next Page