Posts

Create records in QuickBooks from your Google Form submission

Image
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 createEntities that are supported now areVendorCustomerEmployee                     



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 go ahead and publish the Google Form with your vendors. The data submitted will automatically land in your QuickBooks account.

Query Cloud Firestore from Google Sheet using Database Browser

Image
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



Make your Google Sheet Data as Map - Map My Sheet - Procduct Launch

Image
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 MapSave 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


Direct your Google Form submission to as many as Google Sheets now - New feature launch - Form Director

Image
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 Google Sheets that you have configured.



Form Director also sup…

You have got an email. Expand your business reach - Form Director - New Features

Image
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 emailsto form owner, editors and viewersto emails submitted from formattached the generated Google document, slide and PDFswith templated email subject & message


So, go ahead and explore the notifications in the a…

Query mLab:MongoDB from Google Sheets using Database Browser

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