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();
Sendmail to list of records
Hi, I searched but didn't find anything... I want to send an automatic email to a list of people in a form, based on a date of delivery. Here is what I did : CourrielFerme = "info@fermerondine.com"; Demain = zoho.currentdate.addDay(2); PointLivraison
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
Transform Numeric Values using st, nd, rd, th or Convert Numerals to Ordinal Form - Deluge
Please Use this sample Code This_Day_Date = zoho.currentdate.toString("dd"); value1 = "th"; if(This_Day_Date.right(1) ="1" && This_Day_Date != "11") { This_Day_Date = This_Day_Date+" "+"st"; } else if ( This_Day_Date.right(1) = "2" && This_Day_Date !=
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
Page view with cell phone
Is there anyway to ajust the page view on cell phone, not using a Zoho Creato app but a cell phone browser ? Right now it only displays a standard pc view, that is hard to read. Sylvain
Deluge Editor Code Reformatting and Dark Mode Support in Zoho Creator
Hello Zoho Creator Support Team, I’m enjoying Zoho Creator but facing an issue with the Deluge editor—it's automatically reformatting my code (removing spaces, changing brace placement). Is there a way to turn this off? Also, is there any option to enable
Need to get minimum date, but on or after current date
Hi, In a page script, I want to display next up-coming date of a specific userid. I managed only to script the get minimum date, but I don't see how to add the "on or after the current date" part. Here is my script : input.ProchaineLivraison = Calendrier_maitre[Courriel_Abonne
On Validate Old.Subform
In the On Edit -> Validate section I want to send an email if a change is made to a subform. I don't care what the change is just need to test if any change was made. If input.subform_name != old.subform_name { //do something } Are there plans to add the subform to the Old Fields Values? Herb Wexler
Zoho Creator - 2024 Release Projection 1
Hello everyone! As we enter 2024, we'd like to extend our warmest wishes for success and prosperity. Your fantastic response to our Product Roadmap page last year has been incredibly motivating. Continuing on this path, we're excited to share a glimpse
Zoho Creator monthly roundup - September 2024
Hello all, We're back with an exciting set of new features and enhancements that will elevate your Creator experience even further. In case you missed it, we’ve recently revamped our Product Roadmap page, now with a refreshed design and showcasing all
[Free Webinar] Learning Table Series - Creator for the Nonprofit Industry
Hello Everyone! 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 by demonstrating how Creator can be used as a solution for various
Give us access to record comments through API/Workflows/Deluge
It would be great to have access to comments related to a record through API, workflows and deluge. This could open up a lot more possibilities on how the comments section in Zoho Creator is being used. One use case I would consider is creating workflow
Reservation System
Here is my basic code to start with. // Step 1: Capture user input for Check-In and Check-Out dates check_in_date = toDate(check_in,"MM-dd-yyyy"); check_out_date = toDate(check_in,"MM-dd-yyyy"); //info "Check in date " + check_in_date + " - Check out
Zoho App For Written Note Taking Template
I am trying to use some app within the Zoho sphere of apps to take my on site assessments with customers. Every app on Zoho I tried so far (Writer, Projects, Etc.) can not handle me using my Apple Pencil (It only wants text entry). Is there an app that
IT Asset Tracker using People
Hi, we are currently using Asset Tracker to hold our machine "laptop" information. Is there a way we can use the User contact information in People to associate them to a machine "laptop" Thanks
Find next upcomming date in report (calendar or list) with workflow
I have a web store in which I want to force the delivery date of the order to be the next upcomming date of another form (a form that states the available dates for deliveries). Any type of script like "getthenextdate" exist in Deluge ? Also, is it possible
Report Options Improvements
Currently there a number of, let's call them quirks, when trying to setup reports for an Apps users. There are often times when hiding the "Add" button on a particular report for all users would be useful. However to achieve this we must embed the report in a page, now we get an extra page every time we need this functionality. If you need to remove the 'SpreadSheet' option but keep the 'Timeline' you would need to add an edit workflow with an "On Load or On User Input" code block. To remove the
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?
User level log in data
We have given roles and access, but when i am logging in using login user id, i was not able to see the exact related data of myself, it is showing me all the details.
Styling a Multiselect Lookup in a Report
Has anyone ever successfully been able to style a multiselect lookup in a report? These types of fields aren't available in the styler...
Introducing Creator Simplified: An exclusive learning series to enhance your app development skills
Hey Creators! Welcome to Zoho Creator's new learning series, Creator Simplified. In this series, we'll dive into real-world business use cases and explore how to translate your requirements into solutions in your Creator application. You can also expect
Empty Values in Mandatory Field in Zoho Creator Report
Dear Zoho Support Team, We are facing an issue in our Zoho Creator application where a mandatory field in one of our forms is showing as empty in the report. Despite making the field mandatory and preventing duplicate entries, some records still have
Sandbox data
Another useful feature would be to migrate the data from production into Sandbox. Otherwise making up test data in the Sandbox is a very very tedious job to say the least.
Creator Simplified #3: Iterate a set of code "n" times
Hey Creators—we're back with another edition of Creator Simplified! Objective Generate subform rows with serial numbers based on user input in a field. Use case Assume an event is being organized in an organization, and HR needs the list of participants
Delay timer for submiting form
Hello, Another bizarre question : is it possible to have a workflow that gives a delay for submitting a form or else it send the user to another page ? The purpose is that I have a customer form folowed by a subsciption form (or an order form) and if
Searching for creator-openAi resources
Hello and good day...I saw a while back in the community a webinar series on how to connect Zoho creator to OpenAI via the API but I am having trouble locating that resource again. It was a webinar about an hour long hosted by a woman...can anyone help
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
Accessing subform record related to another record.
I'm trying to access the record of a subform that is related to another record, is there any way to do so? I've tried by fetching the records of the subform with specific criteria, however the ways to search pull multiple records and not just a specific
Calculate 18 dates to fetch separately in another form
Hello, I have a form called "Subscription" that holds the following informations : Customer name (or ID, it is from a lookup) Delivery day (ex. tuesday, using single line string field) Number of deliveries (9 or 18) Start date (a given monday) As soon
How to get fields centered in a form?
Is it possible to center fields in a form? Some of my forms do some don't and it is really not aestheticly pleasing? Any help would be greatly appricated. Thanks, Michael McNeill
Trying to show a hidden field in a subform but get "invalid task in subfrom action.
When trying to show a hidden field in a subform but get "invalid task in subfrom action" when trying to save the action. The script is below. I look forward to your help. if(input.Jobs.Job_Type = "Warranty") { show Jobs.Warranty_Parts_Cost; }
How Does One Control Form Field Visibility by Role?
I feel like this is should be obvious and I'm being a dummy for missing it... Basically, is it possible to get this type of visibility control for form fields for roles other than Everyone or Admin? My use case is that my form has a bunch of fields that
Make some workflows functionnal only for portal user, not the admin
Is it possible to make workflows function only for portal users ? I have a form that I disable some specific fields, for user not to change them but see them, and as admin I want to change their content. For example the user has to ask me to make a change
zoho.crm.searchRecords from Salesorders by id
Hi, I'm trying to obtain salesorders data using searchRecords id but I don't know what is the id field name. I have tested with salesorderid, salesordersid, id, ... and a lot of names for the id field but always I get the error {"4832":"Invalid parameter value"}. I only want to know what is the id field name to get the salesorder data. I am using this code: sCriterioBusqueda = "(salesorderid|=|" + input.OrdenDeVenta_ID + ")"; crmResp = zoho.crm.searchRecords("SalesOrders", sCriterioBusqueda); alert
Creating a Button to Open a Report based on a criterion
I have a report called All_Jobs_Report with fields like Job_Number, Client, etc..... I have another report called Item_List where Items are added with a look-up field which gets the info from Job_Number field from All_Jobs_Report. Now, in the All_Jobs_Report,
ENTER key triggering Submit
Is it possible to stopped the ENTER key from the mandatory triggering of the Submit button on Creator form? I want forms submitted "ONLY" when the Submit button is pressed.
Retrieving informations from a lookup of a lookup
I have 3 forms linked by lookups: customer linked to subscription which in turn is linked to calendar. In the third form, calendar, I don't have access to the customer name of the first form to use in my deluge scripts. What are the good practices for
change week format?
hi make view in zoho creator take Added Time == This Week system takes all days since sunday how can i tune system take all days since monday for This week? since monday is russian format of week
Have another form in a dialog box loaded from another form instead of new window
Hello, I am trying to attempt a workaround with forms being submitted on the Enter Key. Barcode Scanners usually default to send an Enter Key command after scanning the barcode. While there is ways to configure your scanner to not do that, I want to provide
Next Page