Creating a table from a table?
Ok, I see that I can create a table from a csv. And I can save a query of that table. However, I am unable to reference that query in another query. It seems that I can only reference real tables from a query. That makes it difficult to integrate multiple data sources, each with their own set of calculated column, and then perform aggregation on them. So I'm hoping for a way to either create a table from another table, or reference a query from another query, or use inline views, or something of
Why are you calling it a 'pivot' table.
It doesn't seem to 'pivot'. A 'pivot' would mean that it should be an interactive view, where you would 'click' on a value in order to see the details that make up that value. This is just a cross tab.
Integration with Zoho Creator
Great Aplication!! but, I can't understand why is not integrated with Zoho Creator. To make a sql and or a graph from a Zoho Creator table, I should export to CVS and Import in Zoho DB & Reports ?
pictures in DB&reports?
Been using DB&reports for a few weeks now, mostly to make a database for the school where I give lessons. Everything I want to do works (more or less, with try and error) , but I don't seem to find how to insert a picture into the database. I also tried that in creator, but there's a lot of scripting to do then. The problem is that I can do that, but a colleague of mine can't and he'd be responsible to put in all the pictures. Is there's a simple way to put for example pictures from our students
Once a table is created, and populated with data
Can I 'import' more data into it? For some reason, I am unable to 'import' more data using the 'import' button. i get no result from clicking it. I have several files that I would like to load all into one table.
Is the Decode not working?
Can't seem to get decode to work at all. Even the most basic decodes are not working. decode('test', 'es', '1', '0'), decode(0, 0, 1, 1), both return... An unexpected error occurred when trying to process the request. I also don't seem to be able to get the 'case' and 'if' statements to work.
Is the Decode not working?
Can't seem to get decode to work at all. Even the most basic decodes are not working. decode('test', 'es', '1', '0'), decode(0, 0, 1, 1), both return... An unexpected error occurred when trying to process the request. I also don't seem to be able to get the 'case' and 'if' statements to work.
How to make a public database read only.
Hi, I've just created my first database in Zoho and wish to make it available, read-only, from a website I'm creating. However, when testing access to the db from the website it appears that records can be added/deleted. How can I secure the database so that only my login can make changes? Thanks
Rename Table
Hi, Is it possible to rename a table? Thanks, Yamini
Query Table
Hi, I tried to create a query table using one of the columns in the table in the WHERE clause. However, when I execute the query not all rows are retrieved. I tried View Mode as well as Refresh - the result is just the same. I get only 10 matching rows. How do I accomplish something like this? Thanks, Yamini
Trying to find a solution: building a DB with diffrent types
Trying to find a solution: building a DB with different types of data I'm a student and I rent a flat with roommates. We do our shopping together (e.g. one one us does the shopping for the rest of us). Usually we organize a couple of apartments and do a large scale shopping. I would like to built a DB that will allow each one of us to access and choose the groceries. We should be able to see the items and it's cost. We'll also need to determine the quantity of each item. It should also sum each of
about sahring tables
Hi all! I'm new to ZOHO DB and i'm looking for a feature i'm not sure it exists. I need to create a database that is the sum of some others databases. For example: first database called xxx with some columns as name, surname, address tha is accessible from a single user using a password. The "zzz" database with some columns as name, surname, address tha is accessible from a single user using a password. When I access the other database called "YYY" i can find all the rows of the xxx and zzz database
How do do qwery + how to view data sheets in a more usable w
Hi, I'm not understanding how to do qwary with zoho DB and how to view data sheets in a usable way. Many thanks jacopo
3 programs solved my security problems by using them simulta
Hi, People! Want to share with you the results of my work. I've discovered that these 3 programs solved my security problems by using them simultaneously. 1. Pareto XoftSpy-SE (the biggest base of detected spyware programs) + Web-site: http://xoftspyse.repairandsecure.com/ 2. KAV Internet Security Suite (complete protection from viruses including firewall) + Web-site: http://kasperskyinternetsecurity.triedtool.com/ 3. SpyBot Search and Destroy (the only freeware anti-spyware program!) Web-site: http://www.safer-networking.org/
New to zoho.
Hi. Is it possible to use the zoho database from some other site?
Lookup to MultiLineText / Multiple Select in Lookup Column
Hello, I have two questions: 1- The Plain Text field (maximum 100 width column) is too narrow for my data. On the other had, I cannot use the Multi Line Text type, as I want to refer to this column from another table (Lookup column), and I get an error message. Is there some solution? 2- In a Lookup column, I would like to be able to select more than one item. Is it possible? Thank you in advance and congratulations for this project. Aitor
using the primary count field in reports
Hi there people, firstly, thanks for the excellent work you are doing here at zoho, i have been experimenting with zoho db and am very impressed, recently i have found the need to display the primary record count in my tables and charts, how might i achieve this? also, i know that this was a hot issue around christmas, but can zoho creator feed directly into DB yet? I have a lovely data entry page built in creator, and an excellent databse with usefull reporting tools but as yet can't make them talk
table relationships, cascading deletes/updates
Hi, I'm new to Zoho. Is the lookup column the only way of creating relationships between tables? Is there any way to perform cascading deletes/updates? Any help would be much appreciated.
api to insert data
hi, is there a api to insert data? thanks lovesym
Find or filter in tables
Is it possible to filter or search in a table? When I have to edit a data, I have to scroll row per row until I find the row I want to edit, because in the view mode I can filter and search but I can't edit. When it is a big table it's time consuming...
Creation of table from csv text/file
hello, i tried to create DB(table) from simple CSV text like operator_name;first_number;last_number HU;12450500;12450559 HU;14550450;14550479 HU;15250460;15250489 but in the second step window i see only part of HTML text (please see screen shot). What I'm doing wrong ? Thanks. Best regards, Dav
Using "Like" in Queries
Hi, Can you please tell me how can I use "Like" in the WHERE clause of a select query? By default, the select query table data view shows only 10 records. Is this configurable? Can I have it show more than 10 records? Thanks
Multi-byte laguage import problem
I just started using zoho DB yesterday and tried to import a csv table which I created with MS Excel, by copy and paste method. Then I encountered a garbling problem. I guess that is because the table contains some Japanese characters. For your reference, I included the data excerted from the table below. The first row is for column names. 従業員ID,姓,名,役職,性別,電話番号,携帯電話番号,E-mail,携帯メール,郵便番号,都道府県,市区町村,番地 ,山田,貴,代表取締役社長,男,,,,,,,, ,田中,角栄,専務取締役,男,,,,,,,,
Standard Deviation
Cannot use STDDEV or STDEV in zoho db.
Creator sign-up database
I would like to create a sign-up database for volunteers and volunteer duties. Creating the database is not a problem but when the next volunteer registers I would like for the previous volunteers task that they signed up for not to show and this new volunteer can choose from the volunteer tasks that are left. I dont know how to accomplish this. Help Blair
DB not free after Beta ?
Will Zoho DB not be free for personal use after the beta ?
Buttons with script + create own forms
Hi, This may be difficult, but I would like to have programmable buttons on the existing views, or to have the ability to design my own form with programmable buttons. I presume that scripting will be added to DB. As a Foxpro user I am used to using buttons on forms for data manipulation etc. Cheers, John
Forms
Hi, I need to create form, to allow my coleague fill it with data. Is it possible now? Thanks, Janis
error changing design
When I tried to modify a text field to a lookup field, everything was fine with this field but all the records in decisions boxes fields that I did not try to modify were changed to No. How can I fix this?
Formulas in summary view
Good morning... I have created a table, called Transactions. It looks like this: Date Item Units Price Total 7/1 A 10.0 5.00 50.00 8/1 B 12.0 10.00 120.00 14/1 A 15.0 7.50 112.50 15/1 B 20.0 8.00 160.00 21/1 A 15.0 10.00 150.00 Now I want to create a summary view that shows what items were bought, how many, and the AVERAGE price. I.e.: if add up the units and totals for item A we get 40 units and 312.50; and if we divide by the total by the units then the average price is 7.8125. So
Zoho DB & Reports
I am trying to create a number of tables into which tutors can enter relevant course information about student progress (non-personal data only). I would then like to create a lookup table that is accessible by only the course leaders that would pool all the data entered by the teaching staff. The problem is that some of the fields used for entering data are multi-line and do not appear as an option when creating a lookup table. Is there any way this can be done? ian lake
error in IE when displaying report
I get an error when displaying a report within an IE webpage but not in FireFox. The error states "set proper width & height". I have played with the width and height within the html code but have had no luck. here is the page http://matagordamadness.googlepages.com/whoiscoming please help Blair
Form Letter from Customer list
I'd like to build a list of my customers with the ability to print a form letter that contains the customers address. There could be several different form letters. It would work as follows: I select the customer then I select the appropriate letter for that customer and print it. A report history is kept with the name of the letter and the date printed. I then select the next customer and a different letter. Is it possible to build this type of application with ZOHO?
MS Access Reports
Both Creator and DB are awesome. I am waiting patiently for them to be connected (please make this a priority!) One feature missing though is something similar to MS Access's Reports. What I need is the ability to produce a report that can be printed off in Word or PDF and I haven't found that yet in either 'Creator' or 'DB & Reports' - (I was really hoping that as your DB has 'Reports' in the title that it would be able to do that.) Please tell me if I am wrong.
Relation between 2 sheet (not only columns)
Hi, I've a new question: now I would link 2 Sheets (not only columns), following I try to explain better what I want to do: - I've the parent table, say table A (Clients) - I want to relate table A to a table B where I've the datails of the person that work in the company (CEO, marketin manager....) with all their information (phone, email...). Thanks in advantage jacopo sagramoso
Column could not be modified deleted
There was a formula column called Column_1 in my database. I deleted it. Now I am not able to modify/delete the other columns which were used by the formula column. ZohoDB gives an error that the column cannot be changed as it is used in column 'Column_1' There is no Column_1 in my database !!
How to Open all a Record's Data from within a Summary View
I have an aircraft inventory database at http://creator.zoho.com/mcgeepj2/view/68/. I also have several Views that display fewer data fields than that of the entire database, such as this summary view of aircraft that are only on Static Display http://creator.zoho.com/mcgeepj2/view/76/. From this type of summary view I want to open all a records data rather than only the data elements of that View. For example the first record in http://creator.zoho.com/mcgeepj2/view/76/ summary view is aircraft
Import failure process, interactive desired
It is desirable for the import process to give some opportunity to know what the failures may be, and opportunity to revise the import set-up. Our choices now are to ignore a column, or ignore imported rows, and to re-import, after attempting to figure out the problem, which seems not to have any reporting on the details of the import difficulty, on first try. Some of the items (data in particular fields) at issue may be intended, and perhaps a better choice for the data type will permit imports
How do I get back to Zoho DB & Reports, there is no link
Why isn't the Zoho DB listed under the switch to drop down list? How can I get there?
Error when adding data
I am trying to add a new row of data to an existing database. After I enter the data, I receive an error message when I click "save." The error message is: "OBJID is not present in the request parameter list " Any help would be greatly appreciated.
Next Page