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
[Free Webinar] Learning Table Series - Creator for the Education Industry
Hello Everyone! We welcome you all to the upcoming free webinar - Learning Table Series. 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
How can I import a database App
Hi I need to be able to import an Excel-based price list into my app for processing. I understand that I can create an App based on data imported from an external spreadsheet. I do not wish to do this. Instead, I wish to create a button within the Creator App which, when pressed will allow me to select an Excel file of a predefined format, to import into the Creator Database. I cannot work out how to do this. Please help. John Legg Owner: The Debug Store
why error occur when use lookup code?
why there is an error said PO_Rec.PO_No is type of number form fisrt pic but in 2nd pic i use the same lookup code but error doesn't occur *PO_Rec.PO_No is lookup field from single line
Page iFrame embed
Is there any way to remove the heading bar from a report iFrame embed on a page? Also, is there any way to disable scrolling from side to side?
Published report behavior on website and mobile devices...
We display categorized lists of nonprofits on our website using published reports displayed in iframes. Most reports have a single column and display properly. There are a few reports that are 3 columns (Nonprofit name, category, subcategory). On the
How To Sort List of Maps?
I have the following below; If I return Collection(keyList) at the bottom, keyList is sorted correctly (I've tried both true and false and it works). But when I add to my sortedList in the order of my keyList the sortedList is not sorting how I want -
Exporting Reports as XLSX
When exporting reports as excel, the sheet name in the exported excel file is named after the report link name. Is there a way to rename the sheet on export? My problem is the report link name has_underscores_in_the_name and does not allow for spaces.
Enhanced Drill-Down Functionality in Zoho Creator Applications Usage Report
Dear Zoho Creator Team, I'm writing to request a significant improvement to the Applications Usage report within Zoho Creator. Currently, the report displays various metrics, but it lacks the ability to drill down for deeper insights. Current Limitations:
Limitation of reports on Zoho Projects Integration
I was really excited when I found out that we could integrate our Projects & Prople data into Creator, because we thought it would allow us to use Projects as a datastore but wrap some of our workflows around our work, but we've hit some limitations.
FINALLY! 100% Responsive iFrame for HTML Page Snippet
For the past two years or so I have been battling with Page Snippets' responsiveness (HTML, Embed, and ZML). Furthermore, if you use the native embedded reports, especially more than one report on a page, you have to set a static height because they're
How to add customer details to form when they sign up
I have customers signing up to my application which I then approve or reject. The are inputing their full name and email address. I would like them to then input other details in the Member form that we have like phone number, address, and other details.
Better custom connection interface
Microservices / custom connections are really problematic to use at the moment. To test if they actually work, you need to create it, then enable it (which is a multi-step process), then write a API call in Deluge then call it. You should be able to:
Keyboard Shortcuts
Is there any way to make a keyboard shortcut to add a new record to a report?
The task has been terminated since the API call is taking too long to respond
Hi there, I am using Deluge with invokeurl to make several API calls within a loop. The API calls itself, when using Postman, are done within 2-3 seconds (all togehter). When using Deluge it does take much more time and ends up in "The task has been terminated
How to print a pivot table report (ZC 6)
Greetings, I hope this message finds everyone in good health and safety! I have created a Pivot Table report and it is functioning well. I would like to provide a "print" option for the user, which would load a view allowing the user to configure the
How to Sort a Collection(API data)?
So, I have something like this: versionList = Collection(); for each item in searchUrl.getJson("results") { year= item.getJson("year"); label= item.getJson("label"); catalog= item.getJson("catalog"); versionList.insert(year + label + catalog); } The only
Favicon for each app
I can see in the general company settings that I can set a favicon and a company name. But I need this to be different for all the creator apps I have developed - not just the same icon for all of them https://creator.zoho.eu/userhome/MYACCOUNT/dash
Automatic Incrementing of Field in Form
Hello, I have an application that include a form comprised of several fields in ZOHO CREATOR , I would like the field labeled ORDERID to be automatically filled with a sequential number starting from 1 each time I fill out the form. How can I achieve
Report filter based on form input
I have a page with a form and a report on it. Is there any way, that when I select an input for the dropdown on the form, that the report would only show entries on the report that match the input?
How to fetch data from Stringlist Checkboxes?
Hi team, I need your guidance on Zoho Creator. I have a stringlist called "Activity_Type" and it has 2 checkboxes: "Yes" and "No". I'm writing a Workflow IF condition depending on what the user chose (Yes or No), but the line of code below does not seem
How to get value from subform fields?
Hi all, I can't get or assign value to a subform field when the trigger is on "User input". "Harvested_Line" is a field in the subform. Snippet: lineList = List(); for each record in Lines[Parent_Farm == input.Farm] { lineList.add(record.ID); } row.Harvested_Line:ui.add(lineList);
How to load a Rich Text Field with information that is already formatted as a table?
I am trying to upload information from a subform to be displayed in a Rich Text Field. Ideally, I want the information to be uploaded as a table within the RTF. Is there any way to do this? If not, how do I print the information to the RTF and also have
"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
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
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?
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,
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
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
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
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.
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
Next Page