Pivot Tables problem
Hello, I pressed Regenertate on my pivot table report page and now it's stuck for over 2 hours. "Regeneration has been initiated for this report. You will be able to regenerate again when this process is complete" Can you help, please? Thanks,
Reorder a waiting list
Hi guys, I'm new to zoho creator and I'm struggling to find why to reorder a waiting list I have. For example I have these records: Positon, name 1, dave 2, steve 3, bob 4, clive 5, phil What I'd like to be able to do is to move Steve from position 2
Cannot see multiple forms when creating new report
Curious if someone can help explain. I have 3 forms in one of my databases. However, when I try to create a new report, it only lets me pull from one option. Am I missing something?
HTML Snippet - Section that occupies same space but appears based on what is pressed.
Hi, I am fairly new when it comes to working with HTML script. And I know javascript isn't something that works within a HTML Snippet (at least as far as my own experiences go anyway). Something that I need to script in, is a section that appears and
Converting Estimates into Invoices using a report action - Calculating Subtotals
I am trying to create a report action or button to convert my estimate into an invoice. I have everything working up it will not calculate the subtotal and grand total after it is converted. Any help or suggestions would be appreciated! Here is what I
Creator: Using stateless form to pass page parameter
I'm trying to filter a report on a page via the page parameter, but am stuck. I made a 1 minute video below showing the issue: https://www.loom.com/share/35446dcf5ec74f62ae9b49a2e6e7f355 Can anyone see where I'm stuck with this video? Thank you for your
Creator Super admin - Need to deactivate my account.
I am the Super admin in Creator I Need to deactivate my account and give all permissions to another in my company however i cannot change from Super admin. I need to change this today as my billing renews tomorrow.
How to share records
I've created a data sharing rule where one role can share a specific set of data to another role, but I can't see how to actually share an item from the UI and can't find anything in the documentation. How do you share the individual records with another
How to get permanent API Key
Hi, I've read over the API OAuth documentation (https://www.zoho.com/accounts/protocol/oauth/ and https://www.zoho.com/creator/help/api/v2/openapi-specification.html) and see that there's a way to generate client id, client secret, and code here: https://api-console.zoho.com/
DS File Import Error - can't edit the script in the browser
I am unable to edit a DS file in the browser when presented with an error during import. For example: Error at line number: 5896 The "from" address can only be zoho.adminuserid, zoho.loginuserid, or a verified email address. Please specify a valid email
Zoho Creator - [Free Webinar] Learning Table Series for Education
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
Setting fields width in subforms
Hello, Please, add extra parameter for form fields: "width in subforms" Especially it;s important for multiselect lookup fields, as it's not very comfortable to select values from narrow list, or when values text are displayed in several lines of drop-down list Thanks
Html View / iframe help
Hello, I would like to some how use this website https://www.randymajors.org/city-limits-on-google-maps?x=-94.8359213&y=38.7401548&cx=-94.8359213&cy=38.7401548&zoom=17&state=KS&onestate=show&cities=show I was able to input the long & lat in the website
Employee Productivity Percentage
Hi, I am really struggling. I have a form, where our employees fill the data in the screenshot below, date, name, task they are doing [product building], how many they built and how long in total they were doing it. I then have a formula to work out how
Finding Duplicate on a for loop
Hi, I'm trying to find a duplicate on a for loop on an index. but getting error. Please help me x = Employee[ID != null && Status == "Active"];
4 y = Time_Log[Employee.ID == x && T_Date == "14 Jun 2023" && T_Date != null].Employee.Name.getAll();
5
Custom order in subforms
Review this please. Custom order on subforms doesn't work. When the record is saved, changes made to the subform are not saved. Happens in both grid mode and list mode
Creator: How to combine two forms into 1 lookup field?
Form 1: Add_Invoice_Form Form 2: Add_Service_Form Form 3: Add_Material_Form Forms 2 and 3 both have a field within them called "Name". We want to add a lookup field (dropdown) in Form 1 called "Service/Material Name". This lookup field should combine
Scanning not available for Cutomer Portal
Hi all, I have created a small app in Zoho Creator where i have 2 single line elements that support QR and Barcode scanning. If I access the application through the Creator mobile app as a Zoho user, then I am allowed to scan as i get the relative icon
Iconos en Botones de Informes
Hola. A modo de sugerencia para futuras actualizaciones de Zoho Creator (a no ser que ya se pueda y no sé como hacerlo), sería muy interesante que en los BOTONES que podemos crear en un INFORME, en vez de mostrarse un texto identificativo pudiéramos poner
How to open record template in a new tab
Greetings i have a report that i want to add a report action to to open record template of the desired record in a new tab (or popup window), is there a way to do that? thanks
Footer and Page No not taken in Record Templates while send as PDF attachment
Hi team, We have Added Footer and Page no in HTML Page. When we access it on page and make print then it will display. but same code added for Records Template that to send as PDF through email in attachment, but the footer/page no will Not added. How we can do ? because no of pages will be there.
Update related record in Zoho Creator
Sorry if this is an obvious question, I'm starting to work with Creator and there are things I don't understand in the docs. I have two related forms. Each record in form B has a field to connect it to a record in form A. The relationship is one-to-many:
Restricting Calendar View to Working Hours
Hi: I'm trying to implement a calendar which displays all of my customer appointments. Currently, the calendar shows all 24 hours of the day. Is there a way to restrict the hours to simply the times my business is open? Thanks!
Zapier integration Name Field
Hi, I've done plenty of integrations from Webflow to Zoho Creator in the past but i'm struggling with this one. I have a form in my Webflow site which captures First Name in one field, and Last Name in another field. I'm using Zapier to push the data
Showing sub-form records in a approval process
Form A is a purchase order with a sub form containing product items related to Form B. I create a approval process for this Form A. But when I tried to approve the form A others have submitted. I couldn't see the sub form content. It only showed the ID related to the Form B.
How to Start Page or Default Page for Customer Portal
Hello, How can I set the Start Landing Page a Zoho Creator App client portal accessed via mobile? I am currently seeing sections. Thank you!@
Create Multiple Filters for Report Based on Customer Profiles
Hi folks, I am currently building a creator app for order delivery. I have two profiles for the customer portal, Admin and Driver. We have a delivery report to keep track of the delivery. Here is the question: Without duplicating the reports, how can
Fetch data
Hi, I am trying to do the following. I have developed a plant database where I want to create an observation record from a plant record. So when in the plant record I click 'Observe' (Havainnot) which opens the Observe record. I want it to automatically
Set expression for formula field on Zoho Creator
Hi guys, I am stocked with an apparently simple formula that should calculate the time between a “start time” and “end time” fields. Can some one please share some ideas to solve this? The formula field should calculate and show the time in hours and
Zoho Creator Upcoming Updates — May 2023
Hello everyone! We're back with more monthly updates after a short hiatus. During that time, we've been hard at work improving the user experience and adding new features to our platform. Today, we're pleased to announce a wide range of fascinating new
Creator: Calculating and Recalculating Sum of Two Subforms
We have a form with two subforms within it. I’m trying to run a loop through both subforms to calculate the sum total in a field that is separate from both subforms. How can I calculate the sum total of all “Rate” fields within both subforms? Also, I
pop form in a report action buttin to update a filed
Hello i know i am missing a simple thing but can someone help i have this (Update price action button ) in a report named Hold_item with this code inside the workflow openUrl("#Form:Update_Hold_Price?Cartlow_FBS=" + input.ID ,"popup window"); its suppose
Access subform fields from a lookup field in template records
greetings I'm working on a record template for a form where i have a look up field which allows access to a subform in another form, now i want to list that subform fields in a table, but i'm not able to find anyway to access any of the subform fields,
Creator Pages : URL actions in panel using parameters
Is there anyway to set the URL action of a panel to include a page parameter ? I have a parameter of "Sector" so how could I get the following URL to work : https://MYSITE.zohocreatorportal.eu/#Report:all_carbon?sector=Sector I've tried sector=input.sector
Get URL of image uploaded in image field
After several hours I decided to write this topic... I have tried several methods to make it work, but none of them solved the problem... I need to get the URL of an image uploaded in an image field called: "tempImage". I need to retrieve this data in
Zoho Creator Upcoming Updates — June 2023
Hello All! We continuously strive to enhance and improve Zoho Creator with new capabilities. Continuing with this journey, we're excited to share the latest developments and progress with you. Let's dive into the highlights of the month! Portal page customization
Formula Field In Subform
Hi Everyone, Kindly let me know how we can use Formula Field in Sub Form ?
Some Old Fields Appearance
Hi Everyone, It is observed that some fields which are already deleted earlier, but such fields are coming in the list for selection. For better understanding, I am attaching the screenshot for the same where two fields are highlighted with red color
Retrieving Data From Sub Form Of Other Form
Hi All, I would appreciate your help/guidance for the following scenario. 1. There is a "Purchase Order" form where there is a sub form called "PO Detail". 2. "Purchase Order" form have date, party etc. fields whereas "PO Detail" sub form have Item, Quantity,
Updating Feild by itself and code not working on new line on subform
Hello, I created a subform for recording time then I wrote a code like below but this code is working only for 1. row. When I tried to add new record the code doesn't work. Also the field isn't updating by itself. I have to insert random time first the
Next Page