How to update subform record through a widget in Zoho Creator.
Hi. Can I ask for help what is the correct syntax for updating records in a subform through a widget? The below code can fetch subform records. I need help with the correct syntax I should use on the Edit function(function myfunctionEdit()) for how I
CloudConvert API
I have searched around to convert an image to a PDF but was unable to find anything. I came across CloudConvert which has 25 free credits per day for file conversions. A few topics, such as this were looking for file conversions. One of the replies says
Request for Assistance: Setting Conditions and Calculating Duration in ZOHO CREATOR
Hello ZOHO Creator Team, I am currently working on a project using your platform, and one of the forms I've built includes two fields: Working start Time and working end Time , I would like to set a condition that prevents the user from inputting a Start
[Free Webinar] Learning Table Series - Creator for the Education Industry
Hello Everyone! We welcome you all to the upcoming free webinar - Learning Table Series. The Learning Table Series is a free monthly webinar that runs for around 45 minutes. It's offered to our Community users and aims to provide a dynamic learning experience
How can I import a database App
Hi I need to be able to import an Excel-based price list into my app for processing. I understand that I can create an App based on data imported from an external spreadsheet. I do not wish to do this. Instead, I wish to create a button within the Creator App which, when pressed will allow me to select an Excel file of a predefined format, to import into the Creator Database. I cannot work out how to do this. Please help. John Legg Owner: The Debug Store
why error occur when use lookup code?
why there is an error said PO_Rec.PO_No is type of number form fisrt pic but in 2nd pic i use the same lookup code but error doesn't occur *PO_Rec.PO_No is lookup field from single line
Page iFrame embed
Is there any way to remove the heading bar from a report iFrame embed on a page? Also, is there any way to disable scrolling from side to side?
Published report behavior on website and mobile devices...
We display categorized lists of nonprofits on our website using published reports displayed in iframes. Most reports have a single column and display properly. There are a few reports that are 3 columns (Nonprofit name, category, subcategory). On the
How To Sort List of Maps?
I have the following below; If I return Collection(keyList) at the bottom, keyList is sorted correctly (I've tried both true and false and it works). But when I add to my sortedList in the order of my keyList the sortedList is not sorting how I want -
Exporting Reports as XLSX
When exporting reports as excel, the sheet name in the exported excel file is named after the report link name. Is there a way to rename the sheet on export? My problem is the report link name has_underscores_in_the_name and does not allow for spaces.
Enhanced Drill-Down Functionality in Zoho Creator Applications Usage Report
Dear Zoho Creator Team, I'm writing to request a significant improvement to the Applications Usage report within Zoho Creator. Currently, the report displays various metrics, but it lacks the ability to drill down for deeper insights. Current Limitations:
Using freelancer for zoho creator
Hello, We have found a freelancer to create an app in zoho creator for us. This person will need to have access to our zoho books, creator, zoho inventory. But in the same time i want to "control" what he has access to (for sensitive information). What
Limitation of reports on Zoho Projects Integration
I was really excited when I found out that we could integrate our Projects & Prople data into Creator, because we thought it would allow us to use Projects as a datastore but wrap some of our workflows around our work, but we've hit some limitations.
Export Data & Attachments
Hi, I am wondering whether it is possible to create an export of all data in creator, including attachments, for either backup purposes, or migration purposes. Thanks.
FINALLY! 100% Responsive iFrame for HTML Page Snippet
For the past two years or so I have been battling with Page Snippets' responsiveness (HTML, Embed, and ZML). Furthermore, if you use the native embedded reports, especially more than one report on a page, you have to set a static height because they're
How to create an Auto number field?
Is there an easy way to create an auto number field that I can use as my primary key field like I can do in Access database? Why isn't there an option for a number field to auto increment the number and also an option to start at a particular number instead of zero or one? I've suggested this to Zoho support and they said they might add it someday in the future. Maybe if enough of us ask for it then they will. In the mean time, which code do I need to enter to create such a field?
How to add customer details to form when they sign up
I have customers signing up to my application which I then approve or reject. The are inputing their full name and email address. I would like them to then input other details in the Member form that we have like phone number, address, and other details.
Better custom connection interface
Microservices / custom connections are really problematic to use at the moment. To test if they actually work, you need to create it, then enable it (which is a multi-step process), then write a API call in Deluge then call it. You should be able to:
Keyboard Shortcuts
Is there any way to make a keyboard shortcut to add a new record to a report?
The task has been terminated since the API call is taking too long to respond
Hi there, I am using Deluge with invokeurl to make several API calls within a loop. The API calls itself, when using Postman, are done within 2-3 seconds (all togehter). When using Deluge it does take much more time and ends up in "The task has been terminated
How to print a pivot table report (ZC 6)
Greetings, I hope this message finds everyone in good health and safety! I have created a Pivot Table report and it is functioning well. I would like to provide a "print" option for the user, which would load a view allowing the user to configure the
What is a line break code for zoho?
Hi, I am archiving data by adding values from a single line field from one form to a multi-line field in another form. So I need a code/function that starts a new line on that multi-line field so it does not just keep adding it on the same line. Example, doing something like this means that it will be on a same line. archive.field1 = archive.field1 + input.Field1 I need a code so the input.Field1 can just start on the next line. Instead of "value 1, 2,3,4,5" It will be: "1 2 3 4 etc.". something
Zoho Creator Form - Google Analytics Code
Hi there, Can you please advise where / how in my Zoho Creator Form workflow i may place a Google Analytics tracking code? I need to track the form submissions as an event in my Google Analytics account. Thanks, Emily
How to Sort a Collection(API data)?
So, I have something like this: versionList = Collection(); for each item in searchUrl.getJson("results") { year= item.getJson("year"); label= item.getJson("label"); catalog= item.getJson("catalog"); versionList.insert(year + label + catalog); } The only
Favicon for each app
I can see in the general company settings that I can set a favicon and a company name. But I need this to be different for all the creator apps I have developed - not just the same icon for all of them https://creator.zoho.eu/userhome/MYACCOUNT/dash
Zoho Creator
I have set up a workflow for sending an email upon successful deletion of an input ; this worked fine up until about a month ago. Since then it hasn't worked, can anybody assist?
Automatic Incrementing of Field in Form
Hello, I have an application that include a form comprised of several fields in ZOHO CREATOR , I would like the field labeled ORDERID to be automatically filled with a sequential number starting from 1 each time I fill out the form. How can I achieve
Tip 7: How to fetch data from another application?
Hi everyone, Following our Zoho Creator - Tips and Tricks series every fortnight, we are back today with a tip based on one of the most popular questions asked in our forum. This tip would help you fetch data from another application(App B) and use it
Report filter based on form input
I have a page with a form and a report on it. Is there any way, that when I select an input for the dropdown on the form, that the report would only show entries on the report that match the input?
Key Shortcut for New Record
I suggest a control-key combination that acts like the "ADD" button. Bruce "Speedy G" Peaslee The World's Fastest Programmer
Customizable Favicons for Zoho Creator Applications
Dear Zoho Creator Team, I'm writing to request a new feature: the ability to set custom favicons for individual Zoho Creator applications. Current Limitations: Currently, Zoho Creator only allows setting a single favicon at the organization level. This
Zoho Creator Upcoming Updates — March 2024
Hello all! Zoho Creator remains committed to enhancing your productivity and efficiency, and this month's update reflects that dedication. Here are the improvements coming your way this month! Voluminous data processing using batch workflows Importing
How to fetch data from Stringlist Checkboxes?
Hi team, I need your guidance on Zoho Creator. I have a stringlist called "Activity_Type" and it has 2 checkboxes: "Yes" and "No". I'm writing a Workflow IF condition depending on what the user chose (Yes or No), but the line of code below does not seem
How to get value from subform fields?
Hi all, I can't get or assign value to a subform field when the trigger is on "User input". "Harvested_Line" is a field in the subform. Snippet: lineList = List(); for each record in Lines[Parent_Farm == input.Farm] { lineList.add(record.ID); } row.Harvested_Line:ui.add(lineList);
How to load a Rich Text Field with information that is already formatted as a table?
I am trying to upload information from a subform to be displayed in a Rich Text Field. Ideally, I want the information to be uploaded as a table within the RTF. Is there any way to do this? If not, how do I print the information to the RTF and also have
"Invalid cliet task found" error while filtering Lookup Field values
Hi, I am encountering an error message, "Invalid clist task found," while trying to filter out the lookup values in Zoho Creator. Here is the script I am using: clear input.deploymentDate; availableDates = DeploymentWindows[availableDate> zoho.currentdate].availableDate.getAll();
Zoho Creator On-premise
Hi, Does anyone have experience with On-premise app development using ZC? I can see the documentation here but I can assume there are unwritten limitations and subjects we should be aware of. I would like to hear from your experience. Thanks, Naveh
How can I filter a field integration?
Hi, I have a field integration from CRM "Products" in a form, and I have three product Categories in CRM. I only need to see Products of a category. Thanks for you answers.
Mail Errors
Is there any way to know if there's been an error during the sending process? (i.e the receiver mail doesn't exists)
Consolidate Zoho Creator records to send via email.
I have been trying to figure something out for quite some time now but haven't had any luck. I need to consolidate multiple records from a Zoho Creator form into a single email based on certain criteria. For example, I have a form for which each record
Next Page