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
Auto populate form after opening via OpenURL
I have a Vacation request form that allows the approver to approve/reject via custom actions in the report view. Upon Rejection, I have enabled a form called "Reason for Rejection" to open. On that form, there is a Request Number field and a multi-text field labelled "Reason for Rejection". Is there any way for the Request Number field to auto-fill upon selecting reject? There is obviously a corresponding Request Number (Auto-number) field in the Add Leave form.
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
workDaysBetween
Is there anyway to get around the workDaysBetween function not being able to count work days between dates if they are more than 360 days apart?
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
Text wrap column headers in reports?
Is it possible to auto wrap column headers so that a longer multi-word header displays as two lines when the column is narrower than the width of the header title?
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?
Can I make a client portal so that they can upload/download documents?
Hello Experts I would like my clients to access a portal using some kind of authentification (their email address?) so basically access to their own secure client/customer portal and let them securely upload documents in a folder related to them. so my
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
Select CRM Custom Module in Zoho Creator
I have a custom module added in Zoho CRM that I would like to link in Zoho creator. When I add the Zoho CRM field it does not show the new module. Is this possible? Do i need to change something in CRM to make it accesible in Creator?
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
Integrate with Power BI
Hi, How to connect Zoho CRM dashboards & reports with POWER BI ?
Function Code Not Working
Can someone tell me what is wrong with this code? It says it executed successfully, but nothing happens. I believe I have all the field and form links correct. void undoButton() { for each a in Memory[Undo == "Undo"] { if(a.InOut == "In") { insert into
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
Embed Report with Auto Height
Hello Developers, When we embed report within Page, we are getting one awesome feature to adjust the report height. "Auto" and "Custom' height. This "Auto" option works well when we have no records. But I want to embed report based on some conditions
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
Best way to display API data within a Creator Page?
I'm trying to build a Page that includes: statelessFormA w/ Lookup and text fields, a report view, and a section containing data from an API call. I've got statelessFormA and the report in place and the report is updating based on my inputs in the stateless
OpenUrl Button in Report not working when embedded in Page
I have a reportA with an action button that opens a reportB in a pop-up. It works when using reportA in stand alone mode. But when reportA is embedded via iframe in a Creator Page, the button does not work, I get the "failed to retrieve this report" message.
Registration forms
Is there a way I can specify that a field on the registration form is required so that the form cannot be submitted when there is no information entered for that field?
How to get zoho.loginuserid or loginuser in JS SDK Widget in Creator?
I want to use zoho.loginuserid and zoho.loginuser variables inside my JS widget. How to achieve this? Keeping in mind that these 2 are very important variables. Would parsing as parameters be an option?
Like Operator
What exactly is the "Like" operator in the report search options used for? I want to not have to use exact wording when searching a report. For example, if a field contains 1/2" Ash, and I search Ash 1/2", I would like it to still find it. I thought the
how to dynamically upload multiple images for single record?
Is the use of dynamic multiple images in a single record supported? I've searched but have not found the answer. If it is supported, how is it done? I saw 1 suggestion to add a sub-form but that doesn't seem to be the answer. I don't want to add a set number of image fields. Each record would have a different number of images. I want the addition of images to be dynamic. thanks
Add Slider Field for Zoho Creator Forms
Dear Zoho Creator Team, I'm writing to request a new field type for Zoho Creator forms: a Slider field. This functionality currently exists in Zoho Forms, and its integration into Zoho Creator would provide significant benefits for data collection and
Next Page