Report - Grouping and Sum
I have two columns, one is product and another is sum. I want to group product (show one row each product) and sum on other other column. Right now it will still have all rows but grouped by header.
How to add new record template in detailed view
Hi, I am trying to add new record template in the detailed view of report; but i can't found the option Pls help. Thanks and Regards, Sidhant A.
OpenURL for Edit Form
Hi, I've created a button using openURL to the record-edit link. But when the url redirect, the layout of the edit form become very narrow. Is there a way to open in the Zoho's own Iframe, or is there away to open up in the full size form? I have pass
Execute Function on Collection Of Records
Hi, I would like to select the the execution for "Collection of records" but it seems grey out, any idear how can I select this?
How to update a record and canceling the submit of the form?
Hello, I am trying to update a record with the data introduced in a form, but I dont want to create a new entry in te report, only update the entry that exists. I tried checking if the entry exists with On Validate, but if I use "cancel submit", the
OCR e-mail ingested image file
I am looking for a way to add a record to a form through e-mail. This I can handle, but specifically I am looking to add an image to a form through e-mail and then OCR that image file automatically. I can e-mail and add a file, not an image, through
Can I get a deleted published form back?
I mistakenly deleted a published form. I know Support says that getting it "back" isn't possible, but has anyone tried and succeeded? Perhaps a redirect / openURL somewhere, from old to new? Old: https://creatorapp.zohopublic.com/account/app/form-perma/form/oldkey
Queries regarding need to close multiple pop up windows
In zoho creator we have delivery challan form and in report we have print button on click of this we want three copies need to generated so that we use open url function using popup window so that we able to achieve on getting three copies at a time but
toTime function = Convert ISO Time to Date-Time Field (Zoho booking and zoho creator integration)
Hello, I'm trying to integrate zoho booking with zoho create through zoho flow, The problem is that zoho booking give me the start date appointment with ISO format: 2020-11-16T07:00:00+00:00 I'm using to date function to covert in Date-Time field with
subform
Create 2 identical forms, both will have a subform. You have to take file upload field in subform. Transfer data of subform of form 1 to subform of form 2 including files. Can anyone help for this?
Iteration list functions
Hi guys How to iterate list of functions in Zoho creator..? I'm doing student marksheet of each subject pass or fail.....
payment form. How to pay multiple items
Hi, How can I edit they payment form in order to process more than one item? The form automatically generates one item and one quantity field. I rather need a subform to lookup for various items in my catalog application. Then process the payment for those many items... Thanks Luis
Redirects on Mobile After form Submission
Requirement I have a button on a page that opens a popup form When the form is submitted, I need the page to reload Currently, this works on browser but not on Mobile. All articles seem to be referencing #Script code placed in the on add on success of
I want to minimize the space of column in record template
I want to minimize the space of column in record template Please let me know, Thanks and Regards, Sidhant A.
From where i can find the Pages in C5
Hi, in C4, i know the pages how to find ; but the same account we have copied into c5, and i can't found the pages there I want to do some changes in that Page. Pls help. Thanks and Regards, Sidhant A.
The email cannot be added as a Customer because it needs to be added as a User
Hi, We are experiencing issues with adding another portal user. The portal user has the same domain as 22 other users but we cannot seem to add anymore portal users with the same domain. "The email cannot be added as a Customer because it needs to be added as a User. Please contact support@zohocreator.com for further assistance."
Can we change font size of all fields in record template ?
Can we change font size of all fields in record template ? Because before it was A4; but because of more fields , total was missing from the template while we print , then we have choose into A3 paper size , now the spaces of columns are on , Do we have
Restrict Customer Portal Data by Other than Added_User == zoho.loginuser?
Hi, I have almost finished building the main processes in my app. I was led to believe by the documentation that the customer portal would be perfect for enabling customers to view their data in a restricted fashion. That's how it's documented. However, when one goes to utilize this feature you will find out quickly that they are very literal as Customer's can truly only see the data they've entered in your Zoho app (using the default configuration), but none of the data you've added for them! This
Can not filter List View via ID
@ZOHO Creator Support Team: While doing some experiments, I found that while I can do this ... http://creator.zoho.com/scriptedlogic/myApp/#View:myListView?Country=Kenya ... and get ZOHO Creator to display the View with just the record with matching Country field value ... I can not do ... http://creator.zoho.com/scriptedlogic/myApp/#View:myListView?ID=xxxx9000000123yyyy ... xxxx and yyy have been redacted here for privacy reasons ... ZOHO Creator returns ALL records in myView. Was this always so
Permissions Settings - Export ? API ?
Is there any way to get the raw data of what forms/reports/pages are available to different customer permission sets? I have hundreds of forms/reports/pages and about 30 different permissions sets, I'd rather not have to try and manually work through
URL invoke Error
Hi there, I need help. I'm getting an error. "Given index 0 is greater than the list size Line:(18)" Essentially I'm trying to Get a user, and then update the same user. The list is to iterate through a list of users I have. Help appreciated! payload
Community-driven poll for feature requests
How many of my fellow forum users are interested in having a community-driven poll for feature requests? Something far more useful to understand and easier to use than manually +1'ing topics? For example: a polling system that breaks out poll topics by:
Change filename in export pdf
It is possible to export to pdf by changing the file name both for users and for the customer portal without publishing the report. For users it can be done by setting a custom action but I don't know how to do it for the customer portal without publishing
Sync from production to development
Hi, I've accidentally delete a page in my Creator development environment. It's deployed correctly in Stage and Production. How can I restore it in development? Thanks, Aaron
Learn Try Catch
Hi, I am just starting learning Script Deluge. I am taking the course "Learn Deluge" and i got stock here. can somebody help me?
Are there try catch statements in deluge?
How can I catch errors? I'm using this script: void googlemap.getLatitudeAndLongitudeMap(providers provider) { /*address = provider.Full_Address; latandlngXml = getUrl("http://maps.google.com/maps/api/geocode/xml?address=" + address + "&sensor=true"); // Retriving xml containing latitude and langitude xml if ((latandlngXml).length() > 0) { latitude = latandlngXml.executeXPath("/GeocodeResponse/result/geometry/location/lat/text()"); longitude = latandlngXml.executeXPath("/GeocodeResponse/result/geometry/location/lng/text()");
Possible Use Case for Zoho Creator: eBook App / Offline Website?
Hi Zoho Creator Team, Please confirm if you have any resources describing how Zoho Creator could be used to create a book app / offline website? We have a book website (www.agribook.co.za) which we would like farmers to be able to access while offline,
Shared Data - Developed App for Multiple Clients
Hi, I am currently designing an industry-specific app that I would like to sell to multiple clients. I was thinking of creating a single app (or DB) that has all vendors in it and uses it between all clients. This way I didn't have to populate each deployed
Copy data from one subform to another subform in a different mainform
I have two sub forms in different main form. I want to fetch all the subform rows from one subform to second subform. Thanks in advance.
Total when deleting subform row
I have a subform which contain a field 'SubAmount' ,which gets summed to 'Amount' in the main form. Is there a way for the parent form 'Amount' total to update after a sub form row has been removed, but before the main form has been submitted? I've tried this "On Delete Row", but it doesn't seem to be working. delete from Washpack_SubAmount[ ID == row.ID ]; grandTotal = 0.0; for each item in SubAmount { if (item.SubAmount != null) { grandTotal = (grandTotal + item.SubAmount);
Custom Layouts problems
Recently the custom layout for mobile and tablet have stopped being applied in some reports. Attempting to make changes to the custom layouts for mobile and tablet have no effect. Can you check this please!
Zoho Creator lookup field data transfered to Zoho Forms form
Hi guys, Struggling with this but I have a form in Zoho creator with a lookup to the ID which works great within the app. Trouble is I need my form to be a bit more child friendly and Zoho Forms offers this in the picture options that it has. I have now
How powerful is Zoho Deluge combined with Zoho Creator to develop complex apps?
Hi! I am trying to understand how powerful are Deluge and Creator to build new software. Let's say you want to build a complex application like an ERP (obviously this is just an example). Are Deluge and Creator capable of achieving this? I wonder if Deluge
Amount Display
Hi, Is it possible format amount display like "1,123,123.00" rather "1123123.00". It is hard to recognize Long number. Thanks for your great work. Ming zhumingca
The Zoho Creator 6 - 100Rails Manifesto
Hi Folks I thought if I DON'T ask I will never get , so below is a list of FEATURES or FEATURE CHANGES that I have been thinking about for a while with ZC 5 that I wish were being included. I have listed below some areas that I think need rethinking: SECURITY needs standardising on Profiles that can be SHARED and new users INVITED programmatically. Do NOT tie menu sections to security. Improve the profiles with deluge commands. USER INTERFACE needs improving for Developers as the number of clicks
Run a script on a date range
Greetings all.... I need to write a script that runs on a range of dates. I understand how to use the for each record and for each list value but I can't figure out how to iterate a script based on a date range. For example: The user enters a start date and end date... The script runs a series of actions (if then statements) based upon each date in the date range. Thanks in advance for any help you can offer. Joel
Subform fields width
Hello, I write several times about this problem, and understand that you have your roadmap of developing but... In subforms, we can't control width of fields. Sometimes it's critical - for example, lookups fields, when displaying text is wide. It's very hard to find your value, especally when values a very similar in start. Some time ago, we have ability to use some css tricks and use "notes" field in form with this SubForm where I write something like this: <style> div[...some css selector to select
Relating two Lookup fields and making them dynamic
Hello, I am trying to find a solution on how can I relate two lookup fields and how can I dynamically change the values of one lookup field on the basis of the choices made in another lookup field related to it. For example, I have two lookup fields;
Zoho creator Page Break
So I recently started using Zoho creator, I want to make a Multi-page Form, but I can't seem to find the page breaker according to: https://help.zoho.com/portal/en/kb/forms/user-guide/form-building-tools/multi-page-forms/articles/multi-page-forms#Cr
Can you format Formula field results at all?
I have a formula field that divides one number by another and produces a percentage. Except it displays as a decimal i.e. 0.666 instead of 66%. Is it possible to apply formatting to the result to make it display as a percentage? I have seen an old post
Next Page