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?
Update only selected records in view?
I'm not sure how to update only selected records. At the moment when user select lets say 5 records in the view and execute custom function void dateformat.updateDate() { for each ordered in Orders[Ordered=="Yes"] { ordered.Order_Date=zoho.currentdate; ordered.Ordered="Yes"; } } It updates all records instead selected. I couldn't find anything that says how to isolate selected records from the view. Could you please be kind and help me with this problem. Thanks Sasa
Update only selected records in view?
I'm not sure how to update only selected records. At the moment when user select lets say 5 records in the view and execute custom function void dateformat.updateDate() { for each ordered in Orders[Ordered=="Yes"] { ordered.Order_Date=zoho.currentdate; ordered.Ordered="Yes"; } } It updates all records instead selected. I couldn't find anything that says how to isolate selected records from the view. Could you please be kind and help me with this problem. Thanks Sasa
incramental Numbers
How can you create a field that increments for every record?
Refreshing data more than once per hour
Hi, Is it possible to automatically refresh data more frequently than once per hour? I'm trying to put together a database to monitor the elections in Minnesota, USA, and I'd ideally like to get data every 15 minutes. I can do it in Sheet, but there's too much data for Sheet to accept. Thanks, Jeff Rosenberg
Percentages on Pie Charts
It seems like I can show values on pie charts but not percentages of the total.
Link to zoho creator
It will be great if zoho reports and zoho creator can be linked up.
zohoreportsapi.wiki.zoho.com is awesome
hey I do not agree with what you wrote really.... please ellaberate a bit more for me ;D cheers
Granting Data Import rights to multiple users
Hi, I have not been able to grant "Import" rights to db users that I have granted "read/write" access to. I am maintaining the sales reporting data for my company, and we make weekly batch imports from our retailers. I'd like to be able to hand off that importing work to another user... is this possible, or is this on the road map? Thanks, Jamie Sidey
lookup for tables in different databases
Hi there, I am working on databases for the first time. Please clarify my doubt, Is it possible to relate (i.e. use the look up function) for the columns of the two tables where each of the table is in different database. can i expect any such feature or it is invalid into itself. regards! Anand
How to rename tables?
How can I rename tables of Zoho DB? It's ease to rename a database, colunms but I can't found where to rename tables.
Time/Date
Is there any shortcut on the keyboard to automatically update a section with the current time/date. Right now I have to double click the region and select "today". There has got to be a faster way...right?
Web forms using Zoho DB
Hi, Is it possible to create dynamic web forms using Zoho DB as the backend database? Thanks, Yamini
Incorrect sum
Table t_expenses 01/01/2008 $100.00 Entertainment 01/03/2008 $20.00 Entertainment 02/03/2008 $500.00 Transportation 02/05/2008 $10.00 Other 03/06/2008 $100.00 Entertainment 05/09/2008 $60.00 Other 06/09/2008 $40.00 Other I run the following query on "t_expenses": SELECT year(dt.Date_Column) Yr, month(dt.Date_Column) Mth, sum(ent.Amount) FROM "t_expenses" dt LEFT JOIN "t_expenses" ent ON year(dt.Date_Column)=year(ent.Date_Column) and month(dt.Date_Column)=month(ent.Date_Column) where ent.Category='Other'
Refresh of Query Tables
I have one master table and 200 query tables "viewing" data from that master table. When I update a record in the master table, it may affect 20 query tables but since I don't know which 20, I have to manually refresh all 200. How do I do an automatic refresh of all query tables when a change is made in the master table? Thank you in advance for your help.
How to display Currency Data Type in a query report
Hi Zoho Tech Support, I have a query report which sum a column with currency data type. When report generated the sum column can only show ".#" type. How do I add '$' in front of the numbers. Thanks. Sincerely, Lesley
Uploads
I have around 150,000 rows I need to import into an application, on using the upload paste window it falls over on anything greater than 2000 rows - the email function does not seem to work either - can you help please
Explorer and Firefox DB
When I put the Zoho DB URL on my webpage it works in Firefox but not in Explorer. Any advice would be greatly appreciated.
Export to multi-pdf preview
The ability to export multiple reports to a pdf is great. However, there is no way to set a multi-pdf template. I have a multi-pdf report that I need to generate daily. SO everyday, I need to select each of the reports I need and then go about re-ordering them. This takes up a quite a bit of time. Is it possible for zoho to remember the order and reports I require in my daily multi-pdf extract? Nish
Repeating formulas in a query
Consider the following query: SELECT SUM( ... ), SUM( ... ), SomeSolumn My problem is that the SUMs are based on large formulas, and SomeColumn should display the difference between the two. However, I don't want to repeat both formulas. So my approach was: SELECT SUM( ... ) as S1, SUM( ... ) as S2, (S2 - S1) But it doesn't seem to work. Any ideas?
Deleta All Rows [Danger]
I dislike giving my shared users the ability to delete every record in a table with one inadvertent click. It seems that the "Delete Column" feature has been disabled for those with whom I have shared the database...how can I also disable the "Delete All Rows" feature? If this cannot be disabled, is there anyway to schedule an automatic back-up copy of the database so as to have a running backup in case such a disastrous "Delete All Rows" occurs?
Column based on a query
Hello, I need to create a table with 4 columns, the last column being a query on another table. Example: Table 1: User_ID LastName FirstName Expenses ----------------------------------------------------------------- The Expenses column should be a query on another table which takes the user ID in account. The data in the other columns of Table 1 are entered manually. Will a Query Table do this?
DB API
Is the Zoho DB API coming soon? Any ETA yet?
Drop Down Menu Control
In Zoho DB & Reports is it possible to structure Lookups dependent on the value of another field. For example, if from the the Drop-Down Menu for Field "Chapter" one choose ' North ', then the Drop-Down Menu for the next Field "District" would present only those Districts identified as belonging to North Chapter. I have seen where Creator can do something like this using scripts, but if I have to use Creator, then how can I "connect" Creator applications to my DB?
SELECT (multiple) CASE query doesn't work
Hi, I'm really satisfied with Zoho services, finally i've found what i need!, but now, i have got the current problem. Just imagine Formula 1 scores. When a driver ends in 1st position then scores 10 points. 2nd = 8, 3th = 6... etc My query only returns the first case, and ignore the other ones. In my table, column 'Pos' is a Lookup Column. SELECT Driver, CASE Pos WHEN Pos = 1 THEN 10 WHEN Pos = 2 THEN 8 WHEN Pos = 3 THEN 6 WHEN Pos = 4 THEN 5 WHEN Pos = 5 THEN 4 WHEN Pos = 6 THEN 3 WHEN Pos = 7
DQL Query - Date format different in preview and view mode
Hello, I have the following SQL query: SELECT Max("Date"), "Person", "Name", SUM("Pcs") '# of Pcs' , SUM("Hours") 'Hours', ((SUM("Pcs")/SUM("Hours"))/60) 'Pcs/min', Sum ("Scrap") Scrap FROM "BCoil Report" where DATEDIFF(CURRENT_DATE(), "Date")<=60 group by "Person", "BCoil Name" In preview mode, I am able to see the date in the format "yyyy-mm-dd 00:00:00". However in "view mode" it converts it to what I think is text. E.x "[B@6803f59b" How do I fix this? As well, any suggestions on how would I change
Extracting a "Week of" date from another date
Hello, I would like to use pivot tables to view sales activity by week. Currently we enter the exact date of our activity. What SQL function(s) can we use to extract the date of the previous Monday from a date field? Any suggestions would be appreciated. Thanks Jim
Problem Exporting from ZoHo
I successfully created a small membership database, but cannot export the data. When I try to export the database or a report as a CSV, a File Download window opens. I have tried clicking OPEN and SAVE buttons and neither will result in the data being exported. The File Download window says - Getting File Information - but it just runs and runs. No file is ever exported. Please advise as to how I can export the full database and reports without the process "hanging". Thank You. ~Barbara MS Vista
Does DB support Aliases?
I keep getting a "Specified Query is not yet supported by Zoho DB. Please send us your query to support@zohodb.com, in case you wish to post to our bugs database" message when trying to alias a SQL field. Is this only me? Or do any other users run into the same issues? What's funny about this is that when I click on execute the first 10 rows show up exactly they way I want them too, but when I try to save the query, the "not supported message pops up. Thanks, Jim
Date Field Bug - Formatted Field & Now Won't Accept Data
I have a date field in my database that I have recently formatted to MM/DD/YYYY format. It appears that the field is now locked and I cannot enter new data into it. I have tried using the built-in calendar function, typing the date in and copying and pasting the date into the field to no avail. I am getting the following error: Date value should follow the pattern '05 Feb 2008 17:30:30'. The given input is '24 Jul, 2008 10:56:43' I have also tried resetting the column format to what it originally
HELP: dB for tracking volunteer hours
Hi, I need help in creating a db for school PTA. This is to track down volunteer hours and that each parent could view only their own data (password protected). Any suggestion or if someone could help me with the template. i appreciate any help thank you, jc
Add column data to existing table?
Anyone know how to add column data en mass to an existing table? I have a table with members in it and I want to add a column with ID numbers in it to the table. I have the ID numbers and the table with the members in it sorted. I need to figure out how to add those numbers to the table so I do not have to type them all by hand. Cheers, Dave
Pivot table options
I have a very simple DB - in columns - Date, Agent ID, Client, Number of items sold. When creating a Pivot View I am putting the date in the Column, Agent ID in Rows and then number of items sold in data. I do not have an option to select sum in place of count. How can this be fixed?
Export Options
Please clarify the options for exporting data and metadata from Zoho DB. Can you, for example, export DDL to a file (e.g. XML)?
Next Page