Reports: Custom Layouts > Labels & Buttons
Would be great to offer custom labels and custom buttons (not custom actions) on the Report custom layouts.
How can i make math defined in node js function?
why math not defined here?
Change currency type of currency textbox dynamically
Hello group I have a dropdown box on a form populated with country names from another form. When the user selects a country, I would like to change the currency type of a another currency textbox to show the corresponding currency type associated with the country. Is this possible? Appreciate if you could you give me an example of how to do this! Regards Martin
Change subform name on Creator export report
Hi. Is it possible to change the name of the subform tab? Ex. standard ZC_SUBFORM_90_Report to ZC_SUBFORM_Hotels_Report.
Upcoming Updates - March-April, 2021
Hi all, We will be rolling out the following feature updates: Improving import data in the live application Enhancing print and export settings Providing file preview support to text files in reports Upgrading to v2 of Microsoft Power BI Providing Bulk
Subheaders for Sections in forms
Currently, every form section has a field name, which one can choose to show/hide to the end user. It would be great if there was an option to show a SUB-HEADER in addition to a header. It would be useful for explaining to the end user what the section
Duplicating pivot tables
I've been doing loads of pivot tables recently and have noticed a quirk that might need to be fixed. If you try to duplicate a table with special characters in the title () - & it doesn't duplicate. The main one that causes the problem is & but sometimes
Can i add comments to embedded Record Summary?
I want the users comments to behave as same as in detail view. Thanks
Concatenate text fields
I want to concatenate two text fields so they both appear in a import value list - can someone please tell me the syntax - see below: value= <text1>+" "+<text2> Thanks, Martyn
Joining fields / concatenating
Hi - I have a Product Master form and a Products form. A Product Master can have more then 1 Product - so a Master could be "brown wrapping paper" with a Code of "BWP" and the Product could be "900mm wide" with a Code of "900MM". So I want to allow the user to select a Product Master from a look up list - I know how to do this - and then enter the Code "900MM" and have the Product show the result as "BWP-900MM" I have looked through the help and can't see how to concatenate / join those 2 fields...
combine 2 fields into 1
Hello, Is there a way to combine/merge 2 different fileds into 1 ? example: 1 field - first name: John 2 field - Last name: Lennon I want to get 3 field automatically : John Lennon what is the formula i should use? Thanks, Itai B.
Disable individual multi-select check boxes: with example case
Scenario: I have a list of options for users to select between but I want a "None" option to stand as mutually exclusive to all others. Ideally I would like to disable all other options when None is selected and disable None when any other is selected.
User Generated Reports edit record question
I have created a user permission set called "SuperUser" through the settings-> permission back end. The SuperUser is able to create their own reports, which works fine. But the user wants to be able to click the summary then edit the record/form fro
Creator new user no access
Hello, We created a new user with a completely new created e-mail. Impossible to give access for Creator use. even after an invitation its an error. How is that possible if we didn't reach our limit of paid accounts per month ???? See attachment. There
Record Fetching from Linked Form Based on Lookup Field Value Returns No Result
Form Menu_Master has Menu_Name field, which is looked up in Form Cafe_Order_Entry, in field Select_Menu, within a Sub Form. Selecting a menu name from the drop-down (look up field) in form Cafe_Order_Entry, my goal is to fetch the corresponding Menu_Price
How to do Round Robin assignment of Records in Zoho Creator
Hello, I have two form Contracts Master which had a Unique Contract Number and Request Form where customer has to input their Contract Number and they can select different services. If customer more than one services different records will be created.
Cannot add user on Creator
Hello, After a long time of trying we still don't succeed to add a new member to the CREATOR. How is that possible if we didn't reach our limit of paid accounts per month ???? See attachment. There is always an error when "enabling". But also an error
Disable field on subform row
Hi, Is it currently possible to disable a row item on a subform? I was just trying to do something whereby until another value is entered the field is disable but for the deluge scripting interface threw up an error saying such a function is not supported on a subform. Thanks in advance for your help. Shaheed
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
Conditional formatting based on another field
Hi I have two fields on my form stage 1 complete and stage 1 deadline. I am trying to setup conditional formatting so that if stage 1 complete is after stage 1 deadline the record is highlighted in red. I need both stage 1 complete and stage 1 deadline
Next Page