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
Decision box in a SQL query...
When I make a SQL query with a decision box field, the results are wrong... When I ask Select * from "table" where "decisionbox" = 'No' ;the result is ok. But when I ask ... "decisionbox" = 'Yes', the result is wrong! I've tried with true / false and it's wrong too... I suspect that the problem is me... What am I doing wrong? Please help me Thank you very much Sorry for posting too many questions... mpasquali
Date Format
Wich date format should I use in a SQL query? I couldn't make it work... Thank You...
SELECT multiple columns from table with multiple lookups
Hi, I created a table with two lookup columns (these were the first two columns, and both had numerical values). I then created a query table to select values from this table. Simple selects of a single column worked ok: select "ColumnName" from "TableName" But selecting all or multiple columns threw an error message about illegal column names: select * from "TableName" or select "ColumnName1", "ColumnName2" from "TableName" The table names were all simple characters, nothing special. The same kinds
Date Format
DB includes time into the date field. Can daate be used without time
Zoho Db
hi which is the database running under ZOHO DB ? cheers joseluis
.odb support
Any support for import/export of OpenDocument databases coming? Seeing as it's an open standard it would be humanly possible to integrate it into Zoho DB.
I can't export my data
Hi I have problems exporting my from creator! I have the same problem as earlier in other topics. The only type I kan export my data in is PDF and html. I would like to do it to excel or csv, but this is not possible. See attached for error message. BR Dennis NB. I have put this request under creator. Do not answer this.
I can't export my database.... How could I?
When I try to export I receive a message error saying that internet explorer could not download the file... What's wrong?
Edit Column header
Seems like such a simple thing to do but I can't seem to figure it out. How do I rename a column header ?
Column order
Can anyone tell me how to order the columns for a view?
select into statement
Hello developers of zoho db i'm trying to make this statement work but it will not work. select * into newyear-table from thisyear-table; what am i doing wrong or is this statement not supported? Is there a workaround so that i can create backup tables? thanks for your time Hans van Hal
Support of Subqueries
Do you support subqueries? I seem to be having trouble with this.
What does: "Sign up Zoho Creator with xxxxxxx@gmail&qu
The email that goes out when I share an app with people has this line at the end: Note : Sign up Zoho Creator with ivan.pope@gmail.com to access my application. What does that mean? I don't know and the people who get it certainly don't know. It seems to imply that they have to sign up with my details, but does that make any sense? People are having a lot of trouble accessing my applications - maybe it is something to do with this? Thanks, Ivan
Demo Video
Hi DB&Report stuffs, I tried to see the Demo Video (http://js.zohostatic.com/db/zohodb-zoho2/zohodb-zoho2.html). Media player stopped after 7 or 8 seconds. My PC connected 100Mb to the provider. Did you any trouble happen on the streeming server?
Is it possible to edit in a query view?
I've made a query and edited through the table in a query view, then I saved. Then I refresh and the data was the it was before... Is it possible to edit in a query view?
How can I transform a text field to a lookup field...?
How can I transform a text field in to a lookup field without loosing the data that is already there? thank you.
Built In Help
Is there built in Help in the Zoho DB? I want to know how to align my number in a column to the right? Is there a property tab?
Lookup columns
Are the grouping features working on the Lookup columns? Will it be possible to have a relational model running? Congratulations!!! Hugo
CSV import(paste)
Hi, DBreport is very exciting tool. But I can't import csv pasting data. Characters is changed(Japanease characters). When I use Zoho creators, import is correct. But it's wrong result is occured. I wish impot function will be working corroct. Thank you.
multi line text
hi, Were do you define entries for multi line text, I mean closed list of entries possible for a field ? thks Emmanuel
Integration
Great work, as always... Is this the "front-end" that we've been expecting for ZC? Hugo
Edit design
Congratulations on the developments so far. Is it possible to specify field size (e.g. number of characters for a text field) so the columns default to a specific width? I want to embed a query in a webpage and have the default column widths narrower so there is less manipulation required each time I view the page. Thanks. Andy
IE Users can see DB
Hello Me again LOL I have several people telling me that they either can't see the DB or can't add a line to it using IE. I opened it ok but saw that the "Add" button is not available as they say. In Firefox it is fine. Cory
Not allowing users to edit/delete other records
Hi is there a way of not allowing someone else to edit or delete a record without permission? Thanks Cory
Removing Public Database from my account listings
In trying out Zoho DB, I added a public database to my "listings." I'm now not able to remove it. It continues to show in "Recent Items". Is it possible to clear that listing?
Integration of databse with zoho
Hi, How to integrate database with zoho for getting multi user support.
Using INNER JOIN to link related tables
Has anyone managed to get a query using INNER JOIN to work correctly? Every time I introduce a field from another table into a query, I get an SQL parsing error. I am using (I think) pretty standard dialect SQL: tablename."Fieldname" and SELECT t1.f1, t1.f2, t1.f3, t1.f4, t2.f1, t2.f2 FROM t1 INNER JOIN t2 ON t1.f1=t2.f1;< br/>< br/> I have managed to create a join using the following: SELECT Staff."FirstName",Staff."Surname",Role."Position" FROM Staff,Role WHERE Staff."RoleID"=Role."PositionID";
Mask on Date fields
Hi; Is it possible to display date fields in differents Formats (YYMMDD or YYYYMMDD, or else ....) I didn't find this capability in this current version of this DB. Regards
relative time
When filtering the graphs relatively by time I selected last 1 hour. It shows a time 3 hours before, in my case would UTC/GMT. Is there a setting for time zone for the DB.