Blog of Jivrus Technologies

  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 the questions/fields for the

Build Rich Custom Info Window with your Google Sheet data using Map My Sheet Info Window is a way to display content - both text and images in a popup window on the map, for any given location.  Below is a sample of Info Window. Now with Map My Sheet user can customize What is to be shown in the Info Window  How it is formatted You can configure to show your details from the Google Sheet in the Info Window of Google Map. Also, you can format with the desired color, font and size. The below shows steps to configure Info Window in Map My Sheet By default, it takes all the columns from Google Sheet as part of the info window. Formatting properties of info window. Pick your color Pick your font Pick your font size Using these formatting properties, you can design the Info Window as per your need. The below is the sample Info Window based on the configuration in Map My Sheet.        

Tired of keying in vendor data manually into QuickBooks....?  We got a solution for you  !!!   Share a Google form to your vendor to fill their details. Form Director will create an entry of your vendor in QuickBooks     Sounds exciting !!!, follow these simple steps below      Step 1   Create a service in Form Director by choosing QuickBooks as the app and create as the service Step 2   Authenticate with QuickBooks by Clicking on "Connect to QuickBooks" Authenticate Form Director with QuickBooks for creating Entities (Vendor, Employee, Customer) Step 3 Choose which entity you want to create Entities that are supported now are Vendor Customer Employee                      Step 4 Map your form field with  Entity Fields to store the corresponding form response to the Entity field Step 5 Save your service  You are all set to direct your form response to QuickBooks.  Now just g

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.                                                                                Reach us  with your feedback Visit us at  www.jivrus.com                                                                                                      

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 submissions will be directed to the

You have got an email. That is a good news And that brings you new business. Expand your business reach. Collaborate more with your customers, employees, vendors, and any stakeholders of your business by simply opening up a Google Form that does more than what a Google Form does. I mean - power up the Google Form with Form Director add-on, that can direct the submitted data to various applications. You can now improve collaboration and communication from your Google Form submission by configuring notifications in Form Director. When a service (e.g. insert into database, generate merged doc/slide, create calendar event/contact etc) is successfully executed with submitted form data, Form Director can send notifications. Templated notifications can be configured to send to specific emails to form owner, editors and viewers to emails submitted from form attached the generated Google document, slide and PDFs with templated email subject &