if then formula for text input
I have a members table in DB. One field in that table is Date of Birth. I would like to have another field that shows a level of membership available based on a calculation using the date of birth and today's date. For example: A person born before 31/12/2991 should return a value of "Cadet/te". If someone is born later it would return "Junior". How would I do that? Dave
Query Based on Date
I have a table where I track club affiliations. Each affiliation has a start date and end date. I would like to make a query that displays only affiliations that start after a certain date but I cannot get the SQL to work. Here is my statement. SELECT "ClubName","Region","ClubWebsite","VenueName","Address1","Address2","Town-City","PostCode","VenuePhone","startDate","endDate" FROM "Clubs","Club Affiliations" WHERE "startDate" >='2007-09-01 00:00:00' I get no records even though I have several affiliations
SQL Syntax problems
Hi, I'm trying to execute a join and am having trouble. Could you please have a look at the code and tell me where the problem is. SELECT * from "FT-EMBA-Rankings" join "names" where 'FT-EMBA-Rankings.ID' = 'Names.ID'; Thanks. Richard
strings and numeric calculations in same field
I have a fairly complicated query, which includes a field that has strings and numeric calculations concatenated. It looks something like this: SELECT INT(COL_A) || ' to ' INT(COL_B) FROM ... When I execute it in the edit mode's preview, it looks okay. when I save the query and execute it in view mode, it puts gobbletygook in there (looks like it might be a pointer). EG: [B@619a1a10c they all begin [B@ followed by a number in Hex, which makes it look even more like a pointer. - Paul
Setting missing values to null for sorting
Hi, Could you please tell me how I can sort columns in ascending order for columns that have missing values. At the moment if I sort like this, all the rows with missing values appear first. Thanks Richard
How do I limit the number of columns displayed in embedded
Hi, I would like to display only certain columns of my DB on my various web pages. Can you please tell me how to do that, and also how to disable the editing function in the website embedded table. I do not want my site visitors to change my data. Thank you Richard
Multiple users on the same table
Hi, I noticed that two different users can log into Zoho DB using the same username and password (which is fine) and are able to open the same table simultaneously as well as make edits at their respective ends in the same table, and there is no warning given to either one that the table they're editing is being edited by another user. Is this a design feature? And, how can I get around this so that only one user can edit a table at one time? Shouldn't a table be locked down when it's being edited
How to sort on multiple columns in a table?
As the subject line says, I would like to sort data in a single table based on multiple columns in order, for example, first by "State", then by "City" then "Lastname." Is there a way to do this using the "Sort" button in the table view, or will I have to write an SQL statement under New Query Table? Thanks.
Leading zero for Zip code disappears
Hi, I exported data from a table view and opened it using MS Excel. The table has a column for Zip code that has values with leading zeroes. The exported file deleted the leading zeroes for the zip codes. How do I ensure that the leading zeroes are not deleted when I export data? Thanks.
Column Widths in Reports
When I view my report the column widths are set too small cutting off names. How do I set the widths of the columns in reports. http://db.zoho.com:80/ZDBDataSheetView.cc?OBJID=39855000000002395&STANDALONE=true I would also like to use the ID column to dictate the order in which the species column is presented, but don't really need or want to see the ID column. Is it possible to "hide" a column, or is there another work around. here is the end use of the report - http://bostonbirds.org/bimbovpi.html
Hiding Sheets
Is there a way to hide certain sheets from those you share your database with? I have a bunch of sheets with lists on them and I don't want people to see these.
Date Format - Month only
Hi, I'd like to have users enter in only the MONTH into the database. Basically a MONTH() in PHP. thanks! Your products are truly amazing - keep pushing the web.
Sort an aggregated set
Greetings, I have need to aggregate the results of an expression, then sort by the aggregated column. I've tried to do this a number of different ways, but I get an error each time. It appears that we are unable to sort a 'Summary View'. And it appears that I am unable to place the 'group by' on the query table that I need. Here's my query.,.. SELECT upper("Site"), sum(ROUND(("Per Month Income") * ((YEAR("Next Paid Date") - YEAR("Date Paid")) * 12 + (MONTH("Next Paid Date") - MONTH("Date Paid")))))
number of decimal places - 2 vs 2.0
When I choose the "sum" option for a Summary View the quantity is listed as: 1.0 or 4.0 when all I really want is a whole number (1 or 4). Is there a place to set the number of decimal places? Also in Pivot view the qty line reads "Sum of ____" - can that be editted to read "Total" instead? Thank you!
Multi Line Text
When entering text into a "Multi Line Text" cell how can I force or determine where the text or copy gets broken. If I use the "enter" key I leave that cell. It is probably very simple but I haven't been able to figure it out. Example: One Two Three Thank you.
DB documentation
Is there any documentation available for Zoho DB & Reports?
Zoho DB (Query) not correctly querying
To test the DB & query I've created 2 tables: AGENDA (Nombre Text, F_Nacim Date, Cod_Postal Number, eMail email) Data: Fer, 11/25/1969, 28823, ppp@gmail.com Ceci, 12/11/1967, 28823, (nothing) Sofi, 07/04/2000, 28823, (nothing) LOCALIDADES (Cod_Postal Number, Localidad Text) Data 28823, Localidad_Description Then I've done this select-SQL: SELECT a.Nombre, a.F_Nacim, a.Cod_Postal, a.email, b.Localidad FROM Agenda a left join Localidades b on b.cod_postal = a.cod_postal order by a.nombre The query
Graph only shows one series
I have built a query table that contains data regarding golf scores. It has the following columns: player, course, total (this is a sum of other columns in the main table), date. I want to graph the following: X axis is date Y axis is total the data points are filtered by a couple of players and a course. I can't get the graph to split out the players individually. it works fine for one player/one course but i want to compare players on the same graph. How can i get the graph to do this? Thanks for
How to Filter reports and sum data columns
Hi there, I am having some problems and I may be missing something with how i can trying to do it! Firstly I can filter my table I can not seem to filter a Report based on a table. Is this possible? Secondly I want to be able to chart but based on a sum of some columns. e.g. table contains date, name and data columns. I want the X axis to be date, Y axis to be the sum of the data columns and therefore the labels to be the names. Any help would be appreciated. Thanks Tim
JDBC support or API for any kind of popular language?
Hi, Is there any plan for JDBC support or API for any kind of popular languages out there, like C, C++, Perl, Python, etc. Or zoho DB is going to be strictly on-line access only? Thanks,
How do you insert a column in a database?
I want to add a column between two fields and the only option I appear to have is to add it to the end of the columns already defined. I don't see an "insert" option, only a "delete" one. Am I missing something? HOw do I insert in a specific place in a table? thanks, Santwana
Forms for data entry
I can't seem to find any way to make forms. Am I missing something or is this function not available? Hope
query tabel
i created a table by importing data from excel. i need to query tabel, but i cant see any options in the window for tht. how could i do that? i took zoho DB. i would also like to get charts about the table.
Possable to use Zoho DB with Flash Mx [Widgets]
I'm learning how to use Flash MX - [Widgets]. Is there a way to connect to my Zoho DB and send Querys? Edit: Sorry if I posted this in the wrong section.
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
Next Page