How To Format Phone Numbers
I am completely new with ZOHO I am trying to build a database how can a make it so when a phone number is entered in a form like this:9876543210 it automatically formats it to 987-654-3210 Thank You
Zoho Creator In App Push Notifications
Hi all, i would like to enable In App Push Notification for one of my form, but I don't see any options as mentioned in this help page: Push Notifications | Help - Zoho Creator Did I missed out anything? Any help would be highly appreciated.
Anyway to exit the "for each" loop prematurely? I do it from my gf all the time.
I'm curious if there is a way to exit a "for each" loop before cycling through all elements. For example: records1 = conditions[active == true]; records2 = valid_codes[active == true]; for each r1 in records1 { for each r2 in records2 { if (r1.code == r2.code) { input.code = r1.code; break; -OR- records2 = patients[true == false]; } } }
Finding duplicate entries
Hi, I'd like to know if there is a simple way to identify duplicate entries in a table or database. I looked through the scripts help page but didn't see anything. I'm basically going to be compiling an email list and want to be able to quickly check the list for duplicates. Thank you for your help Love your service!
Creator : Auto Map Address Fields
I'm creating an import template for my employees and want it to be as easy as possible to make sure the fields are already mapped when importing. However no matter what field name I use I can not get the address fields to recognise what is being imported
How can we create an announcement bar in Creator app?
Hello guys, I would like to ask you if there is any way to create an announcement bar in an HTML page in Zoho Creator. Something like this which we receive from the Creator Platform I do not really care if it will have hide-close buttons in the right
Any way to do DOM manipulation with JS on an HTML snippet?
I want to use JavaScript to set event listeners on some elements produced in by HTML snippet written in Deluge. I tried creating a nodeJs function and calling it at the end of the HTML snippet, but when the code runs, I get an error saying the document
Print Detailed View after Form Submission
Hi, Relatively new to Creator but having good success with an orders/customer apps I've just created. I'm using the detailed view of a report to generate our 'order receipts' but would like to make it easier to print the record that has just been submitted.
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
Next Page