Adding add ons in workflow
How to add actions while forms are being filled out or while records are being edited or deleted. How to add functions for actions
Advanced Field Search access to modify via Deluge?
Is there a way to access/modify the Advance Field Search pop-up and functionality? Specifically, I want the default criteria to be "Contains" instead of "is". And it would be useful to have multiple sort options for the user, and would also be great to
Limiting Edit Access to a Developer
Hi I need to allow edit access to one of our users for one view only - when I set them up as a Developer and allow edit access they are able to see every field from our original table. I want them to only have edit access to the columns in their view. Is there a way to do this? Thanks MR
Navigation/Tabbing/Arrow Keys & Multi-select Lookups
Is there any way to control how the Tab and arrow keys functions in a form, specifically w/ multi-select Lookups? When using the Tab and arrow keys to navigate and make selections in forms we seem to get stuck on multi-select Lookups - the down arrow
Creator iPad doesn't update field
Hello, We added a new colleague (Agathe Martini) in Zoho Creator. We have created a completely new account with a new email address: agathe.m@beerproject.be As you can see in the attachments, I added in the script that when creating a new visit report
Count Records in javascript
Hello, I'm using a widget on my page, and I need to write the number of fetched records. But the thing is, you can only fetch max 200 records, so I tried to use a loop. The code below is an infinite loop, because the API call never happens. Is this related
Sort Multi-Select Lookup when Lookup table is in a different application.
I think I'm close on this, but it's not quite working. This is my function created in the application containing the table of selections: collection sortfeats() { sortlist = (pressing_features[ID != 0].pressing_features sort by Added_Time asc).getAll();
What UI Improvements are possible on creator?
Hi there, Need help around below UI points: 1) How can we make UI customisations across devices? Example 1 view for Mobile, 1 for laptop browser, 1 for tab, etc 2) To show page tree and help navigation within an application, what can we do to show hyperlinks like HOME --> Main --> Sub Menu --> Current Page 3) If we add images, can we place Buttons around the custom image? If yes, how can we auto scale this image across devices? 4) Can we find Zoho Creator UI Specific developers on the Zoho
How to add string of csv data into new records via collection ?
Hi, I wonder if there is a way to turn a string containing csv values into a format suitable for adding as individual records into a report. This is my example data : Date,Code,Station Name,VALUE 1,VALUE 2,VALUE 3 15-Jul-20,EGAA,StationA,1,10,20 15-Jul-20,EGBB,StationB,2,11,21 15-Jul-20,EGCC,StationC,3,12,22 15-Jul-20,EGCN,StationD,4,13,23 My thought is I need to create a collection and then add the string data to it, then iterate through the collection to add the record. I can see help files for
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
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
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
Next Page