How to Make Custom Functions without Getting Errors for Trying to Show/Alert Elements?
Hi, I love using custom functions to prevent code repetition, in most cases it works great, however, in cases where I need to do things like Show or Alert I get errors like "'show' can be used only in on load actions". This necessitates that I have to copy and paste my code over and over as I can not use "show" in the Functions interface (as the compiler does not know where the function will be utilized). Is there anyway to make custom functions that use methods like show and alert? Or is there some
Cannot add/save page
Hi, I'm currently testing/learning Zoho Creator for a potential integration app. I've defined several custom functions and I am trying to call one of them from a Page, like below (using the Script builder feature) <% someVar = thisapp.geopal.returnSomething(); %> ... but when saving, I constantly get the "Error at null" error message. The custom function is simply string geopal.returnSomething() { return "sss"; } What happens in here?
Validate Parent Form Input Before SubForm Row is Added?
Hi, I have inputs in the Parent form which are required to be completed before a SubForm row is added, and the Child record detail is completed. While it's quite trivial to check if the Parent form's input fields are complete or not, I am not certain where to put the script to prevent the SubForm row from being added if the Parent's fields are not complete. The most logical place to me is in the SubForm > On Add Row action, however, I don't know how to stop the row from being added. Is there a method
Run Deluge Script Periodically W/O User Input
Hi, I currently need to identify the most recent child record, I do this by flagging the child record with the most recent date field as relevant (all other children are flagged as unrelevant). This works great when all data is entered through the App's Forms, however, when data is imported the relevant deluge scripts don't fire. This being said, is there anyway to run a script like a daemon script in the background to fix data integrity issues such as this periodically? Essentially, all scripts
Multi-Select Lookup Field
I have a multi-select lookup field. I am trying to write a script to attach to a radius button so if needed all items within that lookup can be selected. However, what I am finding is that when you run the script, only the last item in the lookup is ever populated and selected. this makes sense because for each is being used and it would only print the last item in the list. is there any way to select all items within a multi-select lookup list. for each tempTray in Bench_Rows { input.Bench_Rows.select(tempTray);
Subform - update a field while adding/deleting a row and send these values into another form
Hi, I am using a subform for uploading multiple documents. So In my subform, I have two fields #No,fileupload fields. On adding/delete a row the #no. has to be adjusted accordingly. And also, I have to insert these values into another form. How can I do that?
Placing Image in Lookup
Hi, I have plan to create for visitor application. For that I have created my Employee information. In next form I have placed Lookup for Emp name from employee information form. In my lookup I have to display Emp name with their Image(Photo). But in lookup display fields it doesn't show image filed.Pls suggest idea to solve the issue r idea are welcome.
Report-module in pages: How to search for decision box value / auto-apply custom filter || Report list is cropped
I am using the report module inside a page and I have two questions about that: 1) Is it possible to apply custom filters automatically? I know that I can use the search-function (e. g. Name=abcd) but this doesn't work for decision fields. I have a decision field in the list, let's say it's named "Important". So I have tried to set Important=Yes for checked boxes and Important=No for unchecked boxes. This doesn't have any effect. I have also tried true/false. 2) How to show the complete list without
Don't show "print" button on html pages on mobile
Hi Zoho, On my html pages I've enabled the "Print" button. when browsing through the Zoho app via mobile browser (not mobile Zoho app!) I'd like to hide the "print" button. How can I do this? ( @media screen and (max-width: 640px) { print = false} will not work) Thank you Ravid
Display Image depends value select in lookup
I Have a form Product which contains product name and its image. In another form i hv lookup of product. When i select value from product i wanna to show corresponding image to be shown. so pls suggest any idea.
Zoho Creater Custom Actions
I installed the default module "order management" within this module there is a page called "active" which shows all active purchases. Within this, there is a custom action with the following script. void purchase.postToInvent(Purchase purRow) { proRowList = purRow.Add_Product; for each proRow in proRowList { fet = Products[ID == proRow.Product]; fet.Available_Stock=fet.Available_Stock + proRow.Quantity; thisapp.inventReportColor(fet.ID); } purRow.Order_Status="Received"; purRow.Handled_By=zoho.loginuserid;
Get Territory
Hi Has anyone managed to retrieve a Zoho CRM Users Territory (or territories) using deluge script in Zoho Creator ? I've tried GetUsers but this does not return the territory in the resultset. Thanks in advance.
Search Zoho entries using Zapier
Hi Zoho, I'm using Zapier, and on the workflow I need to be able to search in a specific report (to see if a relevant entry was made) How can I do this? Thank you Ravid
Send confirmation email question
Hi All I am using the send confirmation email function on a form upon the user creating a new record. One on the fields on the form (Name field) is a look up to another form. I am using the code below to address the user by his/her name, however the code below is referencing the 16 digit unique code, not the actual name of the user. How do I overcome this and add the name of the person to the email, not the 16 digit code? Hello <%=Assigned_QS%> Please help!
Create a Report of Child Records Which Includes Parent Data and Data From a Table Only the Parent is Related To (Example)?
Dear Developers, I have been playing with ZoHo Creator for a little while now, I really like the minimalist IDE they've come up with, this sure does feel similar to writing code in Java, except for some syntax differences... I'm happy to learn something new! Anyway, I am having a difficulty conceptualizing my report design in ZoHo Creator. Essentially my goal is this: To display a Report (a List) based on the Child records in the database which incorporates data from key fields in the Parent table.
code on success
I'm just getting started with zoho, so please bear with my ignorance. I'm building an inventory system. One form holds the parts, and the second form if for my technicians to enter what they are taking/return to/from the inventory. Correct me if I'm wrong on this: Tech comes into the warehouse and takes a part off the shelf. Enters a record in the second form indicating that he has taken the part. Now I have two decisions to make? First is who is the tech? He has selected his name from a drop
UnPredicable exception, Invalid statement found Line:(4)
I've recently deployed my Creator app to a client and he's receiving errors that I can't reproduce on my development account. One of these is "UnPredicable exception, Invalid statement found Line:(4)" when a custom action is run. The first few lines of the function called are: void CustomizationCompleted(Customization_Form Pers) { OrderID_List = List(); for each P in Pers { //set Personalization Complete to "Yes" P.Customization_Completed = "Yes"; TheOrderItem
Copy records from one subform to another using function
Hi I have 2 parent forms with the same subform, the subform also contains lookups to the parent forms. In the first parent form I have a function that lets me copy over the records to the second, this works for all the standard fields, I'm having problems copying over the subform rows/data. 1. How do I 'access' the subforms fields for the function, at the moment I have something similar to this: void copyRecord(string First_Name, int CountryID) { insert into Parentform_2 [ First_Name
How to make a decision box unique inside a subform?
Hi there, first I want to say that I have less than basic programming skills. Anyway...I have managed to build my own application with some little scripts. But there is one thing I can not solve: In a form I am using a subform where I enter more than one lines. One of the fields is a decision box. Now I want to manage that only one decision box can be active. So if I check e. g. the box in a line all boxes in the other lines should be unmarked (if marked). Any idea how to script that? I hope the
Product contains product?
Let me start by saying I have barely even started using Zoho Creator. I am trying to verify it will do what I need before investing much time into it. Please forgive me if this is a dumb question :-) Also, I'm not sure how to even begin searching for this, so I hope this is not a FAQ. It is easy enough to explain, but I'm not sure what to search for. I know I need a lookup, but I need a lookup to the same table. I sell products, and some of those products are made up of other products. The easy
Changing Font size on zoho creator?
https://help.zoho.com/portal/en/community/topic/adjust-font-size-in-zoho-creator this is a post from two years ago, does anyone know if this has changed? is it possible to change the size of the font?
Call google maps with customer's address?? How to..
I have an app to enter in new customer information. A form with several single line fields. Address, City, State, Zip. Necessary to filter based on these fields. While entering in the customer information the next step is.... map their full address and view it in google maps while discussing the location with the customer. So I need to combine the address fields into a complete address and use it to bring up a browser tab with google maps directly to the customers address. then we use the measuring
Any tool to build a "Take a tour" for my Zoho Creator Application?
Hi, Are there tools to help build a "Take a tour" for an application developed with Zoho Creator? This is a good way to help users understand how an application works. Thank you! Stephane.
How to make a schedule automatically run a macro daily
I need to make a schedule to automatically run my macro everyday. I need to have all the records in my opportunity module automatically updated everyday so when i run my report the dates and things in it are accurate and zoho can calculate the proper age since zoho does not automatically update the current date on records continuously.
How to get previous value added to Zoho Creator by import?
When I do an import in Zoho Creator Report, in the On Success, I want to take in every record, his previous record ID (of the previous inserted record), with the objective of comparing the previous ID with the actual ID of the record and see if it is the same. How could I get that previous record ID?
How to update a field value from another form's field value ?
I have two forms in my application . I want to Update a field value of one form where the value will come from another form's field . Thanks in advance .
Is there any predefined options for getting the list of countries/cities/state?
Hi, I want to get the address from the user. Each address line has separate fields(i.e AddressLine1,AddressLine2,City,State,Zipcode and Country). Is there any predefined rule/options for populating the list of countries/cities/states in dropdown box?
Limit records in view: zc_RecLimit=<number>
With reference to: http://help.creator.zoho.com/Style-based-URLs-for-Embedded-Forms.html Where do i put the zcRecLimit parameter in an Iframe embedded on my web page? - I want to limit the records shown to 2 <p><iframe height="500px" width="100%" name="zoho-Stem" frameborder=""0""""" scrolling="auto" allowtransparency="true" src="http://LINKTOMYVIEW/zc_Header=false&zc_SecHeader=false/>="" paging="false&<span" id=" xinhaeditingpostion"></iframe><br></p>
Add lookup selections to other multiselect lookup
Hi I have 3 lookup fields on a form, first two list two different types of training, and the third hidden one needs to contain both selections from the first two lookups. This is all so I can then use a custom function to show training participants. This should happen as lookups 1 and then 2 are selected, so no extra steps are needed. Lookup 1 dropdown select - Training type 1 Lookup 2 dropdown select - Training type 2 Lookup 3 multi-select auto adds - Training type 1, Training type 2 Thanks
Two dropdowns (not lookups) return ID numbers when adding.
In my Add Student form I have Grade and Class Day as dropdowns with a few values each. On adding the values become IDs, but when I edit them, I can X out the ID and choose a dropdown value again to save them as the correct non-ID values. I'm not really sure...
Show/Hide fields in HTML page on click of a button?
I'm aware that Creator does not support javascript, but is there a work-around to show/hide elements in an HTML page via buttons?
Header space still shows after params='zc_Header=false'
I am trying to completely remove the header in reports embedded in an HTML page but the white space still shows even if I input the parameter params='zc_Header=false' I hid all of the parameters but this still does not do the job. How do I hide this white space on top of the report?
Automatically updating my opportunities everyday
I need to have a schedule or something which will either update my opportunities everyday so when i run a report it will calculate the correct age. Even better would be a way to have the crm update the opportunities every time i run a specific report
C# REST API File Upload
Hello, I am using C# and WebClient to add/edit/delete records in Creator and it has been working very well. Please see example below. This code adds a record, then I have been trying to upload a file to a file upload field. I am not having any success using WebClient to upload files and have tried a number of combinations based on the Zoho Creator API file upload documentation. If anyone can point me in the right direction here it will be a big help. -Wright var response = Http.Post("https://creator.zoho.com/api/myzohoapps/xml/ncportal/form/Documents/record/add/",
Duplicating records in a report from a custom button and changing the value of the exstg record.
Hi all, I've managed to successfully copy an existing record within a report by using a custom button (code below). I am struggling with changing the revision number of the new record. Currently the code below highlighted in yellow successfully copies the revision number of the existing record, but I would like to change the revision number to the next corresponding letter. e.g. if the existing revision number is 'A' I would like to change the new record revision number to 'B'. Any ideas how I can
I need to make a copy of my application
Hello everyone! I'm new to programming with zoho creator, and I'm going to maintain an app. I've seen the Sandbox option,in order to learn how to fix things without danger, but I push the link "Create SandBox" but nothing happens. there are 3 little circles on the screen, like it was working on it, but we leave it for hours and notthings happens. Can anyone tell me how can I activate the sandbox, or how can I start working on code without touch the application on producction? thaxs!
Subform : Delete subform rows when main row is deleted
Hi, How do I automatically delete subform rows when the row of the main form is deleted ? Many Thanks !
How to duplicate a record
Hi All I am wanting to duplicate a record and not sure how to do this. I would like the entire record to be duplicated using old values when the user changes the revision number of the record. For example, if the user opens up an existing record and amends the revision number field from A to B, I would like the entire record to be duplicated using the old field values (revision A) before the amendments where made. During this event I would also like to change the 'superseded' field from the default
Schedule Report to send as excel file
Is it possible to set a schedule for the report to send a excel spreadsheet/ CSV file, at the moment its just a PDF.
Refresh the page (with a filtered report) when I click submit.
I created a page which consists of a form and a report (the report of the form). Lets say that I have filtered the report to find some records. When I add a new record and click submit is there any way to refresh the page and shows me the filtered records (which I have found them before the submit)? Without need to search them again. With other words with the refresh to return back to the filtered page view.
Next Page