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
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!
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
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
Date Range Field
Hi Guys Does anyone know how I can create a date range field on a form? Cheers Chris
zappsusercontent.com refused to connect.
I have added a widget to bigin and when i try to access the widget it indicates "a0bfe442-8e0d-4646-a350-5b1b74d6ea3b.zappsusercontent.com refused to connect."
Getting Data into zoho calendar from a creator app
So how do you get a date that's created in an app, for example when a site visit is due, into the zoho calendar for the field engineers.
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
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
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
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
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
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
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
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;
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!
InteGreat 06: Integrate your Zoho Creator app with Whatsapp using Twilio
Hi folks, We're back with a new post in our InteGreat series, and this time we're going to walk you through how to integrate your Zoho Creator application with Whatsapp using Twilio. Before we dive into this integration, let's quickly cover some basics.
Showing the uploaded Image in the notification email.
Hi, I wonder if any one ever faced the same challenge I'm facing. I've set up an email notification to deliver the content of a form every time a user successfully submits one. I selected the option to send the submitted content in the body of the email,
Email through external SMTP
Hello, From within Zoho Creator, is it possible to bypass the mail server of ZOHO and instead send mails through an external SMTP server? If so, how can this be achieved? Regards, Shobana.
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
Zoho still running very slow
I have a lead log for my company and creator seems to be running extremely slow still.
Can't download record template as PDF on mobile
Hi, I used this to download a record template as pdf, it works on desktop but not on mobile: openUrl("https://app.zohocreator.com/" + zoho.loginuser + "/" + zoho.appname + "/record-pdf/Report_Name/" + input.ID,"same window"); Getting a message: "Error
How to link to/displaya png stored in workdrive in a Creator HTML snippet?
How to link to/display png stored in workdrive in a Creator HTML snippet? I've tried it as a plain external link and as an iframe. The iframe works but is kinda slow...and I'd prefer to be able to do finer-grained positioning but referencing the png as
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
Zoho Creator Integration with QuickBooks: A Step-by-Step Guide
Introduction: Integrating Zoho Creator with QuickBooks allows you to sync your business data between the two platforms, providing a seamless experience for managing accounting, invoicing, and financial data. This integration helps automate workflows and
[Free Webinar] Building intuitive UI/UX with HTML & ZML 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
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
Display comma in number field (thousand separator)
Love Zoho so far! How can I add comma as thousand separator in number field upon input by user? This is essential feature when dealing with larger numbers to make readable. Is there number formatting script for this? For example, change 600000 to 600,000 This link appears to be related to the topic. https://help.zoho.com/portal/en/community/topic/amount-display#2266000001410984
How to add a record for a different report
I have one form and it has two reports I need to programmatically add records to both reports For example one report is draft and other is processed After the user performs some action on the draft report I want to create a new report in Processed and
Link Images to a Excel Report
When I export to a spreadsheet. How do I get it to create a link that goes to my image. Right now it shows up in Excel as: /sharedBy/appLinkName/viewLinkName/fieldName/image/1510098844838_Image_07-Nov-2017_18_54_03.jpg
Alert for Back Navigation in Zoho Creator Widgets on Mobile Apps
In Zoho Creator widgets, when a user navigates back on mobile devices, the data within the widget is reset. This leads to a loss of any unsaved changes or inputs, causing frustration for users. To enhance user experience, we need to implement a confirmation
Records per page in New UI
It seems the new UI lack of "Records per page" function, it is very handy if you are looking for a data that you don't know the exact search term, but you know it may "between" few entries. without a "page" function, we kind of have to keep page down and page, the autoload is not that fast, and you are dealing with thousands of entries. Could we please have the "records per page" function back to New UI (also it shows total counts of the record) Looking forward to hear from you.
CSV File Added to Form - Parse and Map to Fields
Hi, I apologize, I can't seem to find a clear explanation or help article on how to parse a CSV file. On validate, I process this deluge script. fileContent = Collection(input.File_upload.content); result = fileContent.values(); info result; What I want to do is create a record (in another form), and map certain fields to fields in the form. I can get values, which is the whole file but no keys. If I use result = fileContent.keys(); I get "0" As you can see from CSV, my first line is my map and
geographic search filter in map view
Hi, I have a recruiting and timesheet system built in Creator. The client wants to enhance the search for candidates based on their location and filter by job skills - currently they look on the Map View which uses the geo location or post code of the
Emailing lookup field but placing this as an ID or number rather than text
Hi there, First time poster and have been a user of Zoho Creator for approx 6weeks so forgive my ignorance as I learn to code. We have a need to send an email to a specific email address with some of the fields triggered by the submission of a form. In
Issue with Bulk Edit Triggering Function Multiple Times in Zoho Report
In our Zoho report, we have observed an issue where executing a function during a bulk edit operation runs the function multiple times—once for each selected report entry. This behavior is causing errors due to overlapping or redundant executions. Our
Next Page