Posts

Form Director - What's cooking on the Year 2019

Image
Form Director - What's cooking on the Year 2019Happy New Year from Form Director teamWe have been always pushing ourselves to give our users the best experience and useful features as much as possible.Highlights of the Year 2018Ability to reprocess their form responses with Form Director ServicesIntroduced new apps: QuickBooks, Google Sheets, Google SlideImproved stability of existing apps: Google Docs, Tasks, Calendar, ContactsImproved User Interface and provided easy navigationIntroduced 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 FieldsThe 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.

Create Trello card on your Form Submission 

Add Leads, Contacts, and mo…

Introducing Quiz New Feature Launch - Form Builder

Image
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 FormBuild 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 selectedThat's it, your Quiz Form is ready.






Custom Info Window on Map - Map My Sheet - New Feature Launch

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

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…