How to count amount of records in a date range
I have a primitive repair form that I use every time one of my customers drops a computer. I would like to make a line chart report to show me the amount of repair forms I have filled out per day. is there any way to do this?
Unable to save changes to Column Properties.
I am editing the "Child's Registration Full Database View" for my GHF Camp Registration 2010" application. I am in column properties and try to save changes after asking to sum various number fields. I am unable to save the changes. Nothing happens when I click "Done". I have had this problem before and it still is there. It is a simple operation that should make a users life easier. I also tried to click the "Custom Actions" link and it does not work.
Problem with the values of multiselect fields at On Load
One of the new features, as it is written here, is More than one value can now be passed as parameter value for multi-select field to set default values while loading a form It is great, but I discovered a problem related to this feature. In the forum topic related to the completion of the third community feature (see here) there is a link to a public demo application meant to illustrate the use of the new features. http://creator.zoho.com/sampleapps/custom-action-example#View:Employee_View The application
Creator vs. CRM
What is the difference between Creator and CRM? We are trying to decide which solution will help us, we are a small real estate company Thanks
How to use the encodeURL script?
I am trying to show a shorter URL in the address of my form. Currently it looks like this: http://creator.zoho.com/schalfant/vin-database-form/form-embed/VIN_Database_Form/zc_InpFieldWidth=200px&zc_TextAreaWidth=400px&zc_TextAreaHeight=200px&zc _DropDownWidth=200px. I would like it to look like this: http://creator.zoho.com/vin-database-form/ To my forms On Add / On Load I added the encodeURL script myURL = "http://creator.zoho.com/VIN_Database_Form/"; encodedURL = encodeUrl(myURL); But the
Send Txt Idea
The same way there is an option for send email within scriptting imagine if we could send txt as well.... this way our client data bases can be extended to mobile messaging in addition to email communication. i.e. if ( Clients == "birthdate" ) then send txt ( " Congrats!!! Here is a free cupon )
Script to Disable Right Click for Form
My users are circumventing the input form by right clicking on the form to get the url address then going straight to the database. This defeats the purpose of the database. Is there a script I can add to the form to disable the right click function? To understand what I am talking about please go to my website (http://www.autovinvent.com/vindatabase/) and right click on the form, select properties and you will see the url for the database. Thanks in advance for any help.
Linking Creator with CRM
I just signed up with Zoho toady. My company already had a CRM established, I created a product registration application in Zoho creator. Is there a way I can link the registration with the crm so it can be accessed via a tab. Any information would be greatly appreciated. Thanks, Kyle
copy application with data
Is there a way to copy an application compleete with data? Or to transfer data from one form to an other identical? My form have lookup field. Thank you in advance for your help Lucia
LOVE IT
I love this form builder... the best form builder i ever built and seen..
My Users can't Edit, and I need them to.
Hi: My Users have the "Developer" setting, but they don't have the Developer menu items, most importantly the "Edit" item. I need them to be able to Edit. What can I do to fix this problem?
"function executed successfully" - why is this showing
I have a view called Add/View Donations. On this view, for each record there is a custom action button 'Add Donation', that allows a user to add a new Donation record, associated to this contact. This action button triggers a function that reads as follows: "void newfunc.AddDonation(int id, string lastname, string firstname) { openUrl(((((((((("/" + zoho.adminuser) + "/") + zoho.appname) + "/#Form:Donations?Contributor_ID=") + input.id) + " && Contributor_Name=") + input.lastname) + " && First_Name=")
I cannot edit form
Hi, I made a change to one of my forms yesterday and something has gone wrong. I am no longer able to edit this form (i can still edit others) and the field I changed doesn't show on the edit form page any longer. But it does show when viewing the form??? any help would be much appreciated all the best David
Transfer Ownership of a Database
How can I transfer ownership of a database to another user?
New save message
I LOVE THE NEW MESSAGE!!! "Script saved" is so much more helpful!
colors in views
How can I adjust the color of a record in a view based on a change in the value of one or more of the fields in the record?
Authorization Failure
I get authorizatin failure when I try to create records from my sitekreator website. The error message states that the user does not have accesss to ADD records. Do I need to make my Form Public?
Data on my sever and NOT on Zoho server
Can data filled by the user be hosted at my institutional server INSTEAD of Zoho?
Public access
Trying to allow public access to my web form but its not allowing me.
Can you export your view data to excel if embedded to a website
Can you export your view data to excel if embedded to a website? I do not have the More Actions feature on the embedded form on website like I do in zoho creator THANKS!!!
Access migration tool: login problem
Hello, I'm a user of Zoho Creator but my Zoho account is linked to a gmail one, so I log in with my gmail credentials. I have had no problem except now when I try to use the Access migration tool to Zoho Creator, when it asks for the username & password, I can't figure out what should them be to let me upload the database. It keeps saying "Username or Password is incorrect". I've tried with my gmail address and putting just gmail username. What options do I have? I have tried to create or associate
Calculate Stock
Hello, I'm developing a app that will control a small store. My quastion is: I have the tables "Products", "Buy" and "Sell". The last two are related to the product. How do I sum all the records in the tables (Forms in Zoho Creator) "Buy" and "Sell" related to a specific product then I'd have the calcylated fields "TotalSells" and "TotalBuys", the i can calculate the remain in stock using TotalBuys - TotalSells Thanks. Waiting your help... Rodny :)
Form in form
Hi I have a form(lets call it Form A) in which a certain value in a dropdown list should activate a popup of a new form(lets call it Form B). This I have done in my application. But how do I link the two forms together, meaning when I go to the view of form A I would like to see a link to form B? Dennis
Missing States
In the preload states you are missing 8, LA, PA, ME, KY etc
Can a developer add fields
I have set a user to be a Developer, can he change/add/delete fields in an application that has been shared to him? I thought the "Edit this application" link would show when he logged in, but it doesn't. any help much appreciated David
form design
I love this application so far (after about 10 minutes of tinkering around). I notice however that the actual customization of the form itself is limited. I cant space the fields to my liking or put any other customizations there. The following features would be a great addition: 1.) a 'drawing' toolbar (text label, line, box, circle, etc) 2.) a text formatting toolbar(font size, color, font) 3.) the ability to place the fields anywhere on the form (not just snapping under the field above) thanks,
I cant view 'API Docs' under the help menu ???
I'm trying to view the link under my 'Help' menu called 'API Docs' but when I do it says I dont have access. What is that about? Why give me a link under help if I cant even see it????
New error - java.lang.Long
Hello, This refers to my application : https://creator.zoho.com/stressrecess/therapists/#Form:Contractor_Invoice When I open existing records and try to update them, I get an "invalid entry error" with a link to click to "view error details" which then says the problem is "java.lang.Long". The one forum discussion on this topic does not contain an answer. My app is shared to zoho support: I have some additional information:1) I am not sure exactly when the problem began, because no one
IE8 warning for HTTPS forms UNRESOLVED!
sorry to post twice but it has been 2 days, this is a timely issue. IE8 gives the following warning when loading an https form: Do you want to view only the webpage content that was delivered securely? This webpage contains content that will not be delivered using a secure HTTPS connection, which could compromise the security of the entire webpage. This will scare away some people from entering info, and perhaps it isn't secure. I need https because I am having students input personal data. Is
minor issue
Please note the Community Links "link" has been broken. It now says: http://help.creator.zoho.com//Community.html
No requester password?
When I create a requester, they receive an invitation. When they click on the link, they are asked to provide a password. There is no password created when the requester is created, nor is there a means to do so. If requesters cannot log in, the app has no use at all.
Question about embedding into site
Hello, I've made a small library of all our music pieces (we're a concertband). When I embed this into our site, how can I make sure the users can only consult and search in the DB, without changing or adding entries? JJo
Today isn't Today
I have a Zoho application that uses a couple date/time fields, and have the settings of the application set up as New Zealand Standard time, but the "Today" button on the calendar control shows tomorrow's date. This is affecting my application as one of my views was configured to show data from Today. I would appreciate this being looked into. Thanks, Leo Saumure
Dublicate enteres in temp table
Hello, Please, help me. I wrote view https://creator.zoho.com/aerosib/testapp/#View:carTrans It generate temp table carTransTemp with function cargo.fillCarTransTemp(date dt). Formally it is select from autoTrans group by manager, fromFrgt etc Sometimes in temp table i have dublicated enteres, some times all ok. And i cant find some depend between my actions and result.
Creator very slow at work, but fine at home
I have a Zoho application that is virtually unusable at work, but seems to work wonderfully when I work from home, and I'm wondering why this would be. Every other webpage that we access from work seems to have no issues, regardless of the fact that they are straight html, asp, or heavy with javascript as Creator is. As I am not a network administrator, are there any Zoho techs who would be able to offer a solution as to why this would be? I don't think it has to do with bandwidth as every other
UPLOAD URLs
I cannot get URLs to upload successfully. I would like to upload URLs with a Title. I have tried from Access, Excel and by pasting, all without success. I can get the URL path to upload so that it works as a functioning URL link, but the "Text to Display" gets lost. Have you any thoughts, tips or suggestions, please?
ZOHO Creator is extremely slow in the last hour !!!
In the last hour, response from ZOHO Creator is extremely slow ... what normally takes 3 to 5 seconds is now taking one to two MINUTES !!! Initially, only Edit Mode was slow ... now both Edit and Run Mode e.g. add a record with two fields (no scripting involved) takes over a minute. Other ZOHO Services (like this Forum) are responding just fine !!! Gaev
Views from multiple forms
Is there a way to make a view that shows data from multiple forms without having to add that data to a form through the use of a lookup field? So if I have forms that have data like this: form 1 ID, Name "1","Jim" form 2 ID, Address "1","123 Main St" I want a view that shows the below without having to add a name lookup field to form 2: ID, Name, Address "1","Jim","123 Main St"
One view that is conditional by user
I have a view I've created of a form. I want to set up the view so it only shows information that has been assigned to the user that is viewing it. I could make a new view for each user, but I have many users. Is there a way to make one view that shows only the information assigned to a user that is conditional upon which user is viewing it?
Form is missing/dissappeared
Need immediate answer: One of my forms has dissappeared from the Forms view. I can still see it in the Live application, but can't edit it. HELP
Next Page