How can i generate new query table from 2 database? just like vlookup function
I have 2 database file. I wants to create new query table & wants to append data from both database, which has one or two common field. so, is there specific function available? or is there requirement to write any specific query/programme just like vba macro? If there any available specific example ? or how to create new query? Can i get same data in zoho sheet or zoho creator on periodical interval? Please help
Forms
How can I build a nice looking data entry form from Zoho DB other than entering data in the spreadsheet like form.
Database not found
I'm getting the error below, but the database name isn't incorrect. What may be occurring? ServerException (HttpStatusCode 400 Error Code: 7103 , URI: /api/antoniojspassos@yahoo.com.br/JContatosDB/contato, Action: ADDROW, Message: Database not found! Please check whether the database exists) Thanks! Antonio Passos
Error occured during importing a CSV into Zoho DB
Hi An Error is occured when I am importing a CSV containing about 5000 rows. Error message on GUI says: Processing time exceeds the allowed time limit. Please try it after some time. Error log on API is: 2009/03/19 10:15:22 org.apache.commons.httpclient.HttpMethodBase getResponseBody 警告: Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended. Exception in thread "main" ServerException (HttpStatusCode 500 Error Code: 7017 , URI: /api/keitayone/keita/hrat,
DB Processing Time Exceeds Allowed Time
Dear Sirs, I'm uploading information for my online DB. However it gives an error of: "Processing time exceeds the allowed time limit. Please try it after some time." I don't know what the limits are exactly, but I'm uploading 1.000 records and the page says it should be less than 10.000. Is there a solution? Thanks and best regards,
Zoho DB & Reports Scheduled Maintenance - 17th March, 2009 11:00 PM PDT to 18th March, 2009 1:00 AM PDT (2 Hours)
Dear Users, Zoho DB & Reports will not be available for a couple of hours for an update. Downtime details (2 Hours) : From : Tuesday, 17th March, 2009 - 11:00 PM PDT To : Wednesday, 18th March, 2009 - 1:00 AM PDT We regret the inconvenience caused. Saminathan, Zoho DB & Reports Team.
Is there a function that works like vlookup or a way to relate tables by matching fields?
The "Looked Up Column" data type is neat, but not exactly what I'm looking for. I'm starting with a simple task in order to learn how to use Zoho DB & Reports. I have 2 tables: Appointments to View Apartment: ViewNo. (Auto Number), Contact Date, First, Last, Phone, Date to View, Time to View and Rental Applications: AppNo. (Auto Number), ViewNo. (Looked Up Column), Date, First, Last, Phone, etc. In Rental Applications, I want "First", "Last", and "Phone", to automatically fill in once the "ViewNo."
Won't let me enter a formula and what formulas are available?
In "Edit Design" mode, there is a column labeled "Formula" but I can't get into a cell in that column in order to actually enter a formula. How do I enter a formula? Also, what formulas are available?
My table isn't displaying
at http://lawshucks.com/layoff-tracker/#rawdata it's been working for weeks but today it doesn't
Is it possible to read from text-files stored in Zoho docs that are not shared or published?
Is it possible to import from text files (csv or tsv) that are stored in zoho-docs and are only accessible to the current user? If I were to use periodic import in dbreports could I assume that the zoho-id that imports has access to the same users documents in zoho docs ? Can I either import URL https://docs.zoho.com/<filename+location>; or import in some other way without having to have my pc switched on or read from insecure external sites etc.? thanks. Yost
No clue how to do a Lookup Coloumn
I must be missing something here: how in the world do I make a field show a CHOICE of let's say THREE possibilities? I assume it must be a LOOKUP COLUMN? When I try to add a LOOKUP COLUMN, it won't work, since I can only choose NONE from the file dialogue. It would be better I think if you could define the field as e.g. a CHOICE field (I don't know another word for it). Thanks,
Scheduled import
The tutorial shows a scheduled import option but this option doesn't appear to be available when using Zoho DB.
Find the query that zoho autocreated?
How do I find the query that was automatically used to create a very helpful table when I imported some spreadsheets? It's almost exactly what I need and I suck at MYSQL, so I'd rather just edit the existing query than try to recreate it from the ground up. I want to be able to share filtered results from this table and I understand that I need to create a new table view with the filter built in.
Associating documents with a recods
Many databases today allow records to be associated with scanned images or other documents such as order forms. Is there a way to do this in ZohoDB?
lookedup column - view multiple values
Is it possible to view multiple fields within a lookedup column For example: MEMBERS database ID ...other fields... Member name ...other fields... PAYMENTS database ID ...other fields... Payment ...other fields... The PAYMENTS ID field is a lookedup field to the ID column in the MEMBERS database. When entering the payments ID, I would like to see the ID and Member name from the members database. Currently only the MEMBERS ID is displayed. This would help me select the correct member.
'Data' format during table definition and data import
Hi, I have an excel file with a 'Date' column. The format of the date is dd/MM/yy. In zoho db when defining a table,the default 'Date' format as MM/dd/yy. I go ahead and change it to dd/MM/yy so that it matches my excel file. However, when I import data, zoho DB again defaults to the format MM/dd/yy and asks me to change it to the appropriate format. I have to change the date format to dd/MM/yy every time I import data. If I defined the date format I require during the table definition, then why
Report from data in multiple tables
Is there a way to create a report that displays data from multiple tables? I have 3 data tables in my database and want to build a report that combines data from all 3. Thanks.
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?
Next Page