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)?
Averaging Function
Hello, I hope someone can help me with generating a production report average. I have defined a table with the fields "Date", "Name of operator", "Pieces produced" and "Hours worked in shift". Id like to know the average number of pieces produced per hour by each operator over the last 30 days. I created a Summary view telling me the total pieces produced and total hours worked for each operator with a date filter for the last 30days. Id like the summary view to have an additional field where I can
Charts not updating
Hi there, Not sure if anyone can help with this. I have a table and a chart that produces a line graph based on this table - filtered. When should the chart update? Straight away? Is there a way to force the chart to update. I have added 2 new rows to the table and have now left it over night and still the chart has not updated. Any help would be good. Thanks Tim
SQL Functions
I want fo format a numeric field as a string with leading zeroes eg Format("PositiveNumberField", '000') in a query table, but the SQL gives an error on the above. How can I do this ? The reason i am having to do this is that I wish to display a number field in a summary report and it insisted on it being a group by field and not a value field. Am I taking the right approach or is there an alternative ? Thanks
File attachments field type
Zoho Creator allows for file attachments. Will this field type eventually be supported by Zoho DB as well? Especially with the prospect of creating forms through the coming API this would be highly welcomed.
DBF file compatible
Can you include dbf file filter to writer, DB and wiki? Can you make ZWiki compatible wiht TWiki files? Import TWiki files to ZWiki and writer and DB?
Printable reports?
Hi, Is there a way to create, format and print report from a table, say for mailing addresses? Seems like the only view I can get is the spreadsheet format. What I'm looking for is something similar to Mail Merge to create labels from a table. The best way I've figured this out is to 1. Create a report and save it 2. Export it 3. Use MS Word Mail Merge to create labels 4. Print it Is there a similar capability in Zoho DB? Or would Zoho Creator be a better option? Thanks.
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
Next Page