Emailed links vanishing
Does anyone else get complaints from some of their portal users that emails are losing links? This is happening on really core emails like password resets. Most users will receive a perfectly good link, but some just see plain text instead. And when
Using dropdown append and add functions on a dropdown field inside a dynamically generated subform row
Greetings i'm working on a subform where i will create rows dynamically and assign them values on form load. i also want to assign choices dynamically to the dropdown menus of each generated row. the issue is when i try to access the :ui of the dynamically
Zoho Creator Upcoming Updates — March 2023
Hello all! Zoho Creator continues to rapidly develop new features and functionalities to help you solve your business challenges. We'll never cease working to amaze you with incredible new updates. And today, we're announcing a neat range of features
ZOHO Upgrade - What a mess
Since you Upgraded us automatically nothing has worked correctly. Our developer has contacted you several times but to no avail. Therefore, we have developed our own system and are cancelling our subscription. It was a great product but, as far as we are concerned, your auto upgrade is a real mess. Maybe you should, like all other software suppliers, offered the upgrade but not made it automatic. Anthony Gemmill - CEO Imagic (UK) Ltd.
Filtering for Date Field
I am wanting to create a filter so I can filter by day of the month, rather than filtering for the whole month. For example, if I have data input on 22-Jun-2007, I want to be able to filter on just this specific day. Any suggestions?
Convert Date field DD-MMM-YYYY to DD-MM-YYYY
I cant seem to figure out how to change a date field in the format DD-MMM-YYYY to the format YYYY-MM-DD I understand i need to use string and date functions but still cannot quite get it right. Any help? Thanks
Formula field to output a percentage
I added a formula field to my form that I would like to have the output be a percentage rather than a decimal. what script can I write for this to occur?
Access registered Zoho People user data from script in Creator
I am working on an app in Creator that would allow for employees to submit tickets for manger review and designation to various departments. I want to have only the "manager reviewed" tickets to be viewable by employees in the departments designated my
User ID based data filter
I want a function similar to the ZCRM, Owner-based data filter is the standard functionality in CRM right? Similar to that each line of data has a "User Email ID" field, the code needs to fetch the logged user email ID and filter the "User Email ID" column
Creator Map Report: Latitude and Longitude
Hello. I have a form named Add_Property. Within that form we have an Address Field named Address (see image). The problem is that all of the properties being entered are not getting the correct Latitude and Longitude for the Map Report. In the photo,
Zoho Creator - [Free Webinar] Learning Table Series for NGO
Hello everyone! The most pivotal part of building any application is to understand the industry, business operations and standard features/functionalities that are required to get the operations going. Industry is the key here and every feature that we
Zoho Subscription Pricing
Greetings everyone, We have a deep appreciation for all the remarkable Zoho products, and we take great pride in our partnership with Zoho. However, we have encountered a significant challenge concerning the pricing of Zoho subscriptions, which has resulted
Related record count in Creator
Excuse me if this is a very basic question. I have tried to find it in the docs and forums but I didn't see anything. Can I have a field in Zoho Creator that counts the number of related records in a different table? If each record in table A has a lookup
Creator: Page Parameters Help
I need help understanding Page Parameters and making a lookup page for records specific to the lookup field. I made 1 minute video showing where I'm stuck: https://www.loom.com/share/7f905f0ec09146ad979f5d6a2a4f7051 *I've tried duplicating examples in
URL is no longer available when needing to export view without login
Previously, this was working fine. However, today when I try to export a private view using CSV feed, the link to enable "To access the view without login" is no longer visible. See below.
Scheduled Report - Pivot Table as XLS Attachment
Hi Guys, I was wondering if anyone had a workaround to this problem I am having. Currently, pivot table reports are only allowed as PDF attachments when added as an attachment in the SendMail function (https://www.zoho.com/deluge/help/misc-statements/send-mail.html).
Creator: How to fetch images attached to a record
Our technicians submit a Form before and after each job they work (see attached Form). Once the form is submitted, I want to do other things with the attached items. How can I make workflows with the attached items upon submit of the form? Can someone
Produce application url to be common for all the Creator application Stages
I am trying to develop an application using the 3 environments steps like development, stage, production. I am trying to pass in a variable url like which redirects to a Report inside the application URL = "https://creatorapp.zoho.eu/insurancemarket/environment/development/all/#Report:Sign_Up_Form_Report"
Google url Shortning API call with Deluge
I am attempting to shorten an url using the Google url Shortning API. However the scripting is returning an error Below is how I have scripted the API call in deluge: headerMap = {"Content-type" : "application/json"}; requestBody = {"longUrl":"http://www.google.com"}; response11 = postUrl("https://www.googleapis.com/urlshortener/v1/url?key=AIzaSyCXSvaYtT2Yr3TxKcesN9OU2FXNVvzM3tQ",requestBody , headerMap,false); Here is the error return in the response: {"responseCode":"400","responseText":"The request
Dynamic Drop Down Population
I have found this useful and assume others will as well. For this activity, I have a form that allows the user to select a sport, which is a lookup field to my sports form. Once a sport is selected, I have two drop down fields that are for event types
Email data to a form
Hey everyone, I set this up per the instructions here: https://www.zoho.com/creator/newhelp/forms/email-data.html The emails are not generating records in Zoho Creator. I BCC'd the "Form Email Address" when sending the test email. My test email is a
Creator Subforms: How to loop through subform and calculate sum total of timestamps?
We have a subform that tracks Clock-In/Clock-Out for our service technicians. One of the fields in the subform (Job_Time) calculates the difference between the Clock-In Time and the Clock-Out Time, leaving it in minutes format, see attached image. How
How To Get The Data From One Form To Another Form
EX ; 1.I have enter details in Powerreading From 2. when i open report and i enter data values and dropdown values then autoplate next two fields 3. can help me 4. Add Attached Both Form Also can check it and tell me
New version
Plz admin long time we used the old version plz bring us new taste of invoice 🙂 we 💞Zoho app.
Convert an integer to a formatted currency string for use in an html page
TL;DR - the deluge custom scripts below can convert a plain integer into a currency-formatted string, i.e. convert -12345678 to ($12,345,678) or 12345678 to $12,345,678 --------------------------------------------------------------------------------------------------- hey there fellow zoho community members! i have been developing custom html pages for my apps in zoho creator and came across the challenge of formatting integers into nice and clean currency values. i struggled with this for awhile
Remove Heading of Subform
can we hide /remove heading of subform while loading?
Find all code associated with a field
One very helpful thing when deleting a field in a form is Zoho's alert messages to tell you exactly what code is associated with that field and where it is. Is there a way of doing this when NOT deleting a field? When I'm making changes to a field (e.g.
Hide values in a lookup field for non-logged in users.
Hi all. I have a form that contains a lookup field. Let's call the form "Booking form". The lookup field is called "Package". Basically, it lets the customer choose the package they want to book. This field is a lookup to another form called "Packages"
View icons need improvements
Does anyone else have an issue where section and view icons are regularly overwritten and have to be reselected? I get it often and it's an irritant. They randomly change back to a computer monitor icon without my input, and I have to keep putting them
HTML Styles in forms
Hi all I just wanted to share something I have found to be useful. I will start with I am not new to Zoho Creator but never have posted. I find the biggest shortcoming of Creator is its look and feel and the lack of control over it. I have spent many
Zoho Creator Map Report: Question about map icon labeling
See attached photo of our test map report in creator. Each one of our records has a field named "Route Order". When I look at the list of records in map view I want the route order, which is a number, to show for each icon on the map. How can I achieve
Approval Workflow Trigger Issue
Hello, I am running a function via a scheduled workflow every month that creates an entry in a form. I have added an approval process to a form but the approval process only runs when I manually enter data into the form and not when a function adds the data using add record deluge script. I am also unable to trigger the approval process from the function using deluge script after I have created the record because the approval workflows are not accessible like the functions are. I can send an email
Rename file uploaded
In a Form, how to rename a file uploaded. Field 1: Name ..............John Field 2: Upload file .......cat.jpg (student assignmement) record: John ........John_cat.jpg Thanks !!!
SHOW DATE & WEEKDAY on SAME LINE in reports
Hi It would be very handy for us, when 'Configuring fields for Web' to be able to show the date as 'Full date AND weekday' We advertise our reports so would be handy to show not only the full date, but the weekday too ie 06-March TUESDAY Thankyou!
Convert Number into Ordinal
Hello Developers, Here is the solution for converting the Number into Ordinal. For Example: This Idea can be used when lets say you are creating the Dashboard where you are showing upcoming celebrations like work Anniversary for you HRMS Application.
Zoho Creator User Group meetups in a city near you!
Greetings from the Zoho Creator team! We're excited to announce that we're hosting a series of Zoho Creator meetups in various cities across Australia. We invite you to join us for an exciting day of learning and fun. Our meetups are a great opportunity
Zoho Creator Open URL Action: Need help auto-populating multiple fields
Please see the code below, it's triggered via Detailed Record View Button. The purpose is to open a separate form via url (popup) and autofill some of the fields with information from the existing record. This code example works great but I cannot get
Integrate Grammar Corrections/Spelling Suggestions
Hi, Often while using Zoho Creator app, people make mistakes while entering text, it would be really helpful if autocorrect/grammar suggestion is made available using Zia in Zoho Creator. Regards, Sushanth
Form Buttons not working when form is opened in some reports but works when opened in others
We have an "Email Quote" then when opened up in any of our quotes reports it allows you to send or resend an email and lets you customize the message. For some reason this morning none of the buttons within that report work. Including a test button i
Stateless Form button of type button triggering validation
I have encountered what seems like a bug with buttons in stateless forms. The button is checking for required fields on the form even though the button is not submitting any data. I would expect a button with type Submit would check for required fields. I would NOT expect a button of type Button to check for required fields. Take the following example: This is a stateless form opened into a popup window from a list view action. Notice the single required field. This form has two buttons. - Submit
Next Page