Blog of Jivrus Technologies

Google Cloud Datastore You can now connect Google Sheet with Datastore using  Database Browser  add-on and build a query from the wizard, execute query and present results directly into Google Sheet.  Getting  Datastore   data into Google Sheet is NO more complicated.  Users  can now just follow the steps below Step 1 : Create a  Datastore  connection authorized with Google sign-in button. Step 2 : Provide project-id of the  Datastore  project (refer Google Cloud Console), test and save  the connection. Step 3 :  Build, Query and Present the results into Google Sheet as normally as you do with any other data sources. Check more documentation at  how it works . Check out the current list of  supported databases  by Database Browser.                                    ...

Form Director - What's cooking on the Year 2019 Happy New Year from Form Director team We have been always pushing ourselves to give our users the best experience and useful features as much as possible. Highlights of the Year 2018 Ability to reprocess their form responses with Form Director Services Introduced new apps: QuickBooks, Google Sheets, Google Slide Improved stability of existing apps: Google Docs, Tasks, Calendar, Contacts Improved User Interface and provided easy navigation Introduced Premium Plans as well as Monthly subscription In the upcoming days of the year 2019, we can assure that the user will get more and more useful features from Form Director  Some of the features and apps that we are going to introduce in early 2019 are Calculated Fields The user can do a variety of standard calculations and custom expressions with their Form responses,  mashing up with predefined data such as Current Date, Time etc. Crea...

You can now connect Google Sheet with Firestore using  Database Browser  add-on and build query from wizard, execute query and present results directly into Google Sheet.  Getting Firestore  data into Google Sheet is NO more complicated.  Users  can now just follow the steps below Step 1 : Create a Firestore connection authorized with Google sign-in button.    Step 2 : Provide project-id of the Firestore project (refer Google Cloud Console), test and save  the connection. Step 3 :  Build, Query and Present the results into Google Sheet as normally as you do with any other data sources. Check more documentation at  how it works . Check out the current list of  supported databases  by 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 DATAB...

Businesses use cloud based accounting systems like QuickBooks Online. Many a times, accounting team would like to get their accounting data on to spreadsheet to do data crunching, summarising, charting, presenting or just for verifications. Google Sheets is a great online spreadsheet tool for collaborative data crunching for accounting purposes.  Exporting QuickBooks Online data into Google Sheets will provide a lot of power to accounting team to verify and manage the data.  "Jivrus Integra for QuickBooks"  is a GSuite add-on  that helps you to run queries in QuickBooks and export the data into Google Sheet. You can configure and save the queries and even set it to automatically run in the background. Look at the sample query result that is exported into Google sheet using this add-on. Happy Accounting !

Database Browser is a Google GSuite add-on that makes Google Sheet an awesome new way of browsing your database (RDBMS like MySQL, Oracle, MS SQL Server). It is a very useful add-on for querying the data from the database and import the databases into Google Sheets in a comfortable way as you want. It provides an easy GUI for establishing connection with databases, browsing tables and querying records out to Google Sheet.  It is useful  for developers, admin, testers, customers or any one who wants to query/edit database without any coding and display/ store results into Google Sheet. The database user can Manage Connections - Create, test and save connections to databases on the Internet and cloud. Manage Queries - Build, execute, save queries and query results into Google Sheet. Edit - Edit the data in the database directly from Google Sheet and saving into the database. Database Browser is listed in  GSuite Marke...