Building up HTML or other strings using lists...
Hi just another tip.. Like other scripting languages there are many ways to concatenate text. One method that get's used a lot in javascript is to use to push string instances into an array and then join the text like this... myList =["<ul id='myList'>"]; for(r in data) { if(this == theOtherThing) { myList.push("<li>"+this+"</li>"); } //end of if } //end of loop var html = myList.join("");
Add Canada!
Hey! Where's Canada? What is up with that? Please add Canada as an option for the drop down location. I'm testing the app for use in our company. Thank you Deb
is there a way i can make columns in a form?
hi am working on a database which has a lot of fields and i am wondering if you can make it into 2 different columns which can be easier for the customers and clients to use. thank for the help E Industries Inc. www.eifis.webs.com
Access problem
I changed the password on our zoho account, but not I can't view our spreadsheets. What's wrong?
Problem in generating of report
Dear Sir, We are having one account at your website. We have nearly 15 fields in our database out of which one is a radio button in which the choice is Yes or no. We want to generate a report which shows only those results having NO as the selection. Kindly advice us how to make this type of report. When we export our data in excel file its generate an error. Regards! Ashish Jain
Database view - Option "search"
Dear all, I'd like to know if with Option "search" in view form, each column can suggest you to pick directly the data (For example, the list of the data uplaoded) instead of "contains, is, is not, is empty...." then type the name. Thanks again for your help.
Date formatting issues
I've seen lots of questions going back to 2007 about formatting the date but most have no responses. Does that mean that nobody at zoho cares to address these questions? I have set in my application settings for the date to be mm.dd.yyyy. When I am inside my application and enter something like mm/dd/yyyy the data gets converted to dd.mm.yyyy. Why? What is it about using "/" instead of "." that the application decides to change my date? Before you come back and say that I should be using
how to use filter on filter in form view ?
how to use filter on filter in form view ? reply.
How to add an image to an inventory form.
I think by adding the image field I expected to add an actual picture. (or at least a thumbnail) If you know how to do it please let me know. Ruth "The Embellishment Lady" I'd like to add the picture to my inventory form for clarity.
Re: How to Insert data In dropdown - Next step - Still not working...
I try to follow the explanation, but still something wrong on my script... See attached My print screen, and error messages i received. Could you have a look, and tell me what is wrong on my script. FYI. Registration form = Import Data form with: Client name field (look up field from New client form) Project name field (look up field from New Project form) Part name field Country form = New client form with: New client name field State form = New project form with: Client name field
View by date
Can I create a view that displays things based on the whether or not the date == today. I have a column with dates in it called date1. I want a dynamic view that will display rows that the date is == today. Is this possible?
unable to add field to form..
Hi, I am making an application in Zoho creator. In one of my forms there already are 40 fields in which there are 10 dropdown fields. Now when I am trying to add more fields to this form - the field gets added in design view - but when I access the application - the field simply doesnt show. Please help - we are stuck.
Custom filter
Hy! I've got a problem with setting the conditions in custom filter for dropdown or checkbox (both have 9 choices to choose from)... If I have up to 7 conditions in custom filter, it's OK, but setting more than 7 conditions (8 or more), it throws me an error! Any suggestion, please? Thanks!
Creating multiple forms?______________________
I am at a loss and not able to create a 2nd form without creating a separate table that stores it in a separate Creator Form. I know how to associate many Views to a Form but each Form I create in "Edit Application" creates different table. I've read all the comments but need someone to walk me through the process. Willing to pay and do via Desktop Sharing. I am not very technical but typically can figure things out. This has been a problem. Will Zoho CREATOR come out with a WIZARD to associate
Select DropBox and update Other...
Hi, my english is bad :( I have two forms Clients and Works... I post all my clients in the CLIENT FORM whit several fields (address, phone, blabla): Fields Importants: DNI (unique number of client) First Name and Last Name (string) And in the WORK FORM: I charge the work (not important now) maked a each user. But Selecting the Field Type DNI: "Import Data" DNI of the CLIENT FORM and First Name and Last Name of CLIENT FORM also... I need to a Script when I select in WORKS FORM a DNI (see images),
how to use another form's field in different form view?
how to use another form's field in different form view? is this possible? how to do it? reply. my email : bhaveshgodhaniya@gmail.com
how to count records in form view?
how to count records in form view? and display it in end of the view page. how to solve it? reply. my email : bhaveshgodhaniya@gmail.com
Search properties
how to have a search function in the form so that i can search for those data available in another form that fulfill my requirement? Thanks
Helpdesk addition
Love this App very close to what I am ultimately after Can we group requesters into accounts? I this way a requester can enter a ticket and we can keep the company sponsor advised (especially if chargeable)
Multi-line field size?
Hi, Is there a way to make a multi-line field have more rows and columns? I want a large field, similar to the one in which I'm typing this forum message. Andrew
Accessing XML attributes Tip...
Hi Just a tip..... If you ever need to drop a bunch of xml element attributes into a map variable. Here's how I did it. //create element variable file = xml.executeXPath("/response/tree/folder/files/file"); //create a map to hold the attribute variables data = map(); //make a list of attributes (note their is a way to do this agnostically where you don't know the name of the attribute //prior. But it's more complicated.. attributes = {"id","created","shared","sha1","file_name","size","updated"};
Message to User
I have a Custom Action that should only be used by the Administrator for debugging purposes. I've written the script for this so it only executes the important part of the logged in user is the Administrator. The problem is that the system gives any user the message that it was succesful, even though nothing in the data changed. Is it possible to give the user a specific message like this? if (zoho.adminuser == zoho.loginuser) { do_the_thing; } else { message "Sorry, only the Administrator
Best way to duplicate data
I want to duplicate both 1) Application and the 2) Data in the application - From what I have read, the only way to duplicate the data is to export the data and then import into a new application - Pls. let me know that there is a better way? Yours truly, Steve Eichenbaum Web Merchandising Manager -------------------------------------- AMG Medical Inc.
How to localize ZOHO login screens
I have noticed the various discussions about non-ZOHO branded login screens, and I am happy to see that ZOHO has come up with a solution that should address most of the concerns. Unfortunately, it seems that while almost any message in the form can be customized (and hence localized), this is not the case with the login screen, and as a result a show-stopper for many international end-users. Is there a way to have the login and sign-up screen localized, and if so, how? And if not, what is the ETA
How to Insert data In dropdown - Next step
Thanks for your help. It's working well. But now I have a 2 more questions: 1) Can we add permanent picture on form. For looking only. 2) Can I have dropdown choices according to my previous selection? For example. In my case i have (client/Project/part) So i'd like since i picked one client, my next box will propose me only the projects of this client. ( Not all the project I have imported in the past) Thanks for your help.
Online presence
Hello, It is not clear to me if the input and output forms are visible to those who have no soho account. For example Input - if someone want to sign to mailing list he as to be a soho user ? Output if I create a product catalog will it be available Online ? Thank you
Multiselect - if condidion to.String
Hi, I have a Multiselect field in which, in On user input, I put: if (input.Setor.toString() != "-Select-") { if (input.Setor == "Assistência") { hide Number1; hide Number2; hide Number3; hide Number4; .... System return that: Error in statement at line number 3 The Left expression is of type STRINGLIST and the right expression is of type STRING and the operator == is not valid here I try to quit toString or put toLong, but nothing. Any help? Thanks Mic
Copy application
Hi, I can't copy this application: http://creator.zoho.com/zoho1/bulkemail/#Form:Mailer System return that: [ServletException in:/jsp/edit/form/newform.jsp] null' Thanks Mic
How to Insert data In dropdown?
Dear All, I'd like to create a drawing data base (Client, part name, updload drawing...) Right now, when i'm importing Data, I have to import all of them one by one, even if data have been imported previously. (For example, same client but 2 parts) That i'd like to do now, it's insert my new data in dropdown, then if I need to add drawing for the same client, i can pick the name in the dropdwon. No need to type it again. Is there sby who can help me? Thanks in advance for your help.
Schedule not disponible
Hi, I have a standard subscription. When I try to acces to schedule service system return that: "Schedules are available only from the "Basic Plan" onwards. Kindly upgrade to a suitable plan to continue." Thanks Mic
radio button columns not appearing in view?
I have a view and 2 columns formatted as radio buttons do not appear in my view. All other columns appear just fine. Any thoughts? If this is not a common problem I can make my app available to support. Let me know. Thanks.
Statement Limit and Clipped Wings
To: Zoho Creator Support & Dev Community Please tell me exactly how to calculate statement limits. I have run into the 5000 statement limit (one individual process i.e., on load, on submit, etc.) frequently and I want to know exactly how to calculate this so I can stay under the bar so to speak. Right now this is how I have been counting... variable = "variable"; = 1 statement for each r in form sort form variable1 range 1 to 3 { get_form = form[ID != 0]; get_form.variable1 = "variable1"; get_form.variable2
how to count records
how to count that how many records we inserted in particular form? reply. my email : bhaveshgodhaniya@gmail.com
zoho displays wrong date and problem ocur while insert textbox control using drag & drop in the form
The date of zoho.currentdate shows the wrong date on any day before 12:00 AM after that it shows correct date. It means before 12:00 AM it shows the date of one ago, and after 12:00 AM it shows correct date. What could be the reason for that? how to solve it? And another one is i cant insert any single line or multi line textbox control using drag and drop in my form i don't know whats the problem. is there any page size limit? My email: bhaveshgodhaniya@gmail.com
PDF Export Broken Again
PDF exports are broken again, again, again. Can we have a permanent fix please!
How to show the image in thunpnail view for the view form.
In the view of the form, for image it is displaying only the name of the image not the thumpnail view? Whether i have to change any settings or else it is an issue??? See the attachment...............
set input field to content of notes field?
I've created a user agreement form, which has a note field that has the user agreement text. I would like a hidden field that gets assigned the contents of the note field that has the user agreement text upon submit (or load). If the agreement language changes, I need to have a copy of the exact text that was in place when each person "signed" the agreement. When I try to do this on validate, I get this error when trying to save: Field plain does not exist in the form User_Agreement When I try to
how to solve a problem
. [t_501594000000013007] Exception occured while setting value in PreparedStatement for the Column [Machine_Un_501594000000018010] Check whether the datatype for this column is given as specified in the data-dictionary .[t_501594000000013007] Exception occured while setting value in PreparedStatement for the Column [Machine_Un_501594000000018010] Check whether the datatype for this column is given as specified in the data-dictionary may email :bhaveshgodhaniya@gmail.com
Can't open the report tab next to my Home button ?
Can't open the report tab.When I click on the "create report tab, nothing happends. There is a button made called report next to my Home button but when i click te button don't fuction. and I can;t create any more. Please help Regards Rob from Holland
Difference in Print Summary and PDF Summary View and Export PDF in IE and Firefox
Hi, I have noticed that when Print a summary view, it does it correctly, but when export it to PDF, it exports it as List. Check : http://creatorexport.zoho.com/dnjs/reco-institution-list/print/New_Reco_Institution_View/Institution=Academy of English and http://creatorexport.zoho.com/dnjs/reco-institution-list/pdf/New_Reco_Institution_View/Institution=Academy of English Also, see the difference in the Export to PDF in IE and Firefox. In Firefox it gets an extra .html added, so it is not opened correctly.
Next Page