Update content offline on mobile
The client wants to scan barcodes in his inventories, and to see the inventory scanned in real time. He uses a mobile phone and an external barcode reader, which just pastes the barcode value with a line break in the end. The challenge here is to make
Hiding Sections
According to the Creator new help page for sections, https://www.zoho.com/creator/newhelp/forms/fields/section/understand.html, it should be possible to hide or show sections (and in-turn all the fields that are inside a section). However, I am not able to do this, neither in Form Builder or using Deluge Script. How can I hide/show a section?
Creator : Filter Pivot Charts by a Function
Currently pivot charts in creator will only show either all records or the logged in user records I need to be able to add a filter calling a function I have created to show results based upon the organisation that the logged in user belows to. float
Delay function execute
I've got a workflow which uses a webhook to send information to Flow, which in return updates a record in Creator. Problem is, by the time this has executed, the rest of my script has run and can't find the (yet to be) updated info in the record. Is there
Invoke url does not send valid json
Hi! I'm having a script sending a http post action to a third party software when a new record is created. The response I get is "error deserializing json" as if the code is not valid json. The simple code I'm sending is: {"Customer":{"Name":"Sven Eriksson"}} I have tried the code in another service and it works fine. I can't understand why it doesn't work in Creator. Here is my code (I have masked access-token and client-secret): header_data = Map(); header_data.put("Access-Token","xxxxxxxxxxxxxxxx");
Calculate distance between two areas
Dear creator's community I need help with this api request, I checked on the support online and on the form but it’s very confusing for me because there are different type of supports between the old version and the new version, I would like to get the api for the distance matrix between two area. I've tryed to create this code but of course doesn't work MapResponse = getUrl((("https://maps.googleapis.com/maps/api/distancematrix/json?units=imperial&origins=" + input.Origin) + "&destinations=" +
How do I make an API request through Node.JS?
In Zoho creator, I created a function that uses nodeJS. In the function, I'm making an API call to an outside URL using a fetch request. The problem is that whenever I run it, it says that "fetch" is not a function at module.exports. I've also tried it
Schema Builder diagram, how am I supposed to read the microtext?
I am hoping there is a way to capture and transfer the schema builder's output to a web or desktop app where it can be magnified without losing fidelity and studied accordingly. The Creator schema builder is great in concept, but limited in its visual
Validation and required fields in code
Hi, I have a few questions in which when answered a certain way brings up a new question below. Some of these questions I would like to be required fields so they have to answer them but I don't know if that is possible? I would like to have something in the code like: ( If question = "yes" Show "new question" and "validate as required field" ) something along those lines but I'm not sure how to or if you can? Many thanks, Gill
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
Next Page