How to get data from a file that is saved on zoho work drive to then update creator app.
So we have a few machines, and they have a consumables. There usage is tracked in a file, I would like to pull that data from the .ini file and import it into the zoho app so we can keep track of usage, is this possible with flows and how would the data
Creator Simplified #12: Track the no.of button-click downloads
Hey Creators! We're here with yet another episode of Creator Simplified for you! In this post, we'll see a workaround to count the number of button-click downloads made in the report. Usecase In a training app, students can download the course material
Getter error message Number of statement execution limit exceed Line:(216)
Hi, this script is giving me error message "Number of statement execution limit exceed Line:(216)". Please advise htmlpage Pay_Period_Details(PayPeriodID,AgentID,ShowPrint,start_range,end_range) displayname = "Pay Period Details" content <%{ /* Get The current Pay Period Record */ Int_Pay_Period_ID = PayPeriodID.toLong(); Current_Pay_Period_Record = Pay_Period[ID == Int_Pay_Period_ID]; Previous_Pay_Period_ID = thisapp.Application.GetPreviousPayPeriodID(Current_Pay_Period_Record.ID); /* Checking Agent
How to Add Portal Users in Zoho Creator's Development Environment for Testing?
Hello, I’m working on a Creator app with a customer portal and implementing filters based on the logged-in user (customer). To test these filter functions, I'd like to simulate or add customer portal users in the development environment/database. Is there
Report support List data.
Hi Could Report support use list data? I hope I can create a list with deluge and push to a report. It will increase efficiency .I don't need insert data to a form.
Get Creator Form Record ID and Subform ID's
Good Afternoon everyone. I have a Creator form with a on success workflow. I'm trying to get the form record ID and the subform record ID(s) but they keep coming up null. There is data in the subform I use it elsewhere. Can anyone help me pull the ID's.
WhatsApp and Zoho Creator Integration
How we have integrate WhatsApp App with Zoho Creator without using external application ?
Initiate data import using Deluge script
Is it possible to open the screen to begin the importing of new records using Deluge? So for example, my users would click a button on a form that starts a workflow action. This action would then open the screen to "Import Data for Current User Projects".
Lookup field - Can I avoid using advanced search?
I have a lookup field in my app that has surpassed 500,000 records, now basic search is disabled and I'm forced to use advanced search. That adds multiple steps to what used to be very simple. Before: Select field > Type last digits of product code and
Zoho CRM - Zoho Creator - NFC Tag
Hi, I'm looking for support for Zoho Creator and NFC. I have read the existing knowledge base, however not all is clear. We have Zoho CRM with custom module 'Equipment' where we have around 1000 records. Our idea is to attach physical NFC tags to the
Execution failure when fetching a Name field from another app
In creator I have one app [Employee Directory] with a form [Employees]. One of the fields is a name field called [Name]. Here is a sample that works, if executed from the Employees app: test_Employee = Employees[Name.first_name == "Alex"]; info test_Employee.Name;
Countries and Towns - Lookup Multi Select
Hi, Sorry I'm new with Zoho Creator and Deluge. ---------------------------- Form A = Countries Form B = Countries and Towns (with relation) in a Form C, i have a lookup field "Country" and after user input, i would like to auto populate the lookup multi
How to Remove CRM Links from Referral Fields in Zoho Creator Report?
Hello, I’m building a customer portal for a Creator app integrated with Zoho CRM. In the portal, customers can select their referrer from a list of Zoho CRM contacts linked to the deals they own. They can then view a report that lists all their deals,
Calculate hours and minutes between two time field
Hi I have following fields - 1. Start Time - Time Field 2. End Time - Time Field 3. Total Hours Worked - Single Line Field I want to calculate End Time LESS Start Time and get output in Total Hours Worked. Please help me. Urgent.
How to pass a collection to a function?
Can't seem to figure out how to pass a collection of records to a function. Here's what I have so far. What am I missing? // This successfully retrieves all IDs and stores them into what I think is a collection variable defaultRecords = Data_Types[is_default
Custom Alert Messages
Does anyone have any experience creating custom alert messages in Creator? I'm able to create a zml page with params for alert Title and Message, and I'm able to trigger it from a report button, but I can't seem to trigger it as part of an On Validate
Print template in list view
Hi, is there any special way to use a template when printing in list view? I have followed the online examples, but can only get it to work in summary view so far, which is no good at all.
How to populate a dropdown in zoho creator with data from zoho crm contacts
I tried this code, but I can see al my contacts in debug that is a multiline debug field I created to check and debug but the dropdown (named crm) is empty. Where is my error? many thanks Paolo clear crm; // Recupera fino a 200 contatti da Zoho CRM response
"Invalid entries found. Please correct and submit again." error needs to be clearer
Hi Zoho, We have had many users email us in frustration because they get the "Invalid entries found. Please correct and submit again." error and get angry because all they see is an unclear error and they think they have to start over. They are not aware that there is a red error message on the field indicating the problem after they click OK. Many are abandoning the form. Please add information to this error such as: Invalid entries found. Please correct and submit again. Click OK to go back
Prevent carriage returns / line breaks in multi line fields
I'm trying to connect Zoho Sheets with Zoho Creator however because some people are using carriage returns in multi-line fields the rows are not being created correctly : The values in A4 and A6 are part of a multi line field that looks to have been split
Zoho Creator HTML Snippet - Can't get list to iterate
Hi! I'm trying to create an HTML Snippet on a page in Zoho Creator and would like to create an HTML table pulled from a list of time entries that I have in a form. I have successfully pulled the collection of time entries, but the code that I have built
How to send binary data in invokeurl task?
Hello, I am using Adobe's Protect PDF API. Source: https://developer.adobe.com/document-services/docs/overview/pdf-services-api/ Everything works fine in Postman. But for some reason after encrypting the file, it is empty after password protecting the
Limit excceding issue in zoho creator
I am transferring data from Zoho Books to Zoho Creator using a Deluge script. However, I am frequently encountering a "limit exceeding error," which seems to be related to the Deluge statements limit. I reached out to Zoho Support, and they informed me
Question about on User input workflows
In my app I have a field for device IMEI which should trigger a check on an external API through an invokeUrl. But it seems the workflow will only run after the user has moved the focus away from the field by clicking somewhere else. However, if the user
Filter report using dynamic filter using function not working
Hi - I am trying to dynamically filter a report as follows: when I save the filter it looks like this: However when I run the report it is not returning results as I expect. I have tested the function. If I copy and paste the output of the function and
Simplify Zoho API integration with Deluge’s invokeAPI task
Hello all! Happy New Year! As we kick off 2025, we’re excited to share some of the latest updates to enhance your Deluge experience. While Deluge already offered robust API integration capabilities, we’ve taken it to the next level with the introduction
Issue with Navigating Components in App Localization
While using the app localization feature in Zoho Creator to translate my apps into a new language, I encountered an issue that made it difficult to navigate between different components (forms and reports) and add translations. The feature would only
How to add coloring on List Reports
Hi guys, I would like to add colors to List reports. Is there an option to apply table colors other than using the custom layout? Thank You!
Lookup field, odd issue
So I tried creating and app that has the names of engineers so I can use that for a lookup in the other apps that are being created . I add the look up in a new app, launch the app and when I try to fill out the form its just blank in the drop down menu
Query About Updating Records in Batches via API
We are working on integrating the Creator application with an external app, and we need to update thousands of records daily. I understand that the "Update Records" API is available; however, it appears to be designed for updating multiple records with
PDF API FROM ZOHO CREATOR DELUGE SCRIPT
Hi I am in need of using a PDF Api to compress and Merge PDF files from zoho creator. Any support on this would be really helpfull any sample code for any PDF API would be extremely heplfull
Date Range Field
Hi Guys Does anyone know how I can create a date range field on a form? Cheers Chris
Mandatory verification of custom domains in portal
Hello all, Happy New Year! Wishing you a successful and fruitful year ahead. We are committed to ensuring a safe and secure experience for all users of Zoho Creator users. As part of this commitment, we regularly introduce updates to ensure our platform
Calendar Overflow in Open URL popup
Hi everyone, When Opening a form which has a date field in openurl popup, this happens. Is there any way I can change the calendar width and height or is there any other possible way this can be changed? Thanks.
Deluge Script - "Mismatch of data type expression" Error When Retrieving Account ID
Hi everyone, I'm working on a Deluge Script in Zoho Creator to create Accounts and Locations. I'm running into a "Mismatch of data type expression" error when trying to retrieve the ID of a newly created Account. Here's the relevant part of my code: accountResponse
Update field in “Validations on form submission”
Hello, I have a hidden field in my form. I created a workflow that is executed when a record is created and triggered an event in the “Validations on form submission”. At this point I retrieve an external ID and need to add this value to the hidden field
Automatically add user on customer portal
Hi Guys, I have a doubt about how to automatically add user details to the customer portal. Once the user details are submitted through the user form, those details should be automatically updated in the customer portal. how to do that any one have idea
Function Only Working Manually
Good evening everyone. I have a function that creates a PDF from a Creator form. When I execute it manually it works perfectly. But when I execute it from within a On success workflow it is not working. I'll post my code below. Any ideas? //Function void
Assistance with Code to send email on subform data
I am trying to trigger an action off the successful submission of a form that emails the details of the subform to a distinct email. This subform is setup as another form in the app and I can get the below code to work: for each subrow in input.New_Payment_Subform
Is there a list of Zoho Icons?
Is there a list of Zoho Icons you can reference: i.e. business-gold is <image marginRight='7px' color='#2A70E7' bgColor='#FFFFFF' width='52px' height='52px' type='icon' value='business-gold' size='24px' cornerRadius='26px' iconType='solid' /> Thanks!
Next Page