HTML Templates for PDF reports
Hi, I have been working to create a PDF report for the creator record, I know I can do that using record template but in that particular template, I have to add every single field in order to get the report. Now no matter which field has input and which
Authenticate Firebase App access through Zoho Creator App
Hi there, I have two apps: Zoho Creator (Admin and Portal Users) Firebase Web App Both apps are password protected and user authentication is handled separately to allow users to log in to access data on each app. Currently, I have the Firebase web app
Custom button - design
Is there any way to create a "Custom Button" in a report with an image, icon, specifics colors ?
[BUG] Stateless form custom button doesn't display updated field value
Can anyone reproduce the same bug? // Stateless form - Single line field: Field_1 - Single line field: Field_2 + add custom button "test" // Script On click of "test" input.Field_2 = input.Field_1; alert input.Field_2; // Result alert shows the script
Subform export not filtering to selected fields
Hi, My subform xls export shows all of the fields in the subform instead of the values I selected to display. How can I show only the fields I selected?
Empty fields in a report - how to hide???
Hi - I'm finding it really hard to believe there isn't a simple solution to this, so perhaps someone on here can help. It would be greatly appreciated. I have a large form with many optional fields. Some of these optional fields are single line, others are image fields, whilst others are drop-downs. As they are optional, most of these fields will be left empty; others will have a 'none' value, which for my purposes amounts to the same as an empty field. How can I prevent my report being littered
How to get import option
I am a shared user, how can i get the import option, for uploading the data. Regards Ankur
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
Calculate hours and minutes between two time field
Hi I have following fields - 1. Start Time - Time Field 2. End Time - Time Field 3. Total Hours Worked - Single Line Field I want to calculate End Time LESS Start Time and get output in Total Hours Worked. Please help me. Urgent.
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.
Next Page