Default Drop Down Value when List Retrieve from other Table
Hi, I am adding a list from a table for one of my drop down menu using the following method: input.DropDown:ui.add(MyList) But when the list get fetched but there is no default value in the drop down menu until i click the dropdown. Anyone can give
Lost trying to use the Zoho Creator API v2
Hello, I'm having trouble getting started with the Zoho Creator API -- not even sure which client type to register. I have some business customers that log into my Zoho Creator app as Customer Portal users to add sales information, etc. Some of them have
Where to find decent video tutorials on Creator customer portals
Hi Does anyone know any basic tutorials on how to create a customer portal and how to create a form that updates a module record in CRM? The few videos Ive found are tortuous to watch with mistakes happening during the video! I need professionally produced
@SUPPORT STOP EVERYTHING YOU NEED TO FIX THESES FIRST!!!
Now that I have your attention, let's make this thread a recap of BUGS and IMMEDIATE redesign/feature needed for Zoho Creator to be somewhat more user friendly for devs and users alike. Yes this is a spamming thread intended to get Support's attention,
Refresh/redirect parent page of iframe
Sooo, I'm fairly sure this is impossible, but I need to ask in case someone is much smarter than me. I have a bunch of forms/reports/pages that have workflows/functions that will either bring the user back to the homepage or refresh the current url. Those
Fetch Records From a Specified Date
Hi, I've been looking for a solution but cant find anything yet. Is it possible to fetch a record from creator using deluge for a specified date. For example i have a schedule running daily and i want it to fetch records for that day a week ago or 3 months
Fetch a Record, Rename and Upload to WorkDrive
Hi all, We have thousands of test records and we can click the 'download button' on the report on a single record and it will rename and download, as below. It works great, nice and easy. //groupReportNo = frmGroup[ID = input.groupID].groupReportNo; //groupReportID
API call of avarage
Hi how can i obtain via api call the avarage of a field (Sales) of records from one specific day_? i know i can get this info in a snippet on a page but i want to know this value avarage of all via API also i can get this value on a pivot table but pivot
Multi-organization SAAS application
Hello, I am considering using Zoho Creator to create a large-scale business application. Since this SAAS application will have to serve several different clients (organizations), I plan to make it accessible through a Zoho portal. My question is: How
Create a record/row on subform from existing fields on crm record
Hi there! Not sure if this is possible, but this would make a huge difference in our system. I want to create a row in a subform (with four fields) from existing four other fields in the main record for my module 'Migration'. The fields are the same
Sort function out of work
I create a collection and try to sort by date. but no matter I use sort or sort key . the collection order didn't change. aaa.insert("1231231","2022-10-10"); aaa.insert("1231232","2022-10-11"); aaa.insert("1231233","2022-10-12"); aaa.sort(true); aaa.insert("2022-10-10","1231231");
What is the fee structure?
Hi, I need a portal that allows about 300 customers access to edit their details in our Zoho CRM. CRM's portal is very limited, so Im thinking about using Creator. How much is it for Creator's Customer portal for about 300 customers? Thanks
Checking fully booked on form load
Hi all, I have a system I have built that allows people to book on an adaptive form based on the company I want them to use. This is just piped into the end of the URL and then they fill the form out filtered on that. They have weekly options too so they
Regular Expressions Help
Regex such as "^[A-Za-z]$" doesn't seem to work. I also tried an email regex like "^[A-Za-z0-9]+@[A-Za-z0-9]+\\.[A-Za-z]{2,}$" it doesn't work. My code below. emailRegEx = "^[A-Za-z0-9]+@[A-Za-z0-9]+\\.[A-Za-z]{2,}$"; e = input.Email_Address; e = e.trim(); if(e.matches( emailRegEx ) == false) { errors.add("Email not in correct format"); } I am using regex for validation instead of validation that comes with zoho because I am implementing a conditional validation. Some form fields are required
Creator Widget JS API Example
Does anyone have example code they could share which uses a ZOHO Creator widget to add a record. There are code snippets at the link below, but they aren't very extensive. https://www.zoho.com/creator/newhelp/app-settings/widgets/creator-api-for-wid
Formatting Text Fields - All Capital Letters
Is there anyway to format text fields to show-up as all capital letters? We can format a numbers field as currency. Why not a text box as caps, or title, or lower case? Thanks.
Working offline in Creator?
Hi all, I'd like to know if there has been any development in the past few years? One of my potential customers would need a reliable and intelligent solution (not only on mobile, easy and user friendly upload). The company has mobile agents, who work
Your current plan allows only demo of the SubForm.
Hi,my self satya,i am new in zoho creator.When i tried to save my form information it will show "Your current plan allows only demo of the SubForm." so anyone can tell me how to solve this issue.
Best Practice for mapping Zoho Creator application before building
Dear all, simple feedback thread here, I'm genuinely interested in learning how you all map out your Creator applications before building (if at all). I.e. do you use UML or any other form or schematics? Please post your replies as well as screen snippets
Creator 6 - What's your experience so far ?
My company are looking to make the switch frm C5 to C6 but I am curious to know what everyone's thoughts are in general and if there are any bugs or hesitations that people have experienced.
Update to Form Fields Error
I am making changes to zoho form, while viewing application, it shows. but other account roles do not see the new input box that has been added. I need help, please.
PDF Export Header and Footer for Pivot Table Not Able to Editable
Hi, want to understand why I can't edit the header and footer for the PDF export for my pivot table? Thanks.
Using deluge in report filter
I'm trying to create a report filter that looks up a value in the user profile. But when I add the function to the report filter criteria, Zoho keeps adding quotation marks to it. I enter Container_ID starts with thisapp.get_user_containers(), but when
Geo code with postal code
Hello, I was hoping to get the longitude and latitude with the zoho geo code feature by just using the postal code/zip code but am having some issues with this as it keeps giving me errors. Has anyone had any success with this? postalCode = "M4K 3B9";
How to setup default page in Creator when user lanuch APP?
How to setup default page in Creator when user lanuch APP?
Can custom functions return an entire fetch?
It seems, and I've been told by Support, that custom functions cannot return the entirety of a fetch: only the record IDs are returned. I've tested various ideas and I've confirmed this to be true. I can use the record IDs returned by the function to
Include Image from Image Field in Record in EMail
I'm sending emails with data from a Creator database. Each email is the contents of one record in my Employees form. One of the fields in the Employees form is an image that was uploaded to an image field in the record. There is a different image stored in each record (i.e., a different image for each employee). What code do I use to display the image in the message body of my email? Thanks. Jon
Labels misplaced for subform fields in C6
Hi everyone, I recently moved to C6 and I noticed that the labels for all my subform fields are misplaced as you can see in the screenshot attached. Have you any idea of what happened??
Custom Report Layouts are TRUNCATING TEXT elements on Mobile and Tablet Views
I genuinely think this is a bug with Zoho Creator. I made a custom layout for a report view on Mobile and Tablet. For some reason, some text fields are randomly being truncated while others are not. If I refresh the report, a different set of records
Field with reamaining time to deadline or overdue by
hi im trying to achieve a field or a widget that lets me see at a galce remaing time to due date or overdue by ... y have tried the following on a formula field but doesnt update
Send mail (on success) if new row added (subform)
Hi guys, Can someone help me out with the script for: On created or edited > on success Send mail if new row in subform added. I don't know if I'm just having a complete brain block today!! Thanks
Connect two forms and send email to customer
Hi, I would like to collect data from our customers using this 3 steps: 1. In our shop, our staff fill a form with an order number and customer email. 2. The customer receive an email with a link asking him to complete all the data, like name, phone,
Rounding does not fix character limit validation
Following this update ("Announcing strict validation for the max character length field property"), I have been working to fix character limits in my forms. I have introduced this code: input.Actual_Work_Time = input.Actual_Work_Time.round(11); The code
Code not working
Hello, I met a strange issue today, never seen this before. Last time (a month ago) when I used this part of the code, it was working fine. I am the admin, and did not change anything in the code. The flow is, that production form is opened from an order
Can I use Creator Form to upload files to Dropbox but not store the file within Creator?
Hello all, I'm very new to Creator so please bear with me if this is answered somewhere and I can't find it. I'm creating a database of sorts within Zoho Creator to store information on items I deal with in my work. Each item will have files associated
Is it possible to auto populate a sub form on load?
So i want to auto populate fields in a subform based of data passed when the user opens the main form.
Upcoming Updates - August 2022
Hi all, Greetings from the Zoho Creator team! Today we've got news for you on some exciting updates. And rest assured— there’s more to come! In this post, we'll be going over the upcoming features and improvements for this month as mentioned below. A
Images in Reports suddenly no longer loading (except on an older computer)
I have several Zoho Creator reports w/ images hosted via Godaddy web server. Last week, all of a sudden, all images in all reports stopped loading on all up-to-date Macs and PCs within our company. The only computer able to see the images is a 2011 Macbook
How to fetch html element using deluge
Sir i am facing problem in fetching html element by using deluge. Like in javascript we can use document.getElementById() Can deluge do the same?
Sendmail function - enter a delay in e-mail sending - is it possible?
I have a custom action that when finishes it's job send a e-mail message to an address. My wish is that this custom action to send a second mail a half minute later, with another content. Thank anyone who can give me an advice in solving this.
Next Page