My business data - My Google sheet - My show - Database Browser

-
          

A small business owner is maintaining all of his invoices in a database. To explain his company growth to his partners, he need to prepare a chart from the data present in the database. This will take much long time to complete the process using normal way of querying and getting data and then importing into a spreadsheet and preparing a chart. And if he needs to repeat this every month/ week, it will be painful. 
Using Database Browser, it is very easy to get data from the database directly into Google sheet. The chart gets refreshed automatically on getting the latest data  After one time configuration of connection and query, all the business owner needs to do is - just click on play button and he is ready to present.




The Below Screenshots will give you an idea about how the data is accessed from database and chart is created using that





QUERY TO GET DATA FROM THE DATABASE
  

RETRIEVED DATA THAT GETS STORED IN THE GOOGLE SHEET




CHART for PRESENTING to PARTNERS



With Database Browser, you can filter data and you need not know to write SQL query. You can create a connection to the cloud/ Internet database and you can get your data to the google  sheets anytime. 

With Database Browser, you can also set custom SQL queries and setup to run queries automatically in the background.
Visit https://databasebrowser.jivrus.com for more details.

Comments

Post a Comment

Popular posts from this blog

Create Trello Cards on Google Form Submission - Form Director

-
Image
Creating Trello cards on Google Form submission using Form Director Trello  is a collaboration tool that organizes your projects into boards.   Trello boards, lists, and cards enable you to organize and prioritize your projects in a fun, flexible and rewarding way.  Now you can easily create Trello cards from your Google Form response using Form Director. Follow these simple steps to configure the interface with the Trello app in Form Director  Open Form Director Click on create new service Choose Trello from the list of apps Authorize with Trello Configure mapping with Trello app fields Save your service Apart from title and description, you can assign a due date, post comments, attach files, and more to your newly created Trello card.  Check  how to configure trello app  for detailed documentation and usage instructions.   Contact Us  or write to  support@jivrus.com  for any queries Jivrus T
Read more

New Release - Jivrus Integra for QuickBooks - Feb 2018

-
Image
 Jivrus Integra for  QuickBooks for GSuite We released a new version  and that means some  awesome new features for you First of all, thank you very much for all your appreciations, feedback, support queries and feature requests. That means a lot to us. Thanks. Over the past few months, we worked hard to introduce new features and improved the stability & performance of the "Jivrus Integra for QuickBooks" add-on for G Suite New Features Custom Queries feature We introduced "Custom" option in the add-on so that user can write his/her own specific query (by choosing the 'Custom' option from the 'Source').  By using this feature, Google sheet user gets records of the QuickBooks object that satisfy the custom query in the Google sheet. Custom Query is for advanced users. This makes the user very powerful to query and bring only the data th
Read more

Google Classroom integration with Form Presenter

-
Image
  Google Classroom Integration with Form Presenter What is Google Classroom? Google Classroom  is a free web service developed by  Google  for schools that aims to simplify creating, distributing, and grading assignments. The primary purpose of Google Classroom is to streamline the process of sharing files between teachers and students. Integration with Form Presenter Users can post your published link as new assignment/exam on Google Classroom right from Form Presenter. Click on Google Classroom to start integrating with Form Presenter. Allow permission for Form Presenter to integrate with Google Classroom. Create Classwork Provide Title for Assignment/Exam Provide your Instructions on Assignment Provide total points. It will show your Quiz total score that you provided in your Google Form. Select whether the Class work is to Assign or Draft(you need to assign it manually from Classroom if it drafted) Enabling Import Grade will import the quiz grade automatically on class work on For
Read more