"Invalid cliet task found" error while filtering Lookup Field values
Hi, I am encountering an error message, "Invalid clist task found," while trying to filter out the lookup values in Zoho Creator. Here is the script I am using: clear input.deploymentDate; availableDates = DeploymentWindows[availableDate> zoho.currentdate].availableDate.getAll();
Zoho Creator On-premise
Hi, Does anyone have experience with On-premise app development using ZC? I can see the documentation here but I can assume there are unwritten limitations and subjects we should be aware of. I would like to hear from your experience. Thanks, Naveh
Embed Report with Auto Height
Hello Developers, When we embed report within Page, we are getting one awesome feature to adjust the report height. "Auto" and "Custom' height. This "Auto" option works well when we have no records. But I want to embed report based on some conditions
How can I filter a field integration?
Hi, I have a field integration from CRM "Products" in a form, and I have three product Categories in CRM. I only need to see Products of a category. Thanks for you answers.
Request for Assistance: Setting Conditions and Calculating Duration in ZOHO CREATOR
Hello ZOHO Creator Team, I am currently working on a project using your platform, and one of the forms I've built includes two fields: Working start Time and working end Time , I would like to set a condition that prevents the user from inputting a Start
Mail Errors
Is there any way to know if there's been an error during the sending process? (i.e the receiver mail doesn't exists)
Consolidate Zoho Creator records to send via email.
I have been trying to figure something out for quite some time now but haven't had any luck. I need to consolidate multiple records from a Zoho Creator form into a single email based on certain criteria. For example, I have a form for which each record
Best way to display API data within a Creator Page?
I'm trying to build a Page that includes: statelessFormA w/ Lookup and text fields, a report view, and a section containing data from an API call. I've got statelessFormA and the report in place and the report is updating based on my inputs in the stateless
OpenUrl Button in Report not working when embedded in Page
I have a reportA with an action button that opens a reportB in a pop-up. It works when using reportA in stand alone mode. But when reportA is embedded via iframe in a Creator Page, the button does not work, I get the "failed to retrieve this report" message.
Unable to obtain LONGITUDE & LATITUDE by using GeoCode Function
Hello, I am creating a Travel App, where customer is booking a Car from his Current Address to Destination Address. By using the Geocode function, I want to confirm the Address is correct and get the longitude and latitude values. However, I am getting
Registration forms
Is there a way I can specify that a field on the registration form is required so that the form cannot be submitted when there is no information entered for that field?
How to get zoho.loginuserid or loginuser in JS SDK Widget in Creator?
I want to use zoho.loginuserid and zoho.loginuser variables inside my JS widget. How to achieve this? Keeping in mind that these 2 are very important variables. Would parsing as parameters be an option?
Like Operator
What exactly is the "Like" operator in the report search options used for? I want to not have to use exact wording when searching a report. For example, if a field contains 1/2" Ash, and I search Ash 1/2", I would like it to still find it. I thought the
how to dynamically upload multiple images for single record?
Is the use of dynamic multiple images in a single record supported? I've searched but have not found the answer. If it is supported, how is it done? I saw 1 suggestion to add a sub-form but that doesn't seem to be the answer. I don't want to add a set number of image fields. Each record would have a different number of images. I want the addition of images to be dynamic. thanks
Add Slider Field for Zoho Creator Forms
Dear Zoho Creator Team, I'm writing to request a new field type for Zoho Creator forms: a Slider field. This functionality currently exists in Zoho Forms, and its integration into Zoho Creator would provide significant benefits for data collection and
Skipping rows with certain empty column fields .csv upload in Creator
Hi, I have a script that parses data from an .csv file upload and pushes the data into a Zoho Creator Form. The script below is supposed to assign "0" value to the empty fields and delete them from the upload if they match the criteria. Unfortunately,
Display comma in number field (thousand separator)
Love Zoho so far! How can I add comma as thousand separator in number field upon input by user? This is essential feature when dealing with larger numbers to make readable. Is there number formatting script for this? For example, change 600000 to 600,000 This link appears to be related to the topic. https://help.zoho.com/portal/en/community/topic/amount-display#2266000001410984
Stateless form on-click of custom button not doing anything, mostly.
Can functions be called on click of custom buttons in stateless forms?? I have: input.note_field = thisapp.function(input.field1,input.field2) and nothing happens, but this very function runs on user input of any other field in the form. I've tried something
Zoho Creator - Extend PowerBI connector to Excel
Hi, The Zoho Creator PowerQuery connector for PowerBI is great. This could be extended to PowerQuery for Excel which would be equally useful. At present I am going Creator -> PowerBI -> Excel and would love to be able to skip the PowerBI layer. Chee
Using Macros to Open URLs
Hi there, Currently, I am trying to use the Macros tool on Desk tickets to provide more information outside of our Zoho Desk environment. Is it possible to open say, a Zoho Creator form from pressing a macro button on the ticket? I've tried using "openURL"
Subform records from one form to another
I have a form “Add Item” (Screenshot attached). I have another form “Purchase Order” which has a subform “Item Details”. “Item code” is a lookup field of “Add Item” form’s “Product code” field We need that when the product code is selected, the code should
Dropdown choices based on selection from another dropdown
I have a form with two dropdown fields. Is there any way that I can have the dropdown choices for the second dropdown field change based on the selection from my first dropdown?
Simple math return wrong result, or I am wrong somewhere?
Guys, please see below, am I wrong somewhere?
Display a Sign-up form on first logon
Hello, I am working on a customer portal and would like to somehow conditionally display a form (can be stateless) to a new user only on their first login or until the complete the form to collect more information about them, which I would then use to
Hot to redirect based on condition
Hi all, i want to redirect to another url based on some logic.how can i acheive this. can any one help Sree
Can you access mobile Cliq app from mobile Creator app?
I'm currently making an edit to the page where someone clicks a name and it takes them to their chat/profile on Cliq. It currently works on browser, but if they were to use the Creator mobile app it opens up it's own browser instead of the Cliq app. Here's
Vertical Continuous Scroll Calendar Report
I'm assuming there's no way to do this, but I thought I'd ask just in case. Is there any want to make a calendar report that has all the months on one page, or like all in line vertically so that I can just scroll through the months instead of having
Collapse/expand groups en report view
Hi! We suggest adding the indicated functionality through a report configuration option when defining grouping criteria. Thanks, Eduardo Santander
Link to an individual record from related block on detail view of another record
Hi, I'm new to Zoho Creator, so excuse the beginner question. I have two forms -- Clients and Staff. I have lookup fields connecting the two forms, so that each Client can have multiple Staff records associated. From the detail view of each, I would like the ability to link to the other. So, if I'm looking at the detail view of Staff #1 and I see that she words for Client A, I would like to be able to click on Client A and go directly to the detail view/page for Client A. I would like for the
Subform of subform in layouts or record template
I have a form that has a subform with parts that also have a subform. Say I have a work order object, with part objects as a subform or lookup, and the parts just have a normal subform non-linked with two fields(operation, and runtime) Work Order ----Part(link)
How calculate total of rows from a subform in the mainform?
Greetings. I would like to calculate the total of the rows from my subform in my mainform. It is a screen to add transactions, so I have: Mainform with three fields: Transaction Type, Transaction Category, Transaction Amount Subform where each row has: Item Description, Item Price, Item Qty I would like that on each row added in the subform the field Transaction Amount in the mainform be updated with the total. Thanks in advance.
Whats the Time out Limit for API Calls from Deluge?
Hi Creator Devs, We are making API calls to third party server via Deluge. Getting this error message: Error at line : 24, The task has been terminated since the API call is taking too long to respond. Please try again after sometime. Whats the default
zoho creator customized report - web print not working gives a blank page
When I try to print from the Custom Report or as pdf it is blank If I use the URL to print same thing
Display Submitted Form Results
Hello, After someone submits a form I would like to immediately display the data that they just submitted so they can print out, etc. I don't want to display all records in the database, just their particular submission. Please help, thank you.
How do I change the size of an image that's fetched via API?
I'm using a Notes field in a form to build a table of API data, including images. Since the size of the image is embeded in the URL that's being fetched, is there a way to resize them? So, I basically have this: tableData = collection(); for each id in
Update Related Records - Need Deluge Assistance
Thank you in Advance. I know enough to be dangerous - and i need help with a Deluge Script. I have two forms that are linked. Client_Details - (One to Many) - Associations I need a way to update specific fields on all of the related Associations when
Add multiple records from another form - deluge help needed
I know enough to be dangerous - thus i can't seem to figure out what i'm doing wrong here on this script. It won't let me save, saying error in line 1. Any help is appreciated for each fetchrec in Client_Details [(Status == "Customer") && (Status == "Pending
Record-Edit view in Page
Hi, I've been looking around but haven't found a solution. I'd like to have a page that displays a record in record-edit mode. I've tried an iframe using the structure below, but the app menu shows. https://app.zohocreator.com/<app_owner_name>/<app_link_name>/#Form:<form_link_name>?recLinkID=<record_ID>&viewLinkName=<report_link_name> I've attached a picture that shows this problem. Any help on this?
Using Zoho Creator Widget JS API with External Widget
Hello everyone, We are willing to use Zoho's Widget to serve an already published external website. The reason we want to use this external link inside a Zoho Widget is to use Zoho Creator Widget JS API to use Zoho itself as a data source for part of
Needing help with coding workflow
I'm not great at coding and haven't been able to get a lot of help. I'm struggling to get this coding right and nobody has been able to solve it yet. I will try to summarize and explain as best as I can. We have a parts form with all of our parts that
Next Page