Setting the height of a multi select list
Is it possible to set the height of a multi-select, lookup field on a form? I tried the instructions here (https://www.zoho.com/creator/help/fields/setting-field-width-and-height.html) to no avail. The height setting is missing. Here's a screenshot of the form field in question: Here's a screenshot of the field properties. Note that I have tried changing "field size" to be other values, including custom. It just change the width. Any help is greatly appreciated.
Updating Value of Checkbox On Edit -> On Success
Hello, I have a list of checkboxes, like Notifications: First Email Second Email Third Email i want to update(check/tick) the 1st option "First Email" when "if" condition gets true. What i have done so far (On Edit -> On Success) if(input.Email == "xyz@email.com"){ Notifications.select('First Eamil'); } This doesn't work. I am getting the alert like this "'Notification' can be used only in on load actions". This works in "On Edit -> OnLoad". But i want to do it in "On Edit -> On Success". Kindly
"Approve / Decline" notification when data is edited? // field and form name as a variable?!
Hi Zoho, I need to create some verification system when certain users change data in a form. So when the user tried to edit data in a form, I will get a notification on the mail with an option to either approve or decline the change (decline = no change is made, approve = the field gets the suggested data). I thought about creating a "Change data form" that will be auto-filled and sent via email when an edit is suggested. in order for this to work properly, I need to have variables used for the
"Allow HTML tags" is missing
I want to experiment with adding conditional scripted cell colors on some views. I understand I need to check "allow HTML tags" in the app settings. However, this checkbox is MISSING in the app I am working on as well as one other app but it present in 5 other apps I have created. I cannot understand the reason why it would be missing, however, when I try and apply HTML tags to cell text, the HTML tag is shown in text, which is, of course, not what I want. Any ideas here? DJ
Error: The remote server returned an error: (400) Bad Request. -Zoho Creator XML RPC API
I am trying to use Zoho Creator XML RPC API. and I always get back an error which is above. I send to this url: https://creator.zoho.com/api/xml/write/woodcliff-rewards/Rewards With this postcontent: <form method="POST" action="https://creator.zoho.com/api/xml/write"> <input type="hidden" name ="authtoken" value="xxxxxxxxxxxxxxx"> <input type="hidden" name ="scope" id="scope" value="creatorapi"> <textarea name="XMLString" > <ZohoCreator> <applicationlist> <application name="woodcliff-rewards">
Alert won't pop up on "On Validate"
Hi Zoho, I have an alert that needs to pop up when a form is sent. This only to inform the user, I don't want to cancel the submit. The alert does not pop up. Why? Thanks!
changing rich text to multiline
Hi i have two questions on that topic. 1) is any data going to be lost in that transition from rich text to multiline ? 2) how do i convert the rich text to simple text ...i.e. how do i get rid of the <br> without losing the return paragraph function...
Auto Fill Field in Subform Of all the lines
Hi, I fill in a subform, but fill all the data from it after that and add new rows. With my code I can only fill in the first line and I do not want it to be "on add row". if(input.Tipo_de_orden1 != null) { input.Registro_Mercancia.Tipo_de_orden1= input.Tipo_de_orden1; } Thanks
Hide Grand Total but keep totals in Report
Hi there, I have a report which contains prices comparisons, which are grouped by suppliers/contract terms/... and I set up price totals for each group, which is what I want. However, in the report, I keep on getting a Grand Total on the bottom line, which I don't want as the purpose of my report is to give my client the opportunity to compare prices between different suppliers, so the Grand Total does not mean anything and need to be removed. Any advice on how to do that? Thanks Maud
Disable entire subform
Under certain conditions I want to disable an entire subform. To hide the subform I can use hide name_of subform; But disable does not work disable name_of subform; Do I need to disable each field in the subform?
Multiple "for each line" statements
Hi, I'm still learning syntax so i'm hoping this is as simple as rephrasing / combing, but i basically have a couple instances where i want to use an expression to apply in two different ways, but it seems i can't use "for each line" twice like this. (On load) for each line in Prod_subform { line.Previous = true; } for each line in Misc_Subform { line.Previous2 = true; } (On Success) subformContent = ""; subformContent2 = ""; for each line in Prod_subform { if (!line.Previous) {
Overview in the building zone
Good morning... When developing applications it would nice to have a table or database type overview of all the forms in the applications. Maybe even with links that indicate the lookup fields between forms. This has been asked for before but i can't seem to find an answer. It would really be helpful. Regards, stefan
change the display name of a field via script
Hello Zoho creator developpers, I want to know if there is a possibility to change the display name of a field depending on a condition. Something like: If (expression) { // set the display name of input.fieldDelugeName to "company adress" } else { // set the display name of input.fieldDelugeName to "contact adress" } That will save me having a lot of field that do the same and use theme everywhere other script with conditions. Thank you
How can I find out the number of related records in the child table
Hello How can I find out the number of related records in the child table? Thank you. only_relational_count = SubForm [ID == ID].count(); //not working
How to use GetURL to get a form's data?
Hi Zoho, I'm trying to use the GetURL task to pass a form's parameters. Unfortunately I don't have much knowledge in programming, and would appreciate if someone can explain this a little more: I Currently have a <form> in an html page, and I would like to send the data to a Zoho form, as a parameter. Where should I put the getURL task? and how should I write it? Thank you very much Ravid
Zoho Creator > Workflow > Set rules and tasks
I am creating app as seen in Zoho Creator Video, and having issues: https://www.zoho.com/creator/tour.html# Click on Video link (in the right) under “Automate Workflow” …. “Set rules and tasks” Go into Video at 21 seconds where it sets Quantity Greater Than 21 For some reason I do not have option under this dropdown in my portal. Will appreciate help. Thank you; Ramesh Kamath
Set the value of a lookup field
I have a form with a dropdown question and below that a lookup field. I wrote a code as below to set the value of the lookup field according to what is selected in the dropdown question above: if (input.Use == "R&D") \\ if R&D is selected in the dropdown question { input.Type_of_Sale = Types_of_Sale[Type_of_Sale == "R&D"].ID; \\set the value of the lookup field (Type of Sale) to the ID # of the R&D type of sale } Because it is a lookup field for the form: Types of Sale, I had to set it to the
Unable to use If condition in For each Rec loop
Hi, I am facing following problem while inserting records in a table. If I give any if condition in " for each rec in R " loop, I get an error. If I do not give any if condition then the loop works fine. Is it now allowed to give an If condition with For each Record loop. Pls clarify for each rec in R { if (rec.Dep_Method== "Straight Line") { D_Amt = (rec.Pur_Value - rec.ESal_Value)/rec.Exp_Life; } insert into Depreciation_Details [
Show/Hide field in report using parameters in URL?
Hi Zoho, Can I pass a parameter to a report so it will show / hide certain fields? -OR- can I use a variable for the field name when fetching data? (Entry.variable)? Thanks Ravid
Accessing master table between apps
Is it possible to have a common master table in Creator which can be accessed by different apps (all in same Creator account)? The situation I have is like this: 1. A master customer data set - loaded manually through csv import - with geographical segregation codes 2. After verification, data is seperated into different 'views' based on geographical codes. 3. A seperate app (within same Creator account) then access the data and follow additional work flows The reason I want to seperate the data
Unable to publish my apps to Market Place
Hi, I am unable to publish my apps to market place. In the Developer Zone , I do not get that button to publish to Market Place. It allows me to publish an app to a client but not to market place. I have written to ZOHO support but so far they have not responded. In case anyone has faced this problem earlier, please revert with the solution. Please see the screen shot attached. Thanks, Milind Manohar
Problem in inserting Records
Hi, Please see the screen shot attached. Here R is a set of records, which I am iterating thru using "rec" as collection variable and inserting into another table (form Depreciation Details). Even though there is no apparent syntax error, please see the error thrown up. Please help if you can spot the mistake. Thanks, Milind Manohar
External customers
Hi, Is it possible that with Creator create an application that people can use by creating their own identities by using for example Hotmail, Gmail accounts and so on?
Http request from an external site to Zoho Creator
Hello Experts! I'm trying to make a http request from an external site to Zoho Creator. I can only write on Javascript. Please, what is the most direct way to make this request? I was trying to use the XMLHttpRequest with a getURL (), but it returns "No 'Access-Control-Allow-Origin' header is present on the requested resource." I think CORS is not supported on Creator. A lot of thanks in advance. Best regards. José.
How to convert string to number
Hi, How do I convert String to Number. Which function should I use ? Pls. help Thanks, Milind
Get Invoices From Zoho Books To Zoho Creator
I need create a lookup field in Zoho Creator to locate all invoces with a balance due in Zoho Books. I currently have: invoiceslist = zoho.books.getRecords("invoices", "936496201", "invoice_number"); Invoice:ui.add(invoiceslist.get("invoices")); under the 'on add' 'on load' and I'm getting a drop down that includes all invoice details in the lookup field ({"date":"2016-12-4","Zcrm_potential..... etc, etc.). I just want INV-XXXX to show up in the field then populate "Client Name" and "Amount Due"
Apps getting added as "Shared"
When I press New Application and add the Support Desk app it is not showing up in the "Owned by Me" section... it is showing up in the "Shared with me" section. I want to remove the apps but i don't have access.
AddedTime not available in Pivot Chart?
I noticed none of the system fields are available in the Pivot Chart. Why is that? I just want the AddedTime to go on my x-axis of my chart. See screenshot: http://screencast.com/t/OM6irV9A
zoho creator calendar showing date ranges not discrete dates?
I created a form that allows a user to enter a date and then also shows additional dates some # of days after that. So the form may have multiple dates in that record. That all works fine. However when I view the Calendar report the entry shows up as a range across those dates. Is there any way to have them just show as discrete entries on each date in the form and not including all the dates in between?
Creator embed report size
Hi There, I have been searching hi and low and need the best way to do this. i have a report that i want to embed into a page in creator. when i Embed the report. It doesn't take the formatting that the report has. and only shows it in a half page window. Can someone help me get around this Cheers
cant edit load function
Hi, I am new in zoho creator. I am not able to edit onAdd -> onLoad. I have written some record fetches on onload.When I open this, the entire page got stuck. While I can open other sections after reloading. Problem is with onLoad. How can i get back old codes from onLoad. Any idea as to why this happens? How do I fix it?
why changes are permanent when grouping a column of emended report?
hi, i have created a embed report to a html view page . i am not writing any code for grouping and not done any settings at report group & sort section of the report . now the problem is: i group a column as "Group by Asc" and this changes permanently .it's not changing to it's normal page view when refresh the page .? why it is happened ? waiting for reply ... Thanks, Suresh Kareti
Problem fetching record when using lookup fields as criteria.
I will appreciate your help in directing me to a solution. I have spent hours with no success. I have four forms: frmClients - stores the ClientName and SocialSecurity of clients. frmProperty - stores the PropertyName, address, phone, etc. of properties. frmContract - consists of a Lookup field TenantName based on the frmClients, a Lookup field PropertyName based on the frmProperties, and other fields like amount, initialdate, taxrate, deposit, etc. frmInvoices - consist of a Lookup field UnitName
Get Record by ID: Variable 'Product_ID' is not defined
I am making an app that uses the following code to record products from the Products module in CRM But I get this error: Error at line number : 1 Variable 'Product_ID' is not defined crmResp = zoho.crm.getRecordById("Products", input.Product_ID); input.Unit_Price = (crmResp.get("Unit Price")).toDecimal(); input.Quantity_Available = (crmResp.get("Qty in Stock")).toLong();
Pivot chart based on views
Hi. Can a pivot chart be based on view or multiple forms, rather than a single form. I am sure it was previously available. Thanks.
Auto Fill URL with Field
Hello, I am developing an order management system that requires each individidual record to have a barcode/QR code so that they can be scanned to bring up information at certain points along our manufacturing cycle. I have created a 13 digit autofill number for each record, and I would like to retrieve a QR code using that autofill number from an external website, however I don't know how to input the field name into the URL so that it automatically fills this part of the URL with the records Autonumber?
Report hang when scrolling
Hi, I noticed the new enhanced feature on reports, there is no paging any more, but when user's scrolling down to the end of the screen, the report fetches more records. However, this ALWAYS causes screen hang. I have a report with around 40 columns and less than 3000 records, every time when users scrolling fast, the screen will be frozen, and IE will prompt that "the scripts takes long time, stop it?". Moving back to the paging style shall be helpful. Or, please help to fix this defective. Thank
Creating relationship between form and subform
Hi all, Please excuse my ignorance as I am very new to Zoho and while for the most part the user interface is very intuitive, the deeper possibilities with coding remain a bit obscure to me as my knowledge in that field is quite limited. Essentially what I am trying to do is create a database for storing information about lectures. This database is very simple and I have designed it using only two forms: talk and excerpt. Whereas a talk can exist without any excerpts, every excerpt is part of a talk
Zoho Creator EU edition
I started using Zoho Creator in zoho.com domain, but due to regulatory reasons opted to move to zoho.eu domain. A lot of functions we see in zoho.com are not yet available in .eu account, almost a beta version of .com. Is there a time line when the full functionalities of .com will be available in .eu domian? Thomas
Many to many relationship with note field for each relation
I'm trying to create a many to many relationship while storing some information about that particular relation. For example: A SurveyQuestion has many AuthoritativeSources. When an authoritative source is chosen for a question, the rationale (or justification) for the selection should be documented in a note. An AuthoritativeSource can be used in many SurveyQuestions. In a database this would be represented as: SurveyQuestion >-< AuthoritativeSource SurveyQuestion - ID - QuestionText AuthoritativeSource
Next Page