No longer able to modify Field Deluge Name of a Note
Did anyone else observe that recently changes to notes Field Deluge Name do not work? When you create a Note, it is created with Field Deluge Name of "note". If you change the Field Deluge Name from "note" to anything else, for example "My Favored Note", the system appears to be saving your change, but when you click elsewhere and then return to the note, it shows again "note". Your change was not saved. If you ran into this issue and were able to come up with a workaround, I would appreciate your
Passing a default parameter to a view and carry throughout the "Add a Record" function of that view
I am using a calendar view and was successfully able to add criteria to filter the view by passing a parameter through the URL. When I use "add" to add a record to the view the form pop opens and the lookup dropdown is not pre-populated with the value that i passed/filtered on. It seems it does not get passed from the view to the popup form. Is there a way to ensure this parameter gets passed to the "Add" functionality?
Dropdown showing 'Choice 1 Choice 2 Choice 3' instead of my custom labels
Is this a known bug, or is there some reason why my custom labels are not showing, and instead my application is showing users 'Choice 1, Choice 2, Choice 3'?
Why can't I update 'Add notes' Field Deluge name
Every time I try to update the field deluge name for an 'Add Notes' field... it does not save and reverts back to the default name (e.g. plain, plain1, etc) Is this a known issue? or is something else wrong? (I'm beginning to question if Zoho Creator app is production ready since things like this shouldn't be happening (and within my first 30 mins using the tool)) #gettingworried
Publishing guidance
During a evaluation, I am unable to play around with the publishing feature. I have a number of questions as to what can/can't be done. I expect to be creating a directory of family members (large family reunion) and the report needs to be embedded into the family web site. I saw that it would be available to google crawler and others, which may or may not be a problem. But I will have a subscription for about 4 or 5 users, but the report potentially will be accessed by hundreds of people. How
How would I get my data to update
I need to get the records in my crm to update.
Populating Products in CRM through Creator
Hi, I desperately need some help with the following: I need to populate (from Creator) the Product fields inside the Quotes CRM module. I have written the following code to send the information to the CRM: ListaProductos = List:Map(); for each xProducto in Productos { LineaDeProducto = Map(); LineaDeProducto.put("Product_Id",xProducto.ID); LineaDeProducto.put("Quantity",xProducto.Cantidad); ListaProductos.add(LineaDeProducto); } CotizacionCRM.put("Product_Details",ListaProductos); Respuesta = zoho.crm.create("Quotes",CotizacionCRM);
single and 2 column layout
I want to combine layouts. fields in the main form in two columns and the subforms in one (so that I can see all the fields). Can it be done? If so, how.
Remove item from picklist in subform
Hi Zoho, I have a subform with an Item field(dropdown). I would like to remove an item from this dropdown if it was selected in a previous row in the subform. how can I achieve this? any help will be appreciated
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
Lookup field not pulling lookup field of secondary form
I am creating a lookup field in a form. The lookup goes to the second form to find values; for display purposes, the lookup field on the main form won't display the lookup fields of the second form. Is there a way to overcome this? Thanks.
Auto delete records based on amount of records and age
Hi there, in our Creator dashboard we have hundreds of apps, each app has a form and a report. Most reports now have several hundred records each - managing and clearing these out when we start to run out of space is becoming a monstrous job therefore I'm looking to create a couple of clever little delete functions to help me out. For a bit of background, we use creator in order to take and send messages to clients, the form uses a sendmail function to email the client, the report is used as a history
Deleting duplicates in a form
I am trying to find an algorithm where I can find all duplicates in a form according to a key field or composite key field, and in each group of duplicates I only keep the oldest record per Add date. How can this be achieved with Deluge? Thanks
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.
Sending SMS Through Twilio - Trouble with IF Statements
I am trying to send a message to only certain workers who are: Active and either Foremen or Leadmen The if statements below don't seem to be working like I thought they would. Any thoughts? for each r in Worker_Information [Worker_Status1 = 2937369000000532011] { if (input.Enter_Worker_Designations = 2937369000000747003) { mob = "+1" + r.Mobile_Phone_Number.getAlphaNumeric(); m = "<Red Iron Alert> " + r.First_Name + ", " + input.Message; resp = twilio.sms.send("Zoho1",
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
Backup in a client?
Is there any option of getting the back up for the data of an application that is being published to a client?
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.
substring
I am needing to separate the characters in a zipcode, so I found the substring function and tried to use it to fill a field named region with just the first characters. However, when I wrote the line below in the free-flow scripting for on user input of the zip field, but it said "Not able to find 'substring' function". Is there something wrong with the script itself, or in the way I did it? region=input.zip.substring(0,2);
Boolean field
I would like to show a check mark instead of the value of boolean field (true/false). How can i do it using Zoho Writer?
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;
Just getting started Need to create hyperlinks
I am just starting the process of possibly migrating all of my systems into Zoho. This question may be answered somewhere in the help files, but I have been through the 15 videos and didn't see an answer. I have a single line text field which contains a ticket number. I need to concatenate a rather long URL (www.specialsite.com?ticketnum="[value of ticketnum field]. I need to be able to click on this and launch the web page either in a new window, or at least a new tab, I believe that this will
Form Data in Email no longer formatting correctly.
I have forms coming to email with all form data in body. They use to arrive formatted correctly. Starting last week, they all come broken now. Shown below. Please help. User submitted data Are_you_18_years_of_age_or_older :Yes If_no_why_not : Email : May_we_contact_your_supervisor :null Address :test Your_Job_Title : Reason_for_leaving1 : Employer_s_Phone_Number : Present_Last_Employer : It use to be like this: User submitted data First Name John Last Name Doe Address 123 Main St City Sunnyville
Chat Bar in Zoho Creator
Apologies for this probably very basic question. Is there any way to permanently disable the chat bar from taking space at the bottom of the browser window? You can collapse the bar to the left by clicking << but it comes back every time our users return to Zoho Creator. Many thanks in advance.
EPSON Printer
Hi, Is it possible to print a record on a epson printer? FOr a receipt? Thanks!
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!
Push CRM Attachments to Creator
Is it possible to push all Zoho CRM products attachments to Zoho Creator? For ex: I want the attachments in 'Zoho CRM Products' to be uploaded in Zoho Creator Form file upload field.
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
Changing number field to text
I have created a form with a number field. We have so far generated around 400 records, now it has been identified that we actually need to be able to replace the number field with a text field. Is there any smart way to implement this or is the only solution to create a new text field and update all records manually to move the data entered so far in the number field to the text field?
Easy CSS Styles for your forms
Hi ZC users, Just whipped up a little ZC function that makes it super easy to customize the look of ALL your forms in all your applications. I got tired of having to make markup changes in many, many html views and links when using the customization parameters. Here's the code.. Also, this is up on the marketplace as well. string style.getFormStyle() { /* Author : -Stephen Rhyne -Owner -Rhyne Design -stephen@stephenrhyne.com -http://stephenrhyne.com Created : 11-25-09 Version : 1 Copyrights :
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
Next Page