Unhelpful Error message that could worry portal using clients
In my subform that is in list view I want to show and hide a simple field based on a boolean and it does work nicely and simply. if (row.boolean == "Yes") { show row.thing; } else { hide row.thing; } However if the user has toggled the radio choice and
Pop up error message window for functions
Sorry if this has been posted before, but I can't seem to find the answer. I have set up a button on each record of a view, when the user clicks the button a function is called to send an email. In the function, before the email is sent, it checks all the required info is present. If it is NOT present, all I want to do is show a message "Please enter missing info and then try again" and then exit the function. Seems simple, but I can't figure how to show the message.
BUG?? Search in Page can pass only the Search
Hi, Since the page variables and scripts update, when searching with the Search component in the page, we can pass only the search string to the "Target Page" (Attached Screenshot) For me, it makes the Search component useless. Is it BUG or another step
Subtracting a value from another form
Hi, I have a form called performances which has 3 numerical fields: Number_of_Tickets_Available Number_of_Tickets_Allocated Tickets_Remaining I have another form called Tickets_Allocated. This form pulls the values of the three numerical fields from the
Zoho Creator - [Free Webinar] Creator Tech Connect - Release Update Series - Part 1 - 2023
Hello Everyone, What is Creator's Tech Connect Release Update Series? Regular updates to the product improve the overall performance and functionality of the platform. As a result, using Creator becomes easier and more efficient for businesses of all
Does anyone know any workaround how to use javascript to published pages ?
Does anyone know any workaround how to use javascript to published pages ?
Populating a form field from a report button
Hello, I have a form report that has a list of coach companies, and a column that enables users to add a review by clicking a button. (See below): There is an 'Add a Review' button on every line (next to each coach company. When the user clicks add a
If statement not working?
Hey guys, I have a if/else statement which works on the first 2 criteria in green (150mm Adjustment and 100mm Adjustment), but fails on the last when no criteria has been met. I must be missing something very simple. Can anybody help me please? It will
(Deluge) Filtering fetched records
I am trying to create a script that checks the status of the zoho sign document where the field waiver_status equals sent, unopened or viewed. We have thousands of records so I was trying to filter the fetched records but it is telling me I cannot and
Creator Portal - Execute Deluge script on successful SSO Login
Is there an event that can be captured during the Portal SSO login process on the successful SSO login? I know I can create a Creator Portal user/adjust a user's permissions via Deluge but, is there an event that fires on successful SSO login that will
alignment in forms
Hi there, I have two questions: 1. In a form, how can I align checkboxes to the left margin? 2. Is there a way to force a single or multiple line text field to appear below the label? The form I'm talking about is http://creator.zoho.com/kimschotanus/intas-projects-coordinators-and-team-leaders/form/50/
Error when exporting the Canvas Detail View in Creator 5
When I attempt to export a custom canvas detail view layout, the file does not export as a JSON. Is anyone else experiencing this issue? I have requested help from support but still no solution to issue
Zoho Creator Calendar view
Is there any way of sorting a list of items on a given day in Calendar view to display in alphabetical order?
Configuring sendmail to use variable record templates
I have code working nicely to send offer letters to applicants from Uganda: sendmail [ from :sender_text to :application_record.Email cc:application_record.Email2,application_record.Allocated_to.Email reply to :zoho.loginuserid subject :"Offer of tools,
Send email notification to added employees when a record is added to a multiselect-lookup field
Hello, I'm using Zoho Creator to keep tracks of who's responsible for each Function in the company. Here's an example of a "Function" record: Function name = Invoicing Main owner(s) = John Doe Substitute owner(s) = Amanda Lear, David Bowie Where: Function
multi-select fields and report builder
Hello, Is there a work around (via deluge script or else) to allow data in multi-select fields be grouped or filtered in the report builder? We have activities that are participated by multiple participants that we input via look up -multi-select fields. We need to make a monthly report for each of the participant vis-a-vis the collective activities they have participated. How can we do this here? Its a feature we commonly used at dabbledb. Thanks, Edith
Add suffix to a field value in detail view
I'd like to show the unit of measurement of a field in the detail view of a record like this (the red "mm" text): I searched for a solution but couldn't find any. Is there a way to do this?
Enable report button based on the current user role
Greetings i have a report that contains action buttons, i want these buttons to appear as enabled only when the current logged in user has a certain role, for example only CEO role users will be able to use this button. but when setting the conditions
How can a published page (permalink) show up as a pop up window
Hi. Is there a way for a published page (user access the page using permalink) to appear in a pop up window? Apprently zc_loadIn does not work on external link, like the permalink for a published page. How will I be able to redirect user from a zoho creator
Useless scroll bars with no space to scroll need to disappear
Check out the scroll bars on the right and bottom of the image. The one on the right moves the view about 1 line and there is no reason for it being there since there's another one in the pivot table that actually works. The one on the bottom hardly moves
Calculate Price based on duration and extract business hour and out of business hours.
Hello Everyone, I’m looking for some advices on how to or help to code from you. Let me introduce my request, i have an app in Zoho creator i use to track my interventions and make invoicing at the end of the month it’s a app I made myself and I’m not
I would like to keep a record every time my item gets modified in my Inventory Report
In my Zoho Creator, I currently have an inventory report that gets populated from my Receiving form. The items need to pass through a sorting form where their Container numbers/types/materials/etc may change during this process. I would like to have an
Deluge statement execution limit
Hi I try to use a function iterate all records (about 10,000 records) and revise some fields Here is the error message I got "The number of deluge statement execution limit exceeded the maximum limit." Is there any way I can easily to do the batch revise over all records Thanks Regards, Matthew
Formula Field - How to count number of specific weekdays between two dates?
I'm using a formula field in a Request Time Off form to determine how many work days a person will miss if their request is approved. This part of the formula works fine using the workDaysBetween function. However, I want to determine how many regular
Zoho Creator - [Free Webinar]Learning Table Series for Hospitality
Hello Everyone! For the month of November - Bringing on to your table - Zoho Creator for Hospitality 12 Months 12 Industries Hospitality Industry The essence of hospitality lies in creating a warm and welcoming atmosphere, where guests or customers feel
Zoho Creator to GMAIL API Setup - Where Do I Begin?
Does anyone know how to connect Zoho Creator to Google Workspace (Specifically GMAIL?) We have FLOW setup and working fine to send emails via GMAIL, but Flow doesn't accept file attachments which is a major problem. So, we need to be able to send an email
Note field does not show value on mobile app
Hi there, has anyone noticed that the Note field no longer shows value on the mobile app? I am using the latest version 6.13.8 for Android.
How can I submit a form through deluge?
I have a form that has records which include information on each unique product we sell. Each of these products have their information updated frequently, and thus need new reports printed out each time they're updated. Currently we have to edit the record, submit the update, reopen the record, and click the link that sends us to the report to print. Is there a way that I can click a decision box, have everything in the form update, and then have an openURL pull up the report with updated information
Help !!!!
Je souhaite réaliser des calculs sur les montants de ma table 'table_faits' en les multipliant par les coefficients correspondants. Cependant, il est essentiel que cela soit fait de manière séquentielle, en commençant par un type de mouvement spécifique,
Zml formating for mobile view
Hi, I've got a zml snippet with about 8 elements consisting of panels and charts. When in mobile view the charts and panels don't dynamically move to make it mobile friendly like they do when you just have the drag and drop elements. I've tried to make
How can I pass the zoho.currenttime to a Zoho Creator Date Time field from Zoho CRM
Hello guys, Maybe it is an easy question but whatever way I am trying to use I always get an "Please enter a valid date time format". I would like to pass somehow the Current Date/time from a zoho crm function to a date/time field in creator like the
Check if every field has been filled in.
In my form I want to check if all fields are filled in and if so, set the value of a decision field (Info_compleet) to true. If there is any field that's empty, I want that Info_compleet to be set to false. Info_compleet, together with another decision
Limits of images file in per record
Hi Community, Could you help me out with this. Is there a limit on the number of image files per record in Zoho Creator? Regards, Utkarsha Gupta
Multi tenant in Zoho
Can I do multi tenant in Zoho and add subscribers to use my zoho with a diffrent permissions?
filter in Reports with "Search and Auto-Complete" ability
It will be perfect, if users can use search and autocomplete (as for Lookup fields in Forms) in Filters in Report headers
Canvas Scroll Bars Query - How To Hide Them?
I've just started playing with Zoho Creator's Canvas Feature to create a Job overview screen. Can anyone advise how to get rid of the scroll bars on the table/subform inserts? I've tried reducing the number of fields shown, adjusted width of various containers,
Built in Search, Last n Days not including Today
I'm seeing a strange behavior using the built in search option on date fields. This is a field that I populate through the Zoho API. If I choose any of the available "Last n days" date range functions, i.e. Last 7 days, Last 30 days, the view does not include records with today's date. The "Today" option returns today's records. The field uses the following format: yy-mm-dd hh:mm:ss I have not tested other formats to see if it is specific to this one. Update: After looking at the code zoho generates
Page embedded report "Add Record" button
A fundamental need is to embed a report in a page and add records to this report. When pressing the + button on the embedded report the form size is limited to the report size, which can significantly reduce the user experience. I would appreciate if
Update subform dropdown field choices - on load workflow
Hi, I have a "Check In" form that has "Contacts" subform and a "Tickets" subform. When the form is loaded, I want to populate one contact and the number of tickets. I want the "Contact" field in the "Tickets" subform to have the choice of "Contacts."
How can we pass the zoho.currenttime form Zoho CRM to Creator date time field
I am trying to pass from a CRM custom function the zoho.currenttime (or the date) to a Zoho Creator date/time field. I have written multiple ways but I always get "Please Enter a valid date/time for the field" I have written ways like for example EndDateTime
Next Page