Can't duplicate application
Hi, I am trying to duplicate an application. When I click on Duplicate it says 'Duplicating, please wait.' After a few seconds that disappears but the application has not duplicated. Please help- thank you!
Just shows Processing on website - Please Help!?
I've created a form through Creator but on the website it just shows "Processing" and doesnt load my form unless i sign back into creator and "save". But again a day later it returns back to "Processing"? Can anyone help?
Merketo Form Submission Error
Merketo form validation not working with javascript function in submit button tag
Portal site login issue
After I login, the header is repeated in the loign box area. I contacted tech support a couple of times, but no response. Is the portal feature still beta?
Null to Zero - can't seem to ge this to work.
I am having difficulty converting null to zero. I posted this question yesterday and was given a response but I cannot get it to work. In a nutshell I have a formula field (InsertCost) that contains 2 fetched fields (decimal) that I need to divide.I have set the input.pubcost and input.allocation default values to 0. But my formula keeps coming up with NULL. (input.pubcost/input.allocation) If the fetched fields contain data there is no problem but these fields often they will have no value and
Delete Forms
How can I delete a form? ismael1127
Linking Fields in Creator to Fields in Project
Is it possible to get data from Zoho Project (let's say a start date) and display it in a Creator database? They would have to be linked by a common record id or number. Something like a join.
File upload: action on the user input
Hi, I would like to set up script that after file upload other features would appear. Which variables i should use in the script formating (e.g. "If" input.file upload "then" show field) thanks, r.
Trimming field values
How can I make a form automatically trim the leading and trailing spaces of a text-string? I wanted to do this to avoid duplicate entries. Thanks.
Bug in Usage Limit and Buying Addons
We're on the Professional plan, which gives us 20,000 records. Today we received an error staying that we've reached our limit, and the dashboard indicated that we'd already exceeded our limit by 1,194 records. So we bought an addon for 5,000 records, but now for some reason our dashboard says that our quota is 40,000 (instead of 25,000) and that we have still exceeded our limit by 1,194 records. In other words, there appear to be 2 bugs: 1. We bought 5,000 additional records, but the dashboard indicates
Can I upload accdb files to Zoho ?
I´ve managed to upload an Access .mdb file to Zoho, but it failed for .accdb. I got the following error message: Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine error. Can anyone help me with this ? Thanks in advance.
Is there any way to use JQurey in future?
Dear Team, Can you please provide an official JQurey in future ? so that users can use it in Html page, to achieve a lot of very dazzling effects.
Reference a field name using a string
I want to retrieve data from the nth field (i.e. column) in a record (i.e. row). Can I retrieve data from a field by referencing it using the string equivalent of a number i.e. "Record.column" where "column" is a string variable containing "1", "2" or "3" etc.?
IP address Issue
Sir/Madam, I created a form in Zoho Creator and made one netry. Subsequent to that, when i tried keying in one more enttry, i got the message which said " ONLY ONE RECORD PER IP IS ALLOWED". Please help me in solving this issue. Regards, Mukund Ramasubramanian Praxis Business School Kolkata
Easy way to define variables over forms
I have a few variables that are defined under inputs, however, these variables are not defined over the entire form. Although it is possible using another input field, I really don't want to have multiple disabled inputs for no reason. I want to define a variable over the entire form. Is this possible? I tried the defining global variable help, but I don't think that solves my issue. My script is basically: a = productDet.get("Reimbursement"); which is inside for/if loops under a specific user input
Set Column width in new application builder
I have switched to the New Application Builder and want to set column widths for a view. The problem is that there is no option to set the column width. If I want to, I have to temporarily switch back to the old builder or edit the Definition. Can you please include an option to set column width in the New Builder?
Bulk update: missing columns
I want to bulk upload the SITE view at https://creator.zoho.com/essistmgmt/assets/#View:SITES_View I am missing the CONNECTWISE REF column from the dropdown to update. Can you please investigate? Note, The application has shared access.
Application integration
we are interested in using several of the Zoho applications if I sign up for creator can I use all the applications I need without paying separately for them? otherwise it becomes very complicated and cumbersome. I would like to use HRMS, CRM, Books, Invoice and develop (or have someone develop) an online booking system for us. Also interested in using sites.
Programmatically create a new view
Hi Guys, Is is possible to create a view programmatically and dynamically using deluge? i.e. using a conditional if statement. Rgds and Thanks Andrew
Problems with "parent window" openUrl function
I have my Zoho application embedded in my website. Today I just noticed that many of our application's buttons aren't working. They all use the parent window parameter in order to refresh the iframe its embedded in (I have a website with my zoho application embedded in an iframe. Some zoho applications views has iframes embedded so I use 'parent window' to refresh just the main zoho application iframe). I wanted to ask if there has been any recent changes (implementation wise?) to the openUrl
Need to remove or hide Duplicate option in my view
I don't want users to be able to Duplicate a record in my view. I set permissions so that the "Duplicate" option is not checked, but it still shows up in the menu. I found something about the view parameter below, but I don't know how/where to use it: Show/Hide "Duplicate" option zc_DuplRec=<true/false Any help is appreciated!
Is Zoho Creator Report Shows Real Time Data?
Hi, I'm created a simple report and placed it into my dashboard using iframe. But then I noticed that it's not taking the real-time data. (I've added an record but it's shown in the reports only after like 5 mins?) May I know what is the refresh frequency?
Is Zoho Creator Report Shows Real Time Data?
Hi, I'm created a simple report and placed it into my dashboard using iframe. But then I noticed that it's not taking the real-time data. (I've added an record but it's shown in the reports only after like 5 mins?) May I know what is the refresh frequency?
Is Zoho Creator Report Shows Real Time Data?
Hi, I'm created a simple report and placed it into my dashboard using iframe. But then I noticed that it's not taking the real-time data. (I've added an record but it's shown in the reports only after like 5 mins?) May I know what is the refresh frequency?
arithmetic operators of properties in a form
Hi, I create a form and want to do some simple arithmetic operations of column properties like "column C" is equal to the product of "column A" and "column B". So how can I do that in the script? Thanks
Stuck on "Loading Form... Loading View..."
Any idea why it just says "Loading Form..." and "Loading View..." when I open the program? Nothing else happens except for displaying those two messages. Thank you.
Problem with compare date
I'm trying a few weeks ago to do the following without success, if anyone can help me i will appreciate your help. I have 3 forms one is for the employees, second are a list of projects and the third is where I assign an employee to a project. My problems is that when the user try to assign an Employee two time in same dates i need to send an informative messages to the user, without use cancel submit (if i use this line i can see the message but can't save the record) In this form (Assign Employee)
Back up frequency and limitations
Hi, I have questions regarding zoho creator back ups. Are they automatic or do they have to be done manually? If they are automatic, how often are they performed? What are the size limitations for backups? In the event that I want to restore a back up, what is the process for getting it restored?
Removing an element from a Lookup List
I have created a Sales form for a sculpture exhibition we are organizing so each item for sale has a unique identifier. Once an item has been sold I would like that item to no longer appear on the lookup list, can anyone help me out with this?
Please take pity on me...
I have no idea what I'm doing, and I'm hoping someone will come to my rescue: I am trying to organize this data regarding participants in a program we're doing for children living in poverty. I need to collect this information grouped by "family" Participant Name Participant Age Participant Gender Participant Ethnicity There are 19 program sessions. I need to track who attended each session and then be able to pull out demographic data by session as well as by all the sessions combined so I can
Automatic Update of Variable Names in openUrl Calls
If Deluge enables the name of a variable to be read then the openUrl Deluge statements could automatically update if Form and/or Field names changed. e.g. where DelugeName() is this mythical function openUrl("#View:" + Form_Report.DelugeName() + "?" + Field_1.DelugeName() + "=" + input.Pass_Variable1 + "&" + Field_2.DelugeName() + "=" + input.Pass_Variable2, "Same window"); Is this possible? If not could it be done? Does it make any sense or is it a daft idea?
Reports disappearing
I can't seem to find reports that I created earlier. Can you please investigate what has happened to the following reports? https://creator.zoho.com/essistmgmt/assets/report-embed/TELCO_SERVICE_ORDERS_BY_STATUS/ https://creator.zoho.com/essistmgmt/assets/report-embed/TELCO_SERVICE_ORDERS_BY_USER/ https://creator.zoho.com/essistmgmt/assets/report-embed/MONTHLY_TELCO_SERVICE_ORDERS_BY_SERVICE_TYPE/ When I try to view the links, I get the following error message There is no such view in Zoho Creator
Issues in using multiselect Field ?
Hi, I'm currently evaluating Zoho Creator. I have an access app that I am are trying to replicate on Zoho. So far I have done with replicating one of our access form. I have a MultiSelect text field in that form and I'm populating options in this field from 2 zoho database views/tables using deluge fetch function. Problem here is, I want to show data from 3 different columns in single option. So I done that by appending data from columns into a single string. Check below, for each moveReq in move_quotes
View code not generating properly
I have noticed that for a number of views, the fields listed in the display columns are not being displayed in the view. View: https://creator.zoho.com/essistmgmt/assets/#View:PROJECT_View1 Note, the application is shared for support editing With the current example, I have selected the following fields to be displayed Fields selected Fields displayed PROJECT ID PROJECT NAME PROJECT DESCRIPTION CUSTOMER AGREEMENT PROJECT STATUS PROJECT MANAGER PROJECT ESCALATION FINISH DATE START DATE PROJECT BUDGET
Error while trying to edit a View
Hi team ZOHO I have just started to recieve the following error when I try to edit one specific View in my application. [ServletException in:/jsp/edit/view/viewedit.jsp] null' I can still edit other Views without any problems and users can still access the view in question, I just cant edit it. Any help greatly appreciated. Regards Simon
Why Not Data that had been entered and stored has been disappeared
Hi Please help me that subject on this mail. The detail is quite simple, all product data that I had entered has been gone!!! It had been stored correctly but, just a few minutes ago, all data had begun not to show up. WHy??? What the hell happened?? Please Help me.
Right Click Menu of the new UI hidden by Chrome Browser Right Click Menu
Not sure if this is already on the bug radar - See the browser right click menu appearing on top of the new right click menu introduced in the new UI. Regards Moiz Tankiwala Smart Training & IT Solutions
Really Need Help with Stateless Forms/Search Interface
I am having incredible difficulty trying to use a stateless form to create a search interface for going on a week now and I'm hoping might know what to do. I would just like to be able to search the data that people have submitted to my other forms by the email field. All my forms have an email field, and being able to search the stored data (from all of my forms) by email, will allow me to find the information that I need. I've been in contact with Zoho support and they've linked me to guide for
Price List Price Breaks
Many of the price lists I am given by suppliers have different prices for different order quantities (price breaks). Is there a 'standard' way of implementing price breaks in databases. Obviously, I don't want to repeat a complete record of Part_Number, Description, Valid_Date, Supplier etc. but I'm not sure creating another related table/form for Quantity, Price and Lead_Time is the answer. Another issue is importing a price list - most of which list price breaks in separate rows.
Make search work on the basis of long string.
I have created a form in Zoho creator. And in this form I have drop down fields containing data having large strings with special characters. I want to select one of the option listed in the drop down field and make the search happen. But as field contains large string with special characters so it is not possible to make the search work. Is there any way with which I can make the search working.
Next Page