script written in form don't seem to work when form is used as a sub form
a script that works in a form, doesn't seem to work when i use that form as a subform. any help?
New to ZOHO Creator
I am trying to make an application for my business and would like to create an app with basic info on the business including photos, info, Facebook, twitter, youtube videos, etc. How do I create this, I am not too familiar with creating my own app from code yet. Is there a way to do this with simple drag and drop GUI or does anyone have any templates that they can share with me?
Application wont duplicate
Hi My application will not duplicate Can you help? App is https://creator.zoho.com/mrcomputer/mrcomputer# and I have enabled access for you Thanks
Field Required via Script
Hello Guys, i have two fields for Text and this Code. if (((input.Acount_Code_1A != "") && (input.Acount_Code_1A != null)) { if (!(input.Acount_Code_1A).toString().matches("[a-zA-Z0-9]{2,15}")) { alert ("Account_Code_1A should be between 2 and 15!"); cancel submit; } } how can i write the code so the user always has to fill one of the two fields without which there are pre-mandatory. Thanks Carsten
Sorting on a Linked Field in an HTML View
Hello everyone, I was hoping that someone could help me out with an issue I am having with an HTML script that I wrote for a page. In this script, I use two forms (AVLBeerManager & Beer_Locator) to create an html view that displays a list of beers with relevant information (ABV, Description, etc.). Beer_Locator is where location information resides (i.e. @ which bar has which beer) AVLBeerManager is where beer information resides (i.e. abv, desc, etc) I iterated records on both tables, linking on
Get CRM Leads direct to Creator report List
How can I get all CRM lead records to import/sync directly to Zoho Creator report in list view??
Mass editing using zoho creator
I want to build an app to edit my existing records in Leads/Accounts/Contacts/Potentials module of zoho crm massively. Can you please guide how can I do that?
Current date and time in the Date-Time field? If exact data exists how to generate an error?
Auto add the current date and time in the Date-Time field? Also, if exact data exists how do I generate an error?
can i create api in trial version?
i want to use crator API in trail version . is it possible in trial version?
Profile Locale Details not respected in Creator
In My account --> Personal Details --> Profile --> Locale Details I set my language as English and country as United States. When I use my PC at home, with the English version of Windows 7, I don't have any problems. When I use a computer at work, with Japanese Windows, in some areas of zoho.com the interface does indeed display in English, as specified in locale details. In other parts, such as Zoho Creator, the interface is still mostly shown in Japanese. What the hell is up with this? Makes
Custom Schedule
Hi ! i look around but dind't find my answer ! If i set a schedule to run every Last day of month wich in the list i have 31 days !! is it gonna run if there is only 28 days in the month ???
Using Form definition to create forms
Hi, I would like to know, if there is a facility to create forms using the API. If not can I understand form definition rules and write my own Form Definition programatically and post it after authentication to an URL to create a new form ? Thanks Praveen.M
ALLOWI USERS TO SWITCH BETWEEN GRAPH AND CHART VIEWS IN A REPORT LIKE ADMIN CAN
As ADMIN I can choose to look at the data in a report in various ways, such as charts and tables. This does not change the underlying data records. When I save the view, that becomes the default view for USERS of the app, and the USERS cannot change the view of the data. Is there a way to let users choose to see both graphs and chart views like the ADMIN can switch between? Thanks! Loyd
Sort button in pivot chart not working
Sort button is not highlighted and can't sort the pivot chart axys Any ideas why not working? Thanks
NO REPORTS IN MOBILE APP?
I have the Android mobile Zoho Creator app. I can see the data entry form, and can view the records, but I do not see how to view any of the several reports I have in the app. I looked for a checkbox to share the reports on the mobile app but could not find one. My assumption is that the Android mobile app is just for entering data and viewing records, and not using reports. Loyd
Barcode Recognition
Is there anyway to include a web based barcode recognition tool to import inventory. Or barcode generator. This would be similar to something like the new google phone has. Scannerfly has something like this for amazon books.
lookup function 3 levels
Hi, I need your assistance with 3 level of Lookup function. Example of My data: products short-name full-name code Mobiles Samsung 3 3.5" Android Phones Samsung 3 9983 Mobiles Samsung 3 3.6" Android Phones Samsung 3 9984 Mobiles Samsung 3 3.7"-3.9" Android Phones Samsung 3 9985 Mobiles Samsung 4 4.7" Android Phones Samsung 4 9986 Mobiles Samsung 4 5.0" Android Phones Samsung 4 9987 Mobiles Samsung 4 5.3"-5.5"
Add the data of a subform with deluge script
Hello Zoho developers, Finding the answer of this question will help me in many projects. I have 3 forms: MainForm1, MainForm2 and Subform. MainForm1 and MainForm2 both contain a subform of Subform. When creating MainForm1 (in its On Validate or on success), I want to automatically create a record of MainForm2: Form2_ID = insert into MainForm2 [ Added_User = zoho.loginuser ... ];and then to have the same data of the subform Subform in MainForm1 attached to the newly created record of MainForm2. Thank
Showing all records in Table Report
Hello all When using Zoho reports to create Pivot Table, the default setting is to hide all those records that are have duplicates. Is there a workaround around this? I would like to have a Pivot Table and have all the records appear in the Pivot Table. Looking forward to your ideas and help.
Sort button in pivot chart not highlighted
For some reason the sort button doesn't work in pivot charts. I can't sort the x or y axys. Is this a bug or missing something Thanks
Export pivotchart report into .JPEG - trunckated image
Hi, I'm trying to export a chart into JPEG. The export work fine but the final result is a picture with the last few inches of the right side truncated. something like that : Any idea on how ti fix it? Riccardo
<Field Name>:ui.add() function does not work in On Add/On Load event?
Folks, I have another questions for this group. First off, I have found the link below on adding data to Dropdown Lookup List type field. https://www.zoho.com/creator/newhelp/fields/add-to-picklist-dynamically.html In my case, I have my first Lookup Field to be Tournament, then the second Lookup Field is Event. Each Tournament can have multiple Events. Currently, without any initial default value to my Tournament field, if the user chooses a Tournament, the Event Lookup Dropdown field will be
Problems with "lookup fields" and variable criteria
I have an application that uses a subform where I need to query a lookup from another database, the previous builder used a criteria with a variable, but I had to capture the "filter" in each row again, It worked very well. Now with the new builder I have the problem that I can not capture variables in the "criteria" field or at least not work well. Has anyone solved a problem like this? Thanks ....
Criteria to display a report with no value entered in a field
I have a form with categories, more than one can be checked at a time but I need a report showing those that have no category selected. I have tried a few things but none seem to give me the response I am looking for. I need to be able to go back and add categories to the ones I was not sure of when adding them initially.
Creating a report with fileds from Sub-From
Hi there I am wanting to create a report, based on the parent form, but bringing in various fields from 3 sub-forms of this parent form. I have created this type of report using the view link method, but the format of this is not satisfactory, and I want each field to show as a separate column in the report. (This is fine for one field alone, but not numerous) The Subform is logically a one-to many relationship, so I am not sure why the subform columns do not show as options in the report creator,
Subform handling that worked on the old platform is no longer producing the same results!
I have a form that was created on the previous Creator platform. This form contains a subform and is working fine. I created a new form using the old form as a template. I had to use a different subform in the new form. The new subform is an exact copy of the old subform. The code is identical in both forms. The new form does not produce the same results as the old form. In the old form the code listed below returns the string with the contents of the subform field Activity. This is exactly what
Lookup CRM and return address
Hi, I am trying to lookup my CRM account and then based on customer selected return the address? Thanks
Numbers not displaying properly in HTML
I have an HTML page where I am trying to display a currency field from a particular record. When the number is small I get the number to display 800.0 but if the number is in the millions I get 8.0E+8? I have found that when the currency is less then 8 digits I get something like 8000000.0 but when an additional digit is added it goes to 8.0E+8 How can I fix this to display like $8,000,000? Thanks, Sean The top part of my HTML page htmlpage Opportunity_Details(opportunity_idstr, opportunityID)
Can I call the delete web service using JSON in the request body?
Hiya The API samples show using x-www-form-urlencoded data when calling the webservice to delete records. Can I use json instead? If so, can you give me an example? thanks Paul
how to clear Zoho crm lookup field
How can I clear the value of a Creator Zoho CRM field with out using an API call? I want to be able to clear a value that has been entered. I have used the following but it seems to use an API call and i dont think it actually is clearing the value. input.ZohoCRM_Lookup_Field = null;
Calculation based on lookup
Hi, I have the following I am trying to achieve FormA.Product_ID FormA.Weight_Per_Item FormB.Product_ID is dropdown/lookup from FormA data FormB.Quantity FormB.Total_Weight trying to get this to populate based on FormA.Weight_Per_Item * FormB.Quantity Any help would be appreciated
Adding a field from another form database on success
A visitor fills out the form Landing_Page and enters a Promo Code. On success I need to look up the entered Promo Code and match it to the promo code library form called Promo_Code. After a match I need the associated consultant from that promo code record (in the Promo_Code database) to be added to the record that the visitor just created when they completed the form. Please advise how to do this
how are subform entries related to the parent record?
I want to be able to use a custom action to add a sub form record but don't understand how the sub form record is related to the parent record. My custom action adds a subform record but it doesnt seem to be related properlly. I have a custom action that opens the sub form but seem to be missing the part that will relate the new sub form entry to the parent record that the custom action was executed on. The custom action code im using is: void Payment(int ID) { openUrl("#Form:Payment?Request_ID="
adding unique rows
i want to know how to avoid duplication of records while inserting data?i want to know validation for same. when i will upload file only new rows can be added..
Single or double equals (or no equals) for boolean criteria
Hi, A fairly basic question but it would be great to have a definitive answer and I can't find one anywhere. What is the correct format for boolean criteria for a conditional expression (like an if, or to select form data)? And does it matter which format you use? (Because it doesn't seem to make any difference when I test out the different versions). A. One equals, e.g. FormData = Form[bool = true]or e.g. if (bool = true) {<expression>;} B. Two equals, e.g. FormData = Form[bool == false] or e.g.
Picklist within subform
Good afternoon, I have a picklist inside a subform wich I dynamically populete base on a lookup field. Is there any way to select one item on the picklist?? I try row.<fieldlist>.select(value); But the system answer: <fieldlist> does not exist in this form Thanks in advance for your answer. Ricardo
How to set up help button in a form dropdown
Hi, In a form a line which has drop down ( can I have a Help button around it - which displays pdf diagram which helps choose the choice for the drop down). Please help I am a newbie to zoho. Thanks, Geeta
Customer Portal Document Access
Our application has documents within the database, however the users we have set up through the customer portal are unable to open these documents with their userid and pwds. When they click on the link for the documents they are asked to sign in again via a link to the url via zoho and NOT our landing page, but their credentials do NOT work, making the documents within our application un-accessible to them. How do we fix this issue?
usage limit (how to manage)
OK, I have been using zoho creator for some time and has worked so far fine for my purpose. I do business process management and also store sales transactions. The sales transactions in particular I cannot afford to delete when I reach the usage limit. the other suff I can. Eventually (soon) I will reach the usage limit filled up with sales transactions. I need to figure out a way to manage this before that moment arrives. Obviously I can buy more records, great but eventually these will be used
Zoho CRM integration for dropdown field
I have the following code that works (in the load of a form): accountlist = zoho.crm.getRecords(("Accounts"),1,200); for each rowvar in accountlist { Client:ui.add(rowvar.get(("Account Name"))); } My question is how do I sort the Account Name for my dropdown field (Client)? Thanks
Next Page