on integration zoho creator to zoho books for transfer the data creator to books in items module , how to push the unit field (lookup) data(name) zoho creator to zoho books in (Unit field) . Pleas
Resolve soon
Get a random record
With the introduction of randomNumber() fetching a random record is as easy as: //fetch records myRecord = My_Form[ID != 0]; //check if records exist if myRecord.count() > 0 { //get ID list idList = myRecord.ID.getall(); //fetch random record randomRecord = My_Form[ID = idList.get(randomNumber(idList.size() -1))]; }
How to get data from certain fields in one form to another form
Hi my query may sound simple but it is stumping me! I have several forms one of which is called the 'organisation mastersheet'. In this form I have a column named 'organiser name' and in each 'organiser name' record I want data to appear from a seperate form called 'organiser management' (contact name, email and telephone number) instantly as it has been fed into the organiser management' form. So when entering the name, email and telephone in to the 'organisation management' form when I switch to
Here's how to set a numeric field to null or to blank
I'm not sure this tip is discussed anywhere, so I thought I'd share it. When a form has a numeric field, it initially is blank (assuming you have not given it a default value). However at runtime, once you give it a value, you are not able to clear the field again.with a script unless you click the reset button or reload the form. Unfortunately, that will clear all the fields in the form, not just the one field. Although you can compare the value of a numeric field to null, you cannot assign a
Invoke.Function
Examples of how to use Invoke.Function
How do I connect Zoho creator Product Catalogue app to my Zoho Books ?
Hi I have around 200 products (items) in my Zoho books. How do I sync these to Zoho creator Product Catalogue app? I don't want to use export and import using .csv, .xls file as its won't sync the images and also I don't want to keep manually do it each
Expression Help
Hello, I'm trying to work within the expression editor in ZOHO Creator. I have a field that currently is populated to say Valid or Expired depending on whether or not the date is after the current date. That looks like this, IF(NCIC_Expiration_Date >
Accessing the values in a dropdown or lookup field in a page script
Hi How can I access, in an html page script, the values (not the records) that exist in either a dropdown or a lookup field? I want to store these values as a variable in the page script. Thanks Dave
Monitor total of records across apps
Hi guys, The total number of records for all applications is increasing dramatically, is there any proper way for me to monitor this? Including how many records of each table in each app. I remember this can be monitored easily in ZC5.
Multiple criteria in searchRecords
Hi, is it possible to search with multiple criteria in zoho.crm.searchRecords? I have tried several variations of the following without much success. CustomerRecord = zoho.crm.searchRecords("Contacts", "(First Name|=| lee)" && "(Last Name|=| spencer)"); Thanks. Chris
Auto Refresh Zoho Creator Page - Zoho Creator - Reports / Dashboard
#Tips & Trick Sample Code:- <%{ %> <head> <meta http-equiv="refresh" content="05"> </head> <body> <h1>My Website</h1> <p>Some text...</p> </body> <% }%> Paste the entire code in zoho create HTML Dashboard Option Thanks & Regards Piyush Goyal LinkedIn
Input validation phone number
I am trying to find a way to make field constraints for input of a phone number. Example: France (country code 33) local number 0142687984 should be input as 33142687984 and not for example 00331 42687984, 0033 (1) 42687984, +33 1 42 68 79 84 etc basically the number should never start with 0, should not include spaces or signs like + ( ) etc and should have at least 9 digits I have been trying to find a sample for deluge scripting but no success. Please help
How to change chart color
Hi In Creator, when you add a graphic, you can choose a color template, but you can't choose the exact color for each element of the graphic. Is there a way to do this? Thank you :)
How to create an Auto number field?
Is there an easy way to create an auto number field that I can use as my primary key field like I can do in Access database? Why isn't there an option for a number field to auto increment the number and also an option to start at a particular number instead of zero or one? I've suggested this to Zoho support and they said they might add it someday in the future. Maybe if enough of us ask for it then they will. In the mean time, which code do I need to enter to create such a field?
Zoho Creator Form - Google Analytics Code
Hi there, Can you please advise where / how in my Zoho Creator Form workflow i may place a Google Analytics tracking code? I need to track the form submissions as an event in my Google Analytics account. Thanks, Emily
Key Shortcut for New Record
I suggest a control-key combination that acts like the "ADD" button. Bruce "Speedy G" Peaslee The World's Fastest Programmer
Registration forms
Is there a way I can specify that a field on the registration form is required so that the form cannot be submitted when there is no information entered for that field?
Link to an individual record from related block on detail view of another record
Hi, I'm new to Zoho Creator, so excuse the beginner question. I have two forms -- Clients and Staff. I have lookup fields connecting the two forms, so that each Client can have multiple Staff records associated. From the detail view of each, I would like the ability to link to the other. So, if I'm looking at the detail view of Staff #1 and I see that she words for Client A, I would like to be able to click on Client A and go directly to the detail view/page for Client A. I would like for the
IF-THEN write formula
I am having trouble creating a simple IF-THEN statement that will yield a text description of a number field. This is a common Excel formula and it may be easiest to show how I'd write in it Excel: =IF(Number_Field<100,"Under 100",IF(Number_Field=100,"Equal to 100", IF(Number_Field>100,"Over 100"))) This formula looks up the number in Number_Field and writes, in another column, whether that number is "Under 100," "Equal to 100" etc. Is there a way to do this using the built in formula generator
Passing Data about a record through a custom button
I am trying to pass data from the record where the custom button is pressed. Do you pass them through the arguments of the function, but the function is outside and not linked to that particular record. How do you go about doing that? Thank you for your help
Can't change the width for the Notes field
Hi there, We have a long description at the top and it's going full-width, which is causing a large area of white space on the right side of the form. Is there an easy way to change the width of the Notes field within Zoho Creator forms? I was able to change the labels to be 300px, however, that isn't applying to the Notes field. I tried adding a table width, however, it seems to be getting stripped out. Thanks!
Dynamically populate drop down based on selection of previous record
Hi, I would like to populate a drop down based on the selection in the previous data. For example there are three drop down Country, State, City. Based on the selection made in the "Drop down Country" "Drop down State" should display only states for the country selected "Drop down City" should display only cities for the state selected How can this be achieved?
Custom Buttons in Stateless forms - how to bypass form validation criteria
Hi I have a number of stateless forms that have mandatory fields which are required to perform an action (e.g. insert records into another form or send an email) I want to create a custom cancel button with the only action: openUrl("#Script:dialog.close", "same window"); However, when I click this button, I'm prompted to fill in all of the required fields on the form. Of course I want to be prompted to fill in the required fields if I'm clicking my 'Submit' or 'send mail' button, but - how can I
How to navigate to particular section based on selection of radio input
Hello, I'm trying to migrate my system from Google Forms to Zoho creator. In Google Forms there is a feature where in we can navigate to a particular section based on the value selected in radio input. It's called "multiple choice" in Google Forms. How
Add/Remove Drop Down Items
Are we able to add/remove drop down items via script? I do not want to make a Lookup field, but simply be able to add an item to an existing drop down field upon user input. This is most likely a beginner question, but every time I look for the solution I can only find Lookup field tutorials, so thank you for your patience. Please let me know if this is possible! Thank you in advance!
Filter a lookup field based upon selection done in another lookup field in the same form
Hi, I would like to implement the same behaviour that I see in the application "Order Management 4.0" already available as a template. I'm referring especially to the form "New Product" in which the user selects the "business Group" item and according to this choice the "Product Group" field is filtered. How is it implemented? I tried to reproduce that behaviour without success. Thanks
Newbie question about printing HTML view
Hi, Thanks to your help, I have managed to create a HTML view with data from my forms. Can someone tell me please, how do I print what I have produced on the HTML view onto A5 paper and can I print automatically when the HTML view loads. Thanks
Showing data in an HTML table in real time
I have a dashboard which has a stateless form with a notes field in it. The notes field is outputting an HTML table which is fetching data from a regular form. I wanted the table to show data in real time, without having to manually refresh the tab or
How to Hide Or Show Submit Button But NOT Disable the Alert Button
I'm sure this has been posted before, but I found a follow up way to hide or show specific buttons and KEEP the Alert Button Working Fine. (this is based on the info I found on the below website so thanks for the user who added this) All this does is adjust the CSS or Style of parts of your form. In this case the Buttons. The website it worth looking at as my idea just builds on this: https://infitarit.com/2019/03/28/how-to-disable-or-hide-submit-or-reset-button-in-zoho-creator-form/ As an extension
Create hierarchy chart?
Is it possible to create a organizational chart based upon records in Creator? I would like to do this using a "Manager" field.
multi-select fields and report builder
Hello, Is there a work around (via deluge script or else) to allow data in multi-select fields be grouped or filtered in the report builder? We have activities that are participated by multiple participants that we input via look up -multi-select fields. We need to make a monthly report for each of the participant vis-a-vis the collective activities they have participated. How can we do this here? Its a feature we commonly used at dabbledb. Thanks, Edith
filter in Reports with "Search and Auto-Complete" ability
It will be perfect, if users can use search and autocomplete (as for Lookup fields in Forms) in Filters in Report headers
Zoho Creator Subform horizontal space/ appearance
in Zoho Creator I have a subform that will show or hide depending on the task selected by the user in the main form. However it looks terrible because on load, the subform shows fields horizontally and this spreads out a lot wider than I would like. ie.
Lookup fields and self referencing tables.
Is there any reason why using a Lookup field to select a record from the same table doesn't work? For a CMS system, I wish to create a hierarchy of web pages where sub-pages 'point' to their parent page which itself is a child page of another parent page etc. I don't want to limit the number of levels that the web site requires. The most structured way of pointing to another page is to use a Lookup field for the ID of that page. I have tried to do this put the field doesn't appear in the form. Does
How to style a form using CSS
I put my programmer on this task and they found a solution. Using your browser's Inspect feature, get the CSS classes of both the <label> and <span> of any element you want to style in your form. Create a page. Embed the form in the page. Add an HTML
Export a subform, row by row?
Is there any way to be able to export the fields of a subform, row by row? This seems like a basic function, and its made it exceedingly difficult to get anything out of the data i have because its in subform rows. Exporting it puts all rows in one excel
Zoho Creator Save Drafts or Tricks
Hi, I would like to ask if there's a way to increase the number of saved drafts or is their other way to do like how this drafts do? TIA : )
Data Dictionary code
FYI: void Utilities.Data_Dictionary() { // the following code INFOs tab-delimited form and field info for analysis in a Google or Zoho Sheet or Excel // "allcreatorscopes" is an internal connection that has access to all Creator scopes // // the delimiter
Calculate Hours Minutes Sec in Zoho Creator Using Deluge
check_In = "8-Aug-2023 10:00:00".toDateTime().toLong(); checkout = "8-Aug-2023 18:00:00".toDateTime().toLong(); //difference = start.timeBetween(end); check_In = "8-Aug-2023 17:56:50".toDateTime().toLong(); checkout = "8-Aug-2023 18:00:00".toDateTime().toLong();
How to make text larger in an Export to PDF?
I am exporting monthly reports to a PDF (from Creator) and can't make the text large enough for my manager to read. It is fine when looking at it on the screen but she wants to have a printed version. Is there a workaround for this issue? I attached an example report so you can see the size.
Next Page