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.                                    ...

  Build your Quiz Forms from Google Forms and Google Sheets. Now you can build Quiz Forms from other Google Forms and Google Sheets.  Simply choose the Google Form or Sheet and start importing quiz questions & answers into your form. You can build your quiz form in two ways Build a new Quiz Form from another Quiz Form Build a new Quiz Form from Google Sheets Building Quiz Form from another Quiz Form Consider you have an existing Quiz Forms . And you want to import few or all fields/ questions from that form into another form. Select source as " Google Form " Form Builder  automatically  check the selected form is a quiz or not    Form Builder lists all  fields  and makes fields/questions available for you.  Import individual or Import selected That's it, your Quiz Form is ready. Building a Quiz Form from Google Sheet Consider you have...

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.                                                     ...

Map My Sheet  is a Google G Suite add-on that provides the easiest way to represent your Google Sheet Data into Map. It constructs maps based on complete address or longitude/latitude with custom markers and animation.  A simple use case for Map My Sheet is to present your business branches or shops in a map so that people can easily locate. You can just pull  The Map My Sheet user can Create and Configure customized Map Save Map  (generates and preserves Geo Coordinates) View Map  Map Configuration - The below screen shows a sample configuration of map. View Map - The below screen shows a sample output map. Visit https://mapmysheet.jivrus.com Check Map My Sheet  documentation  for detailed documentation.  Contact Us  or write to  support@jivrus.com  for any queries    Jivrus Technologies...

Form submission to as many as Google Sheets You being here in this blog means you already know that Google Form supports writing into Google Sheets off-the-shelf. But you may want the form submission to write into multiple Google Sheets and may be with custom column mapping. For example, you want your order form to create an entry in Orders sheet with order details, create an entry in Projects sheet with only project tracking details and create  jobs in  another sheet.  Now you can direct your Google Form submission to write into as many as Google Sheets as you want using  Form Director  add-on. Just create your custom services in Form Director choosing Google Sheets as the application. Steps 1. Choose the App and Service  2. Choose the Target Google Sheet using Google Picker. Then continue with standard steps 3. Map Form fields and Google Sheet fields 4. Save and activate Form Director Now, your form su...

Ever since we launched Database Browser add-on, there has been requests to add support to various types of databases from Google Sheet. We add new database types as and when possible to Database Browser. mLab:MongoDB is our latest addition. You can now connect Google Sheet with mLab:MongoDB using Database Browser add-on and build query from wizard, execute query and present results directly into Google Sheet.  Getting mLab:MongoDB  data into Google Sheet is NO more complicated.  Our Pro plan subscribers can now just follow the simple steps below: Step 1 : Enable API access in  mLab:MongoDB and get API Key Step 2 : Create a database connection to  mLab:MongoDB from Database Browser with the API Key. Step 3 : Build, Query and Present the results into Google Sheet as normally as you with any other SQL database connection using Database Browser add-on. Check more documentation at  how it works . Check out current list of ...