After the recent Zoho Sheet Pivot Table support which is based on Zoho DB & Reports, we have rolled in good set of useful features into Zoho DB & Reports. I have summarized the important ones here below.
With the new Copy Database feature, you easily create a copy of an existing Zoho DB & Reports database. This feature provides an option to make a copy of the database with or without existing data. If you copy without data, then only the tables and report definitions are copied. If you copy with data, then all tables, reports along with existing data in the database would be copied.
You can make a copy of a database following the steps given below:
- Go to “Existing Databases” section in the home page
- Under each database that is listed you will find a “Copy” link
- Click on the “Copy” link for the database that you wish to copy
- It will popup a dialog where you could provide the name and description for the new database that is to be created
- Check/Uncheck the “Copy with Data” option depending on whether you would like to make a copy of the database with tables, reports and existing data OR just the tables and reports definition alone
With this option you could also copy any of the demonstrative Sample Databases that is provided by Zoho DB & Reports.
Zoho DB & Reports now supports importing HTML table contents into Zoho DB & Reports. This enables importing data in any HTML table into Zoho DB & Reports as you import CSV data. The HTML file should contain at least one Table inside it for importing.
You can import data from a HTML file through any of the following means:
- Copy/Paste the HTML code into the “Import Wizard”
- Load a HTML file from a local folder
- Load a HTML from any publicly accessible Web URL
More intelligence & convenience for designing Chart/Pivot/Summary views:
So far, while designing chart or pivot or summary view, you had to drag and drop fields listed on the left to the right-side design area and construct the view. Now we have provided checkboxes to just select the fields that are to be used to design the chart. This is apart from the existing drag and drop support.
Zoho DB & Reports intelligently identifies the appropriate position to place the selected field in the design area. Also as another step of intelligence, Zoho DB & Reports even selects the right function to apply on the field which is added to the design area.
Filters & Search across all tabular views:
Filters and Search (Quick Filter) was introduced into Zoho DB & Reports in one of our previous update. It was initially supported only in Tables. Now you could do Quick filtering across all table based views in Zoho DB & Reports. This includes Tabular Views, SQL Query table and tables shown for displaying View Underlying Data in Charts, Pivots and Summary Views.
Color your Zoho DB & Reports interface with Themes:
Zoho DB & Reports now supports themes. You could apply the theme you like by choosing the “Themes” menu at the right top corner of the screen. Currently we have only two packaged themes available (more to come very soon….). The theme you choose will be set to your preference and applied across logins. I guess you would have already noticed that the snapshots embedded above in this blog post were all taken with our New Blue Theme.
Keep track of the Zoho DB & Reports Feature Trail to know about all the features that are rolled-out into our service regularly. Try out the new features and let us know what you think….