Hide "Section" headers when using a form as a subform in "List view"
When using a form as a subform and setting the "View Type" to "List View" it is not possible to hide the section headers. This can become an issue if I have a section which is not applicable to this subform and I hide the fields within that section and
OpenURL working Intermittently
Never had this issue before, everything was working fine up to a few days ago. We have a buttons on reports to open forms with pre-filled fields. Now, there are instances where it will throw and error and gives no feedback. What is really strange is not
[Free Webinar] Creator Tech Connect Series - Domains, controls, and security in Zoho Creator using Zoho Directory
Hello Everyone! We welcome you all to the upcoming free webinar on the Creator Tech Connect Series. The Creator Tech Connect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into
Zoho Creator - users "Name" Column
Hi, When you add user to an application inside Zoho Creator, the system generate an account name for it. We don't have the ability to change this name. According to Zoho creator Support (Case:11523656) : "The values displayed under 'Name' column of 'Users & permissions' section, is actually the respective account's username and not the actual name specified on the account. Usernames are system designated based on the account email address and cannot be modified from your end." We need to have the
PDF template setup
Hello, I want to create a list of attendees from an event form that has all attendees listed with a date, not a subform under a perticular event. Each attendee may have more than one record on the same date. My question is should I take the time to create
Help me on idea to create shopfloor on Zoho Creator
Dears, I'd like to ask for your help if you have any ideas for creating the shopfloor layout on Zoho Creator. We are making a Production Tracking System, and we want the shopfloor layouts to show the production order being run at each machine. Any ideas
Embedding a Zoho Learn portal into a Zoho Creator page
Does anyone know how to embed a Zoho Learn portal into a page in a Zoho Creator app please? My portal URL works fine when I just paste it into a new browser window. But when I put it into an HTML snippet in a page, it says it "refused to connect". The
Page Tabs in a Zoho Creator Page
HTML allows for page tabs, as described here in the W3 Schools. I'm trying to get this or something similar working in a Zoho Creator Page. Each tab would have its own dynamic content. Has anyone found a solution that works in Creator C5 ? Thank you!
Change User Portal Picture
Hi, Question: How can a portal user change the profile picture? (see Attachment) Use Case: Portal User can change his picture via a settings form Solution: Create a stateless form with a image field Create workflow When button trigger save image in portal user profile via deluge script Problem: There is no Miscellaneous in deluge for the portal user image How to solve this? Best Regards Marcus
Zoho Creator - Zoho Sign Integration
Hi, I'm creating an order form that allows clients to submit requests for new products or changes to their existing ones, modelled after the Sales Order module in the CRM. When a record is submitted I want to generate a PDF using the record template I've created and upload it to Zoho Sign to be sent for signing, all through Deluge. Zoho Sign isn't a problem, however I can't see in Deluge if it is possible to generate the PDF through a URL. The documentation here provides a URL but it seems to be
Query Regarding Conditional Display in Details View Based on Field
Dear Zoho Support Team, I would like to inquire if it is possible to design the details view in a report conditionally. Specifically, I want to display two types of details based on a field called "Job Source," which is a dropdown field. For example:
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
Determining user device
I need to be able to determine whether the user is accessing the form through a desktop or mobile browser. Is there a way to determine user client? If not, is there a way to read the url of a page using deluge scripting? I know that when a user access the form through a mobile browser, there is a "form-mobile " in the string. The reason I need this functionality is because Zoho Creator only allows the user to take a picture using their camera through mobile browsers, but I need to create the
Image display at the time of upload
I want that when I upload Image in Zoho creator it should display in notes section at the same time
Why are Schedules so Limited? (async data pushing)
Are they just that much more computationally expensive for Zoho to run than normal workflows? I thought they were this magic bullet for having a snappy portal experience for my users but then I realized we're limited to 2400 schedules a month . It had
Allow Admin Execution of Workflows on Restricted Fields
I often use fields updated by workflows and used by deluge functions that help with the functionality of the form, but shouldn't be viewable or editable by any user. I put these fields in an Admin Fields section and hide them on load of the form, but
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
Show response from previous question
I am making a form for employee clock in clock out. The form has only two questions - pick your name, and clock-in or clock-out. Once you pick your name in the first question, I want to be able to show that name when you answer whether you are clocking
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();
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 !=
How can I insert and update field data of a sub-form without adding data into the main form’s mandatory fields.
1. I have a main form that contains a sub-form. I need to update the data of the sub-form from a function, but I am unable to do so. How can I achieve this in Zoho Creator? 2. How can I insert data into a sub-form without inserting data into the mandatory
Formulae field(Sum) not updating when a sub form entry is deleted
Hi there, I was facing this issue wherein I have a main form called 'Work_order_Form' and in that main form I have a sub form called 'Items' and in that items I have a field called 'Print_Charges'. So in my main form I have a formulae field which calculates
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?
Next Page