Edit data in a query
Does anyone know if we can edit data in a query? I have built an action list table with projects assigned to people and created queries that filter the actions so everyone can each see their projects. I would like to let them update the status of their projects in the query rather than in the master table. Any thoughts?
Failure when updating existing table
Hello. Love the DB tool. Very helpful. I have run into an issue when trying to update records in an existing table. I am have a table with 10 existing columns and I am trying to append 5 new columns to the data. I select import and "add records and replace if already existing". I have ensured that two of my existing columns are present in the new file, along with the five new columns. I have selected to match on those fields to ensure the data is appended correctly. The result is... The system generates
SQL Help in ZOHO DB
I have a column "Last Contact" I would like to show how many days have passed from that date until now. I want result shown in Days. How do I do this? Thanks!
ACT! 2000 - trying to import database
I've read instructions posted on these forums to export in CSV format and then import same data to Zoho database and reports using the Import Wizard. I'm using ACT! 2000 and my only options are .CCX, .dbf, or Text - delimited. Which should I choose? I'm hoping someone can help - I look forward to using Zoho. Thaks!
importing contacts from ACT! contact management
how to import from Act! software
select on joined tables
For some reason I am able to execute the following join statement select * from "t_actionsheader" join "t_actions" on "t_actionsheader"."Actionid" = "t_actions"."ID" But I can't save it. Has anyone tried a join of 1:n table relationships before?
Lookup Column Not Working
Hello, New to Zoho DB so please forgive me if this has been discussed before. I am trying Zoho DB out before I commit to using it and created to databases - vendors and vendor accounts - and am trying to get teh Vendor Name from Vendors database to be a lookup column in the Vendor Accounts database, but when I create the Vendor Name field in the Accounts database and tag it as a Lookup Column it works, but when attempting to enter data into Vendor Accounts there is no data in the Vendor Name drop
Search feature
Is there a search feature in the Zoho DB that I am missing? I have so many people in my DB that I was hoping I could search by fields. Thanks in advance! Frank
How to set rules in a cell?
Hi, is possible to set roles in a cell? For ex a number with no more and no less than 5 characters? Many thanks jacopo
Zoho DB import
I just started looking at Zoho DB and I tried to 'import' some extra records into a table, but the button did not do anything. I was hoping I could overwrite existing records where a field matched. Thanks Richard
Zoho Sheet - Graphing Discontiguous Data Ranges?
How can I get Zoho Sheet to graph discontiguous data ranges Meaning, I have dates in column A, but numeric values in column D. Please confirm. Thanks.
Graph to allow more than one field on x-axis
Consider a DB capturing the turnover per week in four different regions: Fields are Region, week and turnover. I would like to be able to create a bar-graph showing the turnover (y-axis) per region for the last 4 weeks (seperately). That means that the x-axis box in the edit view of a DB graph should allow more than one field and that the order determines whether you will see weeks per region or regions per week. Thanks for a promising app! Aloys
auto increment of column
Dear All, I am very new to Zoho DB. I have a requirement for auto increment of column ( like serial number). Please let me know how can i achieve it :?:
Importing CSV data to an existing table
Hi, Really like the DB facility. I've tried to import csv data to an existing table and have the data added to the end of the table as new rows without success. I've tried both the paste and local file import methods. The data is standard csv with a comma separator. If I import the data into new columns this works fine. If I import into the existing columns it fails to start and gives no error message to indicate where the problem is. Any help you can give would be great - I've worked around the
Print addresses from my database
Hi, How do I print addresses onto envelopes or labels using the information i just put into my database? Thanks
Create a relation between 2 sheets
Hi, I need to create a relation between to sheet but I'm not able to do it: ex. Contatcs and kind of contatc (client...). Many thanks jacopo
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
Next Page