How to made condition on drop box listing
We can use java script or not in zoho. One more problem facing on that, I create one drop box in listing cricket team (india, Pakistan, Australia) and another drop box Player name. if I choose India team, I want to show all player name of India another drop box (player name). please help out me. It’s very urgent. Please do reply ASAP. Regards Narendra Singh
Lookup based on previous selection
I want to create a field that is a Lookup from a different table, but I want to set the criteria dynamically based on a previous selection of the user: Example: Table Clients has String Company_name, String Address Table Contacts has String Full_name, Company:=Lookup from Clients.Company_name I want to create a third form that will contain a Lookup from Clients and a lookup for Contacts After selecting a Client and going to selecting a Contact, only contact from the same company as the client will
Look Up not working with drop down (single select)
I am trying to create a relationship using the instructions given here: https://help.creator.zoho.com/Creating-relationship.html I am trying to import a field that contains a list of locations. When I add a LookUp field to the form none of the fields in my other form are displayed (they are all drop down single select). Just to check, I tried using LookUp to create a relationship with another form, the only fields that displayed as an option to import were the single line fields. Why aren't the drop-down
Need help with registration form
Complete noob here. I am trying to make a registration form for a 2 hour school event, that will consist of students choosing 2 separate one hour sessions from 40 choices. Each session has a different number of students they can handle, so I need to limit the number of registrants for certain choices or remove/cap it at a certain number. How do I do this? What would be the code? Thanks in advance.
How to make the url fields black?
Hi, I have a list of links, but they are always blue. Is there a way to render url fields in a different color through css or some way? Thanks Vera
New Currency Types added
Dear Users, We have updated http://precreator.zoho.com with the below mentioned new features : New option to show/hide "Sign up for Free" link from the login box in application live mode. This enhancement is provided(for paid users) under the Application Settings screen. The following currency types are added: ANG - Netherlands Antilles Guilder GHS - Ghanaian Cedi (new) HNL - Honduran Lempira MMK - Myanmar (Burma) Kyat PAB - Panamanian Balboa XPF - CFP Franc (Pacific Financial Community)
Search interface HTML view does not work when embedded in external site
Hi, I recently created a search interface for my view following Latha's article here (https://kbase.creator.zoho.com/forms/search-interface) and this allowed me to create multiple search criteria/filters which is great. However, when I embed this HTML view in an external site, the search interface does not work. I am embedding this view in an external site to allow me to create a really custom header for the application. My questions are: Is it possible to get the search interface to work when embedded
Exception occured while setting value in PreparedStatement for the Column !...
I am getting the following erro and cannot submit my form in Submitted Grant Applications 1 . [t_539276000000011043] Exception occured while setting value in PreparedStatement for the Column [Invoice_da_539276000000477911] Check whether the datatype for this column is given as specified in the data-dictionary .[t_539276000000011043] Exception occured while setting value in PreparedStatement for the Column [Invoice_da_539276000000477911] Check whether the datatype for this column is given as specified
How to pad a string with spaces
Hi Everyone, I have an application that will export records to MYOB accounting, and am trying to set up one field properly. The field will be a concatenation of four other fields. The entire length of the feild must be 255 characters long and have the following attributes: strPO + varCellPadding + cboClient + cboMethod + cboLanguage The trick is that varCellPadding is a variable: varCellPadding = 255 - (strPO + cboClient + cboMethod + cboLanguage) Getting this value is easy, but how do I actually
On user input for a drop down only processes once?
Hi, I have a form with a drop down list. What I wanted to do is each time the user selects a different value from the drop down list to update another field. That works to update a text-field (So when I select sometging from the drop down I place the contents of the selected value in the text-field.) But I also try to update a Note (containing some information about the choice) And that only is updated the first time a user selects an item from the drop down list. Each time the user selects another
Unable to delete a field
Hello, In my SDI tool Parameter Tracking application there is a field named "Delete Me" in the Data Entry form that I can NOT delete. I keep receiving and error telling me the operation failed and to try later or refresh adn try again i have done this with no success. Please help fix this issue. Access has already been granted to support for this application. Jason Rapp
Was this defect not corrected last year ???
Last year I reported the problem with the on User Input sections NOT being triggered BEFORE the on Click (or on Success) sections for Date fields when the user ... a) changed the values via keyboard (instead of using the Calendar Widget) b) followed it up with a click of the Form Button As I recall ... after a number of interim measures, this issues was reported as fixed. I also recall verifying it at the time. Today, one of my clients reported a problem ... which after considerable investigation
How to show only the filled columns in the view mode?
Hello, I have a table in which there is more information in the view mode (the button near delete) than there are column that can be seen in the form actually. I want my users to use the view button to get the extra information. However I do not want the fields that are empty to be seen on the view list. Is there a way to shoe only the field with data entered in this view list? Thanks, Vera
Seperate views based on submitted drop down box
I have a work order app that has a drop down box named submitted by, this box contains different names of people who can submit work orders. Is there a way to have a view based on who submitted the work order? As of right now, the work order view shows all work orders submitted.. Thanks in advance Ken
Stateless Form--------- Looking for Script to find highest value from a different form.
Hello all, What is a script that will allow me to find the following? 1. If a record does not exist in a form, I need to assign the value of "1" to a field in my stateless form. 2. If a record does exist in a form, I need to increment the MAX value found in the record by 1. What is the easiest and simplest scripts to accomplish this task? Thanks, Bartley.
Zoho Migrator generates error & doesn't convert MS Access database
I am using MS Access 2007 on a Windows Vista machine. My databases import very nicely into Zoho Migrator. But, when I try to upload to Zoho Creator I always get the same error: "Problem encountered while creating the application IAMError:Z101:INVALID_TICKET". I have verified that version 2.0 of .Net Framework is installed. Help!
Email notification from field value change?
I have a hidden picklist on my form named “status” that has three options {"Pending", "Approved", "Denied"} and I would like to have different email notification going out to the person who submitted the form when this status is changed. Is this possible? And where can I find some sample code for this? Currently the from generates an email on form submit and the status field is set to pending (hidden field),but I would like it to generate emails when the status changes to approve or denied with
Rich Text Editor - Limited functionality
I had been looking forward to The Rich Text Editor functionality and it will make my Zoho Creator experience that much more satisfying. But the functionality seems limited, at least, for now. As Niskypto has mentioned here, 'on user input' commands do not work for the RTE fields. But the problem seems to be wider than that. I couldn't update an RTE field through an "on-load" command; and the RTE field cannot be updated on input of other fields either. So I get the impression the current version of
PDF generation broken again!
ZC Team, there are still problems with generating pdfs from html views, it takes a lot of time to generate them, and these are blank. I thought that the problem was solved, I understood that there is a problem with pdf server, because it is not new. Please, solve it as fast as possible, I am one of the ones who really need this feature these days (at least until I'll develop an alternative solution). Regards, George
How do I set another individual company as a creator on Help Desk - I cannot pass my privileges or swap it.
How do I set another individual company as a creator on Help Desk - I cannot pass my privileges or swap it.
Re: Problems
Dear Sirs I have urgent problems need your help: 1,The ZC system running so slowly like it SYSTEM CRUSH on today from China's user ,what's happen? 2,I try many time to SAVE SCRIPT in my account,but it's donn't work,always got nothing in the screen,the url address is: https://creator.zoho.com/exportScript.do?appid=142568000000203003&fileType=.ds&sharedBy=(my account) hope get your help. Thanks and look forward reply asap Stanley Guo
about design view
is there any design view (as opposed to table view) option in zoho creator like in ms access? if there is, how can i go to design view? is it possible to view creator application online without logging in like in google docs or in scribd?
How to find No of Fields or Columns available in a Form and refer in views
Do you have any working examples on getFieldNames formdata function
Tabs
I have a database that requires a Billing tab, an Operations Tab, Notes Tab, Emergency Info tab, etc. I don't know how to set up these tabs. Can anyone please point me in the right direction? Thanks.
Function & Pdf
Hi, I have a function that allow to export data of a row of searchable dbase in pdf. I do it with html view called Print. I also tray to put zc parameter to export a pdf with name based on determinate field. But it's so different the language of function compared with openurl. Any suggestion? Thanks Mic void print(int id) { openUrl((((("http://creator.zoho.com/" + zoho.adminuser) + "/") + zoho.appname) + "/print/Print_page/id=") + input.id, "same window"); }
Function PDF - landscape orientation
Hi, I have a function script as { openUrl((((("/" + zoho.adminuser) + "/") + zoho.appname) + "/pdf/Print1/recId=") + input.id + , "same window" ); } I can't add ZC parameter as &zc_PdfOrientation=landscape Any help? Thanks Mic
Zoho Creator Calendar View: Date Display Error
Not sure what happened, but my calendar view is really messed up, with the multiple date squares under one day-of-the-week column. I'm not sure what happened -- I don't even remember modifying it recently. Can someone please help me fix this error? http://cheercincy.com/events/
[SOLVED] Error In Script/View [ServletException]
AppName: Gestione Telematica Casa Status: Private Edit Access to Support: Granted I think this is my fault, since I've eliminated a Form prior to eliminating it's View. View of "Prodotti In Esarimento" and Form of "Prodotti In Esaurimento" works correctly, but when I try to modify Script variables for this form I receive the following error: [ServletException in:/jsp/edit/script/sbuilderedit.jsp] null' Beg my pardon for causing this trouble. Quick Update: I have deleted previously mentioned Form
BUGS (and design concerns) in new feature: Add new entry for lookup form
I love the new feature, but it has a few issues: 1. Not a bug, but a design issue, the label should display in the same style (font size, etc) as the text it accompanies: 2. Bug: The 'Plus' symbol does not appear as advertised. Below is how dev says it is supposed to look, but as seen above, there is no Plus symbol (Firefox latest)... 3. Bug: Changes made to the label name are not displayed: resulting in: 4. Adding new list elements results in very poor formatting of results (see below): 5.
The hard-to-see CURSOR in Free Flow Editor
I remember when you couldn't see the highlighted text in the Free-Flow editor because the highlight color was too dim... but dev fixed it eventually and now you can see highlighted text. But not equally made visible is the insertion cursor in the free-flow editor. I know I'm not alone in this. I often simply cannot visually locate the insertion cursor... it is TOO DIM. How many times an hour does one move the cursor around with the arrow keys on the keyboard and try to find where the cursor went?...
How to Capitalize first letter in Name field
I am trying to capitalize the first letter in the First and Last name fields. Name = (input.First_Name.toUpperCase()).subString(0,1) When you enter the name only the first letter of the name is displayed in CAPS but the rest of the name is not accepted int he field. So the result for example with the name Kimberly it will only execept K in caps. What am I doing wrong?
price field still needs help!
Library Materials Request Form price needs to accept decimals (two) Someone "fixed" the field the other day, but only accepts whole numbers. Need to enter pricing such as 50.75 or 150.50, etc. Still, every time I make a change to this field, the form disappears. This is why I'm not making changes myself. Can I assume I can make changes to fields without form disappearing? Thanks, Leslie
Download into excel
When I try to download info in ZOHO to an excel spreadsheet the data cannot be sorted properly and for number columns I cannot use the sum command Do you know of any solutions to these problems?
On Focus / On Blur for multiple inputs
On a form, I want to get a div to change background color when a user is in either the password or password confirm input fields. I can get it to work individually, but the problem is that I need to be able to capture the active element and then check if it's either password or password confirm. If either is active, I can use the .css method to set the background color or if both are not active, I can reset the background color. I'm struggling with figuring out what element is active. Any ideas?
Fill field if null
I have a form with a with alpha-numeric entry (student_id) which must be unique. If it is entered, I want it to go to the next field. If it is not, I want to fill it with a generated entry (student_id_temp). I am using the MaxValueHolder form to generate a this student_id_temp by adding the number generated to a string. Question: How do I do the "if" statement? if student_id is null then get generated student_id_temp? (I would like it to run on input for the field rather than validate at the
views of multiple related forms
Hi, It would be nice to be able to create views that display columns from 2 or more related forms. Thanks, Anton AntonL ------------------------------------------------------ This is posted using zohocreator feedback form
Public Access is pending
I have a problem with request public my form creator.The message is :Your request for Public Access is pending. Help me.thanks
hi, newbie have created a nice 'Form" using registration template: but cannot see any data, or find any, even when it says it has been uploaded? what am i doing wrong?
hi, newbie have created a nice 'Form" using registration template: but cannot see any data, or find any, even when it says it has been uploaded? what am i doing wrong?
Adding multiple command buttons....
Hi Can any one please tell me how can I add multiple command buttons which perform different functions defined by the user (me)?? Thank you Kind Regards Karan
Cannot export data
I have a few Creator things I run and I want to export the data into Excel. However, I keep getting the message saying Internet Explorer cannot find it. It worked the other day, however! This is happening on all of my Zoho creations now. Is there a way round this please? Many thanks, Gavin
Next Page