Filter Lookup Field by Most Recently Used
Hi, Is it possible to sort a lookup field by most recent? Like, I want items that I recently selected to show up at the top of the list.
Is Zoho down today?
I can't do a single thing. I tried changing some views and reports and got "undefined" - then I tried editing a form, got "undefined' - started a new form and can't add any fields as when I drag and drop it also says "undefined." What is going on? HELP.
How to Display Formula Result as Currency?
I have been searching this topic for an hour now. The best I can find are posts from more than 2 years ago with no solutions. Is this still not possible? The formula field does not allow for a format option. The report does not allow for a format option. My formula is based on a currency field with basic addition, multiplication and division. Why would the result not maintain the currency format? From the (outdated) Help section (https://www.zoho.com/creator/help/fields/configuring-a-formula-field.html)...
Simple way to add Support Contact to CRM Leads/Contacts on New Ticket
Case Scenario: Support WebForm is used as contact form on company website. Visitor is not yet customer of company, and is not listed in company CRM. When form is completed, Support is updated with contact information, but CRM is not... therefore potential customer cannot be located in the CRM for follow up or automated responses/workflows etc. I've been looking through the documentation and there does not seem to be any automated way to create a CRM Lead based on a new support ticket creation (by
Share your success story
We would like to hear from our passionate users how much Zoho Creator has changed the way you work and benefited you. If you would like to share your story to us and be featured as a proud user of Zoho Creator, then this is for you. Fill up the form below and if you want to be included in a case study, we will get in touch with you to get further details. So what are you waiting for? Tell us your story. Charles
Prevent Enter Key From Submitting Form
I have a client who really likes the Zoho form but doesn't like how using the Enter key (Return key on Mac) submits the form instead of moving the cursor to the next field. I am personally used to this so I only use the Tab key but perhaps this option would be nice functionality to add. From what I have seen on the web there appear to be ways to code this alternate functionality. Unfortunately I am not a programmer otherwise perhaps I could do this myself using your scripting functionality. Thanks
Subfrom data in Excel
Can we send a Subfrom data in a excel sheet while Triggering a Email in Zoho Creator.
Zoho Creator - Portal - Custom Domain Verification failed
Hello Guys, I've been trying to verify my custom domain for my Portal on Zoho Creator. I've contacted support and they told me to add CNAME Records which I have already done. I've tried adding CNAME, TXT rec , TLL - 600 seconds but no success. Domain
Preserve metadata info of images
Hi everyone, is there a way to preserve metadata info of an image taken or uploaded to an image field?
How do I resize the forms on my site?
Hi How do I resize the forms on my site? How to reduce your size? Etc. .. Thanks
Subform in a Stateless Form
First off, cheers to the creation of the subform function in Zoho Creator! However, with it, I seem to be running into an issue in trying to create a stateless form from a standard form that includes a subform. If I ask to include the subform, it won't let me create the stateless form (Variable '"SubformName"' is not declared). Is that a function that will not be available with stateless forms / subforms? My hope is to be able to create a versions of the standard form with a more limited set of
Shall we play a game?
Presenting the very first game created using ZOHO Creator: Tic-Tac-Toe (or noughts and crosses) I made this to challenge myself and employ some of the new features of ZOHO Creator. I must admit that the code is very literal and not too elegant. There are plans to improve on the machine AI and streamline the code over time. Currently the code makes extensive use of functions for the machine "AI" - there are 12 of these. The machine AI can be tricked, so to counteract that I made it exceedingly arrogant
Count based on criteria
I am using Creator 4 if that matters. I am a deluge and zoho creator beginner so I apologize if I use the wrong lingo. I've searched other community requests and thought I had my answer but it isn't working. I want a running total based on a drop down field. If one option is selected I want that one counted up and if the other is selected, count that up. I've tried this script in multiple places but it doesn't result in a count. Regular_Stay = Room_and_Bed_Registration[TypeofStay == "Regular"].count();
Zoho is Slow
Let me be clear, the speed problem that I refer to below is a Zoho problem not a network problems. Other web apps running alongside Zoho do not have these problems. This post is in regard to typical behavior of Zoho. Here in the US (Eastern Time), Zoho slows to a crawl. Forms that usually load in less than a second, are currently taking minutes to load. For customer who are in the software all day this is a huge problem and I have had customer refuse to use Creator due to this problem. When
Workflow in zoho creator
I created a workflow which seem to work only for the superadmin and not for the portal users. I dont know what the problem is
directing contract form to my email
Morning I've creating a contact form and embedded it. How do I get responses to come to my gmail inbox please?
How to insert multiple selected records from a report into subform of a form in zoho creator?
I am developing a simple site apkzhola inventory application in zoho creator. There are 2 forms in this case. Form A: Material request. This form has a subform with fields for product and quantity, Form B: Purchase Order. Has a subform with fields for
Masking phone number
Hi all, I'm trying to mask the first 3 digits of a phone number, like this example: Original: "912384735" Masked: "xxx384735" I've tried use the remove and replace function but with no success. Thank you for your help. Best regards, Rui
how deluge statement usage limits are count
Hi, There is a limit of 5000 statements in a script, for example when I process an on load or submit script. In an earlier forum post I found this text: But if you have a "for each" loop within your action script, the number of times the tasks are executed depends on "the number of records iterated x the number of tasks". For example, if you have 500 records to be iterated and 3 tasks, the total number of executable statements for this action is 1500. It is not the number of times they are triggered
Multi Language
Dear all, what is the best way to create a ZOHO Creator application, which is multi-language based on the Language settings of the User? Thanks, David
Import CSV and set Added Date
Hello, I was wondering if it was possible to set the Added Date when importing from a CSV/TSV. I had an "Added Date" column with a date, but it didn't get set. So I guess I have two questions: 1) Is it possible to set when importing via CSV/TSV? 2) Is it possible to set via the API? Kudos on Zoho Creator. It looks great. I'm really looking forward to subforms and future tweaks.
debug - where is "view log details"
On the page below, https://help.creator.zoho.com/Info.html it says you can debug a script by clicking "View log details", but where is this button/link?
Using URL field to create clever links to maps
First of all - thanks for a dandy little service! I'm trying to use the URL widget to dynamically look at another field (a text field called ADDRESS) upon successfully editing the record, I'd like the script to look at the address and create a properly formed URL to Google Maps. I believe I understand how to transform an address into the required strings for the URL (ie, substitute '+' for <SPACE> etc.). My problem is how to dynamically assign a URL to the URL field, and dynamically assign the address
Creator scheduled Deluge repeatedly failing - unable to replicate error manually
I have a scheduled workflow that runs every morning to bring in data from another system and check for updates. I'm seeing in the error logs that it fails : Error details: Error in executing SYSTEMNAME Update Error at line : 23, Invalid collection string
Zoho Creator Usage Details for 11 Sep 2024
Hello Support, I want to get the usage details for Zoho Creator for 11 Sep 2024.
Publishing an Application with a Student Account
Dear Zoho Creator Team, I hope this message finds you well. I would like to know if I can publish the application I built using my Zoho Creator account, which is currently a student account. If it is possible, could you please guide me on how to go about
Problem with simple IF script with a variable
Hello, I reaaly don't understand what I do wrong, and it must best super stupid... With this simple script : doublon = Test_Client.count(); if (doublon > 0 ); openUrl(www.fermerondine.com, "same window"); I always get this error for line 2 : Incomplete
Publishing an Application with a Student Account
Dear Zoho Creator Team, I hope this message finds you well. I would like to know if I can publish the application I built using my Zoho Creator account, which is currently a student account. If it is possible, could you please guide me on how to go about
Multi page form, trigger API call or function on page 2 load
I have a multi page form. On page one is basic info: Name, email, address, phone, etc. Page 2 would look like this: Checkbox - "By checking this box you agree that you may have to travel up to XX miles for your internship" Text Field, read only - XX miles
Zoho Creator - Using Connection to create an entry in another application
Hi there I want to add a record into another Creator application. Both applications fall under the same superadmin/company. Now, I have the following system-generated connection, which I have authorised. My line of code is this: record = zoho.creator.createRecord(zoho.adminuser,
Need Suggestions for how to Develop a Fitness Tracker that Tracks and Emails Progress
Alright, I just wanted to run this question by you guys because I have been trying to develop a database application for people to enter in just fitness numbers like number of pushups, height, weight, etc. They would use a person number so that the people interfacing with the database will not see the data (but that's trivial, and I can figure that out). What has been challenging is making it so that people can enter data at several times, and having the databse email them the percent change from
Please suggest a zoho creator based in Kolkata
Need a developer have a grip in Zoho Creator and is based In Kolkata and can work part or full time urgent contact
Dynamically pass multi-select values to a chart/gauge criteria; Or, get sum total of multiple counts from a for each loop
I want to use a multi-select field in a form to dynamically show results in a gauge/chart/graph. I would assume that when passing the multi-select values to the page variable, the page variable should be of type Collection..? When I try to set my gauge
Adding Record(s) in Zoho Creator using a widget written in JS, HTML and CSS.
Hello Guys, I recently shared a good documentation with real code on how to add records to reports in Zoho creator using a widget built in JS, CSS and HTML You can check up the article on this link or https://medium.com/@simelj/adding-record-s-in-zoho-creator-using-a-widget-written-in-js-html-and-css-2a45ba2a9bd9
Change Blueprint Stage in Creator via Deluge
Hi there, I currently have an ordering system created on Zoho Creator. This is for when we want to order goods from suppliers. I have created a blueprint for these orders. Simplified it comes down to something like this: - Order to be approved - To be
Assistance Needed: Adding Company Logo and Phone Number to Printed Report
Hello, I’m using Zoho Creator and need assistance in adding my company’s logo and phone number to a report I’m printing. I’ve attached an image of the report, which is primarily a row in the Report section. Could you please guide me on how to do this?
Bottom navigation bar
I'm losing money hand over fist because people think when they've reached the bottom of the first page of products that that's all I have. I tried putting instructions telling them go to back to the top and click the arrow on the navigation bar. I worked at Lotus Development (the creators of Lotus 123) for 10 years and I sent the page to my colleages from there as well as friends and relatives asking them if they thought http://GetThemToday.com/spfoods.html was usable or if people were going away
Can I clear only a section of a form?
I have a form with several sections. Many times we duplicate records and only need to clear a (section) of the form and not the entire form. I know there's a "reset" button for the entire form, but is there a way to make a button which will clear only
Remove alternative Options in Reports.
Welcome everyone, is there a way to remove the option to transform a calendar report into an kanban, list or timeline report? Especially kanban and timeline are confusing in my case. Thanks in advance! Best Regards Jan
How can I make a field visible/unvisible
Hi I plan to expand my form with more information. But before I do this I need to know if it is possible to make fields visible/unvisible depending on selected values in other fields? BR Dennis Skouboe
Next Page