Sort on a View
How can I sort a column on a view? paula.dobbins
How to? change layout and colours and fonts
Hello, how can I change the layout of the application to match my website? With that I mean colors, fonts, fontsize, background image for application. best regards and keep up this great work!
Error occured while uploading the file.
I got this message while attempting to import a csv file. Error occured while uploading the file. Please fix the below errors and upload your file again. java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's""') OR BINARY `t_154042`.`Status_299_299715` IS NULL )' at line 1" William...
Rounding Decimals
This application is awsome but I need help telling the program NOT to round the decimal to the next whole number. PLEASE HELP! jsoto
IF-expression
Is it possible in one form to use a if-condition for a formula??? f.e. muffin( type = picklist values = {"yes", "no"} bill( type = formula value = $drinks*1.5+$lunch*12.0 ) and now i want to have an if condition: if(this.muffin == "yes"){ $bill = $drinks*1.5+$lunch*12.0+$muffin*5 } else{ $drinks*1.5+$lunch*12.0 } and the question is: is it possible??? and if it is possible how? where do i have to use the if condition in "muffin" or in "bill"?
How to pull Free Text value into message body
I am trying to pull a free text field from my form into the message of a sendmail script. It looks like this needs to be an on submit rather then an on success action because the FreeText field does not show up as an available field in the on success tab whereas it ddoes show up in the on submit tab. I just can not get the syntax right. I have tried this.FreeText and input.FreeText but when I submit I get the error that no value has been submitted. Please advise. Thanks!! fuzuku
Problem w/ Permalinking a form directly in Sharepoint
Hello, I want my form to show up on my Sharepoint page. Under the forms 'More Actions' drop down I selected 'PermalinkMy Form' and disabled private link for this form. In my Sharepoint web part I added the permalink http address to display the form. In Sharepoint it displays the correct permalink in the address bar but the page displays: You are trying to access a private form in Zoho Creator. Click here to Sign in and see the form How do I get it to display the page directly, bypassing the login
form number is zero
Hi: Similar problem to one I've had before. When I go to embed a view from one of my applications, it's not rendering on my blog. If I use the "embed this page" link to get the iframe code the message on my blog is that the view doesn't exist at ZohoCreator. If I use the "embed in your website" link in the More Actions menu the form number is "0" it says it's invalid. This seems to be a continual problem. Is it something I'm doing wrong to effect the formation of the iframe code? Is it a problem
Today's upgrade
Hi Guys I've just logged on after the latest upgrade and I've spotted two major changes, a spreadsheet view, and the ability to create a view with columns from other related tables. I haven't tried it yet but it looks like fun! Keep up the good work! Lee
No Delete Confirmation?
There does not appear to be any Delete confirmation in the list view. If you select several records, and click the delete button by accident, you're out of luck. Even the bulk edit has an "Are you sure?" verification. derek
Single Record View
Is it possible to get a single record view that has edit options for the individual fields? Thanks, Mark zoho
Creator
I don't see a way to do a lookup...for example lookup an inventory number and return the price of that item. Or, lookup inventory number and return price and manufactuer name. Also, the document upload works OK but when I click on the URL of uploaded document, I want to have the option of viewing it as well as downloading it. I don't see how to read an uploaded document without first downloading. martin.rini
Redirect script/command
Need a deluge redirect script for "on success" in Zoho Creator form - need to redirect respondent to a download URL. Am I missing a basic function? kristian.vanberg
Backup all data in application?
Hi Friends, Is there any way to backup all data in my application in one step? I know I can download the application script or download the individual tables but it seems like a hassle to individually download minor tables such as picklists and free text items. None-the -less it would be a lot of lost work if I accidentally deleted my aplication and had to recreate all this stuff. Thanks for all your help!! I am beta testing Coghead and I think at this point Zoho Creator is a more flexible platform.
Is it enough powerfull?
Hello. I've been using in a start Zoho Writer a bit of time, but by the pass of the same, i've been arranged to the use of Zoho Creator. Is easy to use and script, but i wonder: Is enough powerfull to create a Web 2.0 based videogame? รด.o Thanks. ~Begeo titowario
Aplication dissapeared
I've created a form application that you can see here http://veniceoffortlauderdale.com/main/reservations/ Sometimes works and sometimes is asking to login in to zoho to view the application and sometimes it says doesnt exist. Now if I login into my account , the form is not there and i cannot view any of my other form neither, I really need this application working. I'll appreciate any help. Thanks Carlos
Input access based on other form field
Access to a field has to be decided based on other form field. For example, only when the 'Medical Profession' is checked, then user should have input to 'Medical Profession Type', otherwise no access to that field. How to set that in the script ?
Uniqueness based on two fields
I am able to set a particular field to unique. Sometimes, my requirement is such that combination of a field has to be unique. For example. Name of person and date of birth combination has to be unique. Is it possible to set that in GUI or script ? Thanks.
Explanation for error message
Hi, When I try to save a data, I am getting the following error message: 1 . [t_17143000000004266] null, message from server: "Duplicate entry '' for key 3". How to find which is "Key 3" ? NOTE: Moreover, in this entire form, I have only one field as Unique and the data I entered is definitely unique. So, this error makes me wonder whether there is any error in the application ?
Size limits
It would be so helpful if this program enabled you to limit the number of enrollments in a particular class so that when an enrollment came in after the specific limit, a page told them the class was full. Short of that, a time stamp function or the ability to receive the enrollments IN ORDER (not randomized) would be helpful to see who registered first, second and so on. Any ideas or suggestions? jbogart
Unable to Create Form in Application
I have been trying to create an application today. It allows me to create the application, but when I try to create the form, and press proceed, it locks up and says there is an error on the page. Please Help! The app is Training Tracker
filter drop-down window too small
the filter drop-down window is to small to read some of my longer entries. can you please expand this window? hughes
Duplicating
I chose an application and pressed duplicate. It said it was duplicating but a second application did not appear. Was that supposed to happen? bradwilks
Error executing if/while condition
Hi. I have the following code in my Guest Tracker application, which worked fine in the past. Now every time I add a new guest the new record gets updated but I get an error in the 'on success' function. Is this a Zoho bug? I haven't changed the logic. I've shared my application with support. Code is below: on success { input.Modified_By = zoho.loginuser; input.Modified_Date1 = zoho.currenttime; if ((input.Latest_Contact_Date is null) || (input.First_Visit > input.Latest_Contact_Date)) { input.Latest_Contact_Date
Many tabs => keep within edges of the screen
Awsome application! Can't beleive it's free! Feature request: When the number of tabs in an application get too large, they move beyond the screen border. As a result, the views within each tab also stretch beyond the screen border. It would be nicer if a second line of tabs would appear as soon as the tabs reach the edge of the screen, keeping everything nicely within the edges of the screen. aloys
Date
It would be nice to have sysdate / now() type function so I can have date from and date to and then filter for current. Working on tracking program for local non profit. Thanks jeffj
other users in internet can edit my data
hello. how can i eliminate add, delete and bulk edit in view table, that other users can not edit and add or delete my informations. it seems that the edit of view table ( check box define other users dont edit data is not working). please help me thank you h_pirasteh
"slow" to load iFrame / Zoho Creator main page
Greetings- Just yesterday I began exploring Zoho Creator, and have been very impressed with it's features...however, with Zoho in California (I believe) and my computer in Roanoke, VA (southwest VA)....it takes via a cable modem approximately 10-15 seconds for the 6 question iFrame to load and then it has taken up to 10 seconds for the Submit button to load the "successful registration"/redirect page. Is there anything I can do to help decrease the iFrame's load time? Or, are the plans in the works
application is too slow
can someone tell me why this application is so slow? it can literally take up to five minutes to edit existing data. for example, when i click the 'add' button it takes a minute or two for the 'add' dialog box form to pop up. it then takes another minute for the application to acknowledge you hit the 'submit' button. and it then takes another few minutes for the changes to actually take affect. and sometimes the changes never take affect but instead pop un an error message. i love zoho creator but
Incompatible with Internet Explorer?
So, is it just me or does Creator not work with Internet Explorer? When I click on the "Record Summary" button, I get the summary view, but it won't go away like it does with Firefox. None of the backgrounds links work either so I'm forced to close the tab/window to get out/away from the page. I'm using IE7. derek
vary Expires: HTTP header for exported data
It would be a nice feature if the administrators of Zoho Creator applications could adjust the HTTP Expires value for the View data exported via JSON, etc. I believe that right now it defaults to something like Expires: 1969-12-31 16:00:00 but if there were some flexibility here, mash-ups could be configured to rely on cached data under certain circumstances like when the live application is unavailable. Just an idea! Thanks, -pete
Review
Outstanding lubbsd
can't create link in plain text field editor
I can't create a link in the plain text field editor. When I click on the link symbol nothing happens.
"Import Data" option for embedded forms in private
Hello. Just wondering if it might be possible to allow signed-in users the ability to use the "Import Data" feature of forms when those forms are embedded via iframe or otherwise referenced directly like http://creator.zoho.com/myuserid/form/123/. Thanks. -pete
default sort
Is there a way to specify a field to automatically sort by in a view. And also to specify sortorder = descending. It seems like the capabilities are there but I just can't find the exact Deluge script syntax or example. I have also seen similar requests from others, but no update on the status of these features
Account Setup & Login Problems
I recently installed your Zoho CRM package & have hit a couple of snags. My problem is two fold; the first issue is that when I set up my I.D I was informed that I would receive an email to which I have not yet received. The id was set up using an email address which is working fine. I also added a user to this account through the setup list of options, this user not only failed to receive the email but when an attempt was made to log in using the credentials set out by me, she was unable to log
View Bug
My views seem to be created correctly, but when you submit data it does not capture data. In addtion, when you go back to edit mode the view is suddenly grayed out. tloranger
adding users : not a valid e-mail address
The organization that I work for, has the domain : http://www.rcps.info; and our e-mail addresses end with rcps.info. However, when I try to add a colleague as a user to my applications it says that her e-mail address isn't valid. I know her e-mail address is valid, is it b/c the e-mail address ends with .info? jlincoln
import field from a different app
Hi i would like to be able to create a form and add a field to import data from a different app. not the one i am creating the form on. is that possible? thanks
hidden fields
hi this is might simple to implement, but i cannot do it. here is the scenario. i have a form that a client uses to submit information about activities. the maximum number of activities are 6 e the minimum 1. so the client has to be able to choose the number of activities, say 3 and the form with fields for 3 activities will load for him to fill in. i do not want to show all 6 possible activities if the client needs to fill in the fields for 3 only. how can i do that? thanks
Next Page