XML request
Can we expect XML request, maybe ppl be able to build a xml structure of a table and request it via a URL for integration with other software/websites (ex: rss feeds, custom XML based applications, etc).. if possible allow private and public access to those XML requests via some sort of key?
Copy and Paste Records
For data entry, I often need to enter a new record, where I use a previous record as my source. In MS Access or MS Excel, I would just highlight the row and go to the new entry row and paste, and then alter whichever fields were different. How can I do this in ZOHO db ? An alternative would be to have my old template field as the last one and then Ctrl+' in the new field and the one above would be magically copied into the new field. There may be ways to do this in ZOHO, but they have escaped me
help needed re: links
Does anyone know how to set up a one-to-many relationship between categories/tables? For instance, I have the name of a contact and want to be able to add multiple phone numbers for the one contact (without creating fields like Phone Number 1, Phone Number 2, etc.) I am used to working with Access and don't understand how to set up the relationships here. Thanks -
Selecting most recent record
Hi, I have a table that lists status, date and ID. I am trying to return the most recent status for each ID with a query like this SELECT K."Clinic ID", K."Stauts Date", K."Status" FROM "Status" AS K WHERE K."Stauts Date"=(SELECT MAX(J."Stauts Date") FROM "Status" AS J WHERE J."Clinic ID" = K."Clinic ID") ORDER BY K."Clinic ID" ASC Howver I get the error Invalid column 'Clinic ID' used in SELECT query. * If its not true, kindly enclose the column name(s) within double quotes (" ") if it has any special
Multi-line Graph?
Greetings, I have 3 columns in a table. Total Source Date I can create a line graph with the x-axis being the date, the y axis being the total, which looks great. But, I don't see how to create a multi-line graph with several lines, each one representing a 'source'. I think I can work around this by creating a total column for each source, but I would have thought that there would be an easiser way to do this. Am I overlooking something?
Question about summing rows up
Hi, If I have a table like this: Date Deposit/Withdraw --------------------------------- 01/01 +5,000.00 01/12 -500.00 02/14 +1200.00 03/15 -300.00 Then how to build a report based on the table above with a column which displays the balance automatically? Date Deposit/Withdraw Balance -------------------------------------------------- 01/01 +5,000.00 +5,000.00 01/12 -500.00 +4,500.00 02/14 +1200.00 +5,700.00 03/15 -300.00 -5,400.00 Thanks! Matheus
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.
Next Page