Popup / Expand option not showing for Subform with less than 20 rows in Zoho Creator
Hi Folks, I am working on a project. Where there is a subform with around 15 Columns. In order to see other columns, we need to scroll to the right. We have a popup option for Subform, with which we can view the subform data in a popup view. But the issue
Fetch Records within a Date Range
This seems like it should be an easy thing to do, but I can't get the syntax right. I want to fetch all the records in a form that are within a certain date range, say the last six months. I have seen syntax like this rec = Contact [ID != 0] sort by Added_Time range from 1 to 5; referenced here: https://www.zoho.com/creator/help/script/fetch-records-within-range.html I do not understand, however, how a range for Added _Time can be an integer like 1 to 5. I would think if it as a date-time field.
{"4834":"Invalid Ticket Id"} as response of ACCOUNT_POTENTIALS = zoho.crm.getRecords("Potentials");
Today all fetchs to zoho crm give me the error {"4834":"Invalid Ticket Id"} All calls that I made are of the style ACCOUNT_POTENTIALS = zoho.crm.getRecords("Potentials"); crmResp = zoho.crm.getRecordById(("Accounts"), input.Cuenta_ID); etc. I have found some post with this issue and it seems that it's related with the auth token.... but i don't know what i need to do to fix this issue. Could you help me?
Formula field not working properly
I have an input field "Basic" and some other fields and one formula field "Total" in a form. When I input data into "Basic", then an workflow runs (on user input). The workflow populates some values and puts those into other fields. The formula field
Boolean operators
Why can't I use != (not equal to) when comparing 2 booleans?
Zoho Creator | Panel not saving after editing keeps on loading.
Use Zoho Analytics tables as data sources for Creator apps
I am currently using Zoho Analytics to create reports using data generated from a 3rd party web-based case management system. It would be very helpful if users in my organization could create applications/forms using data from the Analytics tables and
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
Next Page