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
Adding Subforms in Deluge
Hi I'm trying to add new rows in a subform, but keep getting an error. I have posted unfinished code below, and getting an error at: row1 = Suppliers.SupplierParts(); with Suppliers being the form link name, and SupplierParts being the subform link name.
Rounding values to nearest 500
I have a series of numbers that run from in the tens to the ten thousands. I want to set the following rounding rules: Above 10,000, round to nearest 1,000 Below 10,000 but above 1,000, round to nearest 500 Below 1,000, round to nearest 100 // Work out
Change Subform to Vertical Layout
When I create a form, the fields are set up vertically. But when I use that form as a subform, it makes them one horizontal line. Is there any way to make the subform appear like it does on the editing page?
Cancellation
Hello I have registered for the ZOHO USERS MEET for 12th May, but can't attend due to some emergency issues. Please help me in cancelling my regitration for Mr.Harshvardha Khemani(harshvardhan@oyehappy.com)
Zoho site with dynamic content
Sorry for a newbie question (first time user here). I'm looking to migrate a Mendix project to Zoho Creator. It's a publicly accessible web portal (so looked at Zoho sites too), but the examples I saw were more static content websites - at least at first
Purchase Order can't be created for the non-purchase item
Hi, I tried to create Purchase Order from Zoho Creator to Zoho Books.But I got error as "Purchase Order can't be created for the non-purchase item."I also created the item for this. What was the issue I'm facing?
Customer Log In Times
Is there any way of having access to the last login dates/times for portal users ? I could really do with some idea of when my customers are logging in
Centering a table in a dashboard / Responsive Tables
I have a pivot table spanning roughly 2/3 of a dashboard page (left to right) with a widget next to it on the right. Depending on screen size, my pivot table may have scroll bars (smaller screens) or half of the area for the pivot table may be empty
Count the number of responses in an Invoke URL call
I have a qc function that is comparing data between a report I have in my Zoho Creator app, and that of an API dataset. I am using for each to iterate through a day's records by a unique ID (Appeal_ID) and calling the api by each f these ID's . So far
Zoho Creator and Automation platforms
Hi, I have a requirement to move information form Zoho into Monday.com. I have it working great, but any field that contains files (.PDF,JPEG etc) don't show in any of the automation tools I have tried (Zapier,MAKE, ZOHO FLOW). Am i missing something
Connection between Zoho Creator and CRM impossible
Hello everyone, I am trying to pull contact entries from ZOHO CRM to an application I am trying to build in Creator. Unfortunately, I do not get my entries showing up, I always get "null". Please have a look at my configuration and tell me if I am missing
Display single Record from Zoho CRM in a form based on URL parameter
Hello everyone I need to do the following. I created a form with 3 field . Based on the URL parameter which has the contactIid I need to fetch the specific record and display it in a page. https://creatorapp.zoho.jp/julien_dunes/fetch-it/#Form:OkOK?contactID=987238392832989382
Push notification message limit
Do the <message> has a limit of letters or combination of variables and text limit?
Best method for Logging Time
I'm developing a pretty extensive app and I want to include logging time to specific jobs. I know the method for time tracking in the gallery app is to basically use text. However it is a bit clunky when it comes to summarizing time in reporting and in
Initiate approval workflow after "on edit --> on success"
Dear Community, currently I am working on a initiative tracker which should handle approval workflows based on different initiative status. As far as I understand, an approval workflow can be triggered (only?) when data is entered for the input form to the database. Example: A new initiative is created and submitted. --> Approval Workflow triggered Here comes my question: Is it also possible to trigger an approval workflow if the form was "simply" updated? (on edit --> on success) Imagine the initiative
Images in export spreadsheet
Hi, anyone have idea as I can export images displayed in a view? I can import all data with MSAccess or MSExcel, but images is not displayed (only as a link). I need link my zoho db with a xls or dbaccess to use the data with CardStudio software and print identity cards. Someone have operated with this? Thanks Mic
Problem with the pipes
Hey there, I am trying to fetch data from an API populate it into a drop down. The problem I am having is the data being fetched is separated by pipes. And anything I have tried just puts the whole pipe separated list into the drop down. Exterior_Color:
Is there any way to send message on whatsapp through zoho creator
I have created an app in Zoho Creator as well as I have created required workflow,## Heading ## when to send message. It is working fine if I need to send sms or email. I want to send message directly to my users Whatsapp, How can I do that?
Using for each to iterate through a collection of records and invoke url for each record
I am trying to set up a scheduled function to compare and quality control check between 2 sets of data. One of these is within a creator app that I built, and the other I am calling from a 3rd party API. My planned workflow involves selecting all of the
Can I add a file download section to a client login portal?
Hi. We need to create a client login portal which has a file download section for participants on our training courses. Is it possible to do this in a Zoho Creator App? Can anyone point me in the direction of a tutorial or even better, a prebuilt app that can already do this? (Preferably a free one.) Thanks a lot. Damien.
Increase Image Upload File Size
Currently the limit is only 10mb, it would be great if this could be increased to at least 20mb. It is often requested.
No word wrap in multiline fields in report view
I am sure this worked fine earlier, but now there is no word wrap in multiline fields when displayed in summary and detailed view. I am in the EU server.
How to prevent or adjust Access Token expiration OAuth 2.0
I have built a form in Creator that pulls data from a 3rd party API when a user inputs a unique case number. Upon user input of that field, I have scripted an API call that pulls in corresponding data and auto-populates several other fields in the form.
Next Page