CloudSQL API: "SELECT * FROM ..." causes error.
I tryed to query "SELECT * FROM Sales" to "Super Store Sales" Database. That caused error. And, querying "SELECT [Date], Product FROM Sales" is OK. In the while, querying "SELECT * FROM OTHER_TABLE" to the table is OK. Maybe, if "TABLE" has the column named keyword, querying "SELECT * FROM TABLE" causes error.
Printing Tables or Reports
What is the process to print a particular table or report?
Errors When Loading (Opening) Page
Anyone know why Zoho would just spin and spin and not pull up my tables? I get a page error. Oh, and what does this mean: DDLTIME is not present in the request parameters list
Adding Forms, or merging Zoho Creator with Zoho DB & Reports
Hello Zoho makers, ===================================== I need something like the following model: Shared Forms: for users to enter data Private Database Manipulation: for me to automatically merge, classify, ... data Shared Views: for users to view the well classified data. ===================================== If I understood Zoho correctly, I found that: Zoho DB | Reports has the Database Manipulation and the View Feature, but no Form feature. Zoho Creator has the Form and the View Feature, but
Linking data to other applications
I am interested in using my data in my Zoho DB in external applications. Is this possible to use this data in say external web applications or even desktop applications like ESRI GIS, for example?
i can't add row to table using restful api.
I want to add data to my table using javascript and zoho's restful db interface.But I always got error like this after invoking, <?xml version="1.0" encoding="UTF-8"?> <response uri="/api/blueocci/voca_junkie/word_list" action="ADDROW"> <error> <code>8016</code> <message>You need to have atleast one column for INSERT or UPDATE action</message> </error> </response> Anyone can help me figure this out?
SQL query with LEFT JOIN doesn't work with lookup column
Hi, I think there's a bug within the SQL functionality when dealing with lookup columns. I've got two tables with information on conferences and the talks that are given during these conferences: The table "conferences_list" contains all conferences (dates, location, website etc.). The table "conferences_contributions" contains details on the talks planned for these conferences (title of contribution, people involved, other details) PLUS the name of the corresponding conferences as a lookup column.
Can't access links on Zoho DB page
Hi... When I navigate to db.zoho.com the main Zoho DB & Reports page is displayed and I am able to log in. However, when I click on most of the links on the page the result is an "error on page' msg in the bottom left corner of IE 7. I can't upload an .xls file, can't create a blank DB, etc., none of those main links work. Also, most of the menu items don't work either such as "switch to". This doesn't seem to be related to our firewall (we see no firewall errors); however, running IE 7 as a local
SQL & Reports
Step 1: Created SQL table Step 2: Created Report based on SQL table 1 Step 3: Modified SQL table to add another column Step 4: How can I have Report 2 show the new column I just generated in Step 3?
can I link the DB & Reports to a zoho projects?
if so how? thanks
Embed Z DB Report as an Interactive in Google Sites page?
I'm looking for a Dashboard solution to present business data. For good or bad we use Google Sites for our intranet. Is there any way to embed the Z DB Reports as an interactive gadget? Sites let's you preview it, but when you go to publish says it includes an iframe which could be unsafe. I can embed as an image, which is great, but would be better if it was interactive. joe
Add calculated columns together.
Greetings, I am creating a query table. I have two column that are calculated, based on a case statement. In both columns, the result is always a number. I need to ass the two columns together to create a third column. However, it always either gives me an error, or concatenates the two fields together. I've tried using the convert() function to no avail. How can I add these two calculated columns together to create a third numeric column? Example... SELECT case when TYPE in ('type1', 'type2', 'type3')
Autonumber feature?
Hi, I'm new to Zoho DB. Is there an autonumber feature for IDs in a table? For example, I have a table called Organization with two columns - OrgID and OrgName. How do I make sure that the OrgID is generated automatically and is unique? Or is that something I'll have to check as a user when I type in or input the OrgID? Thanks.
Cumulative totals
My situation: I have a list of users and the date they sign up. Currently using Zoho DB I can view a chart showing the number of users that signed up on each day, but I would like to see the total number of users who have signed up on that day or earlier, which equals the total number of users I have on that day. This lets me see a chart with the growth in the number of users I have.
sum in procedure
hi how i can make sum two numbers by using procedure :roll:
Workaround for querying a query table
Hi, I'm trying to create an automatically-updating "dashboard" of Minnesota, U.S. election results. I'm having trouble with the layout of the data, though. It's in a "hierarchical" format and I need to get it into a "rectangular" format. I'm not sure if there's a way to achieve this using Zoho DB. Here's what the data looks like: Precinct....Party.......Votes 1....................D............X..... 1....................R............X..... 1.....................I. ...........X..... 2....................D............X.....
Default Order of Folder View
How can I control how the listing of the folders in the folder view is ordered? It seems that the default order for the folder view has changed. My folders used to default order numerically and then alphabetically by folder name. Now they are in some random order whose underlying logic I don't recognize. How can I control how the listing of the folders in the folder view is ordered?
Update only selected records in view?
I'm not sure how to update only selected records. At the moment when user select lets say 5 records in the view and execute custom function void dateformat.updateDate() { for each ordered in Orders[Ordered=="Yes"] { ordered.Order_Date=zoho.currentdate; ordered.Ordered="Yes"; } } It updates all records instead selected. I couldn't find anything that says how to isolate selected records from the view. Could you please be kind and help me with this problem. Thanks Sasa
Update only selected records in view?
I'm not sure how to update only selected records. At the moment when user select lets say 5 records in the view and execute custom function void dateformat.updateDate() { for each ordered in Orders[Ordered=="Yes"] { ordered.Order_Date=zoho.currentdate; ordered.Ordered="Yes"; } } It updates all records instead selected. I couldn't find anything that says how to isolate selected records from the view. Could you please be kind and help me with this problem. Thanks Sasa
incramental Numbers
How can you create a field that increments for every record?
Refreshing data more than once per hour
Hi, Is it possible to automatically refresh data more frequently than once per hour? I'm trying to put together a database to monitor the elections in Minnesota, USA, and I'd ideally like to get data every 15 minutes. I can do it in Sheet, but there's too much data for Sheet to accept. Thanks, Jeff Rosenberg
Percentages on Pie Charts
It seems like I can show values on pie charts but not percentages of the total.
Link to zoho creator
It will be great if zoho reports and zoho creator can be linked up.
zohoreportsapi.wiki.zoho.com is awesome
hey I do not agree with what you wrote really.... please ellaberate a bit more for me ;D cheers
Granting Data Import rights to multiple users
Hi, I have not been able to grant "Import" rights to db users that I have granted "read/write" access to. I am maintaining the sales reporting data for my company, and we make weekly batch imports from our retailers. I'd like to be able to hand off that importing work to another user... is this possible, or is this on the road map? Thanks, Jamie Sidey
lookup for tables in different databases
Hi there, I am working on databases for the first time. Please clarify my doubt, Is it possible to relate (i.e. use the look up function) for the columns of the two tables where each of the table is in different database. can i expect any such feature or it is invalid into itself. regards! Anand
How to rename tables?
How can I rename tables of Zoho DB? It's ease to rename a database, colunms but I can't found where to rename tables.
Time/Date
Is there any shortcut on the keyboard to automatically update a section with the current time/date. Right now I have to double click the region and select "today". There has got to be a faster way...right?
Web forms using Zoho DB
Hi, Is it possible to create dynamic web forms using Zoho DB as the backend database? Thanks, Yamini
Incorrect sum
Table t_expenses 01/01/2008 $100.00 Entertainment 01/03/2008 $20.00 Entertainment 02/03/2008 $500.00 Transportation 02/05/2008 $10.00 Other 03/06/2008 $100.00 Entertainment 05/09/2008 $60.00 Other 06/09/2008 $40.00 Other I run the following query on "t_expenses": SELECT year(dt.Date_Column) Yr, month(dt.Date_Column) Mth, sum(ent.Amount) FROM "t_expenses" dt LEFT JOIN "t_expenses" ent ON year(dt.Date_Column)=year(ent.Date_Column) and month(dt.Date_Column)=month(ent.Date_Column) where ent.Category='Other'
Refresh of Query Tables
I have one master table and 200 query tables "viewing" data from that master table. When I update a record in the master table, it may affect 20 query tables but since I don't know which 20, I have to manually refresh all 200. How do I do an automatic refresh of all query tables when a change is made in the master table? Thank you in advance for your help.
How to display Currency Data Type in a query report
Hi Zoho Tech Support, I have a query report which sum a column with currency data type. When report generated the sum column can only show ".#" type. How do I add '$' in front of the numbers. Thanks. Sincerely, Lesley
Uploads
I have around 150,000 rows I need to import into an application, on using the upload paste window it falls over on anything greater than 2000 rows - the email function does not seem to work either - can you help please
Explorer and Firefox DB
When I put the Zoho DB URL on my webpage it works in Firefox but not in Explorer. Any advice would be greatly appreciated.
Export to multi-pdf preview
The ability to export multiple reports to a pdf is great. However, there is no way to set a multi-pdf template. I have a multi-pdf report that I need to generate daily. SO everyday, I need to select each of the reports I need and then go about re-ordering them. This takes up a quite a bit of time. Is it possible for zoho to remember the order and reports I require in my daily multi-pdf extract? Nish
Repeating formulas in a query
Consider the following query: SELECT SUM( ... ), SUM( ... ), SomeSolumn My problem is that the SUMs are based on large formulas, and SomeColumn should display the difference between the two. However, I don't want to repeat both formulas. So my approach was: SELECT SUM( ... ) as S1, SUM( ... ) as S2, (S2 - S1) But it doesn't seem to work. Any ideas?
Deleta All Rows [Danger]
I dislike giving my shared users the ability to delete every record in a table with one inadvertent click. It seems that the "Delete Column" feature has been disabled for those with whom I have shared the database...how can I also disable the "Delete All Rows" feature? If this cannot be disabled, is there anyway to schedule an automatic back-up copy of the database so as to have a running backup in case such a disastrous "Delete All Rows" occurs?
Column based on a query
Hello, I need to create a table with 4 columns, the last column being a query on another table. Example: Table 1: User_ID LastName FirstName Expenses ----------------------------------------------------------------- The Expenses column should be a query on another table which takes the user ID in account. The data in the other columns of Table 1 are entered manually. Will a Query Table do this?
DB API
Is the Zoho DB API coming soon? Any ETA yet?
Drop Down Menu Control
In Zoho DB & Reports is it possible to structure Lookups dependent on the value of another field. For example, if from the the Drop-Down Menu for Field "Chapter" one choose ' North ', then the Drop-Down Menu for the next Field "District" would present only those Districts identified as belonging to North Chapter. I have seen where Creator can do something like this using scripts, but if I have to use Creator, then how can I "connect" Creator applications to my DB?
Next Page