Posted in Google Apps for Business, Google Apps for Education, Google for Work, Google Spreadsheets, Workflows

Advanced Form Analytics? Combine frevvo + Google Sheets

We’ve written a series of articles on how frevvo + Google Apps (Sheets, Drive, Maps) can work together to solve business problems. frevvo includes a built-in submission repository that saves all your form and workflow submissions. You can view this data, filter it, and export it using the Submissions Views available in Live Forms. But, you can also combine frevvo + Google Sheets and leverage some sophisticated capabilities that are part of Google Sheets (charts, queries, filters etc.) for powerful data analysis on your submission data.

Geo Location ChartHere’s an example form that you can try. It’s a simple one with a few fields. A survey form for participants in the 2014 World Cup Soccer tournament. The form adds your submission data to this Google Sheet and shows it. When you submit it, you’ll see your submission in the last row.

The spreadsheet also contains two other Tabs: Geo Location and Pie Chart. The Geo Location Tab runs a query on the raw submission data and groups submissions by country. The Sheets Query language is very general and allows SQL-like queries. Once we have the data by country in a nice tabular format, we can generate a nice chart that plots submissions by country on a world map. Easy as pie.

Pledge amount by positionThe Pie Chart Tab, as you might expect, contains a pie chart. It contains a very similar query except that it sums pledge amounts by country and by position. Once again, we have the required data in a table and can easily generate pie charts to report on the data.

In this way, you can easily use frevvo’s Google Connector to save your submissions to Google Sheets. Then, you can use a whole host of built-in features in Google Sheets to analyze your submissions.

Interested in using frevvo with Google Apps? Contact us to learn how you can automate your approval workflows, integrate with Google Apps to manage your documents and use some of Sheets capabilities for advanced reporting.

Posted in Forms, Workflows

[Video] Visual Rule Builder (V7.4)

vrbV7.4 has been released and it comes with a bunch of new things – the most exciting feature is the upgraded Visual Rule Builder.

Many customers use frevvo to create forms with extensive dynamic behavior. They love the flexibility and power of frevvo when it comes to creating dynamic forms. With frevvo’s Visual Rule Builder, it’s easier than ever to create these dynamic behaviors and anyone can do it.

Watch this short video that shows you how easy it is to use the Visual Rule Builder to create dynamic content.

Customers are using frevvo for things like:

  • Showing fields only when they’re relevant
  • Automatically filling in fields
  • Performing calculations

and many others.

View-Recording

Why not give it a whirl? Sign up for a free trial and see for yourself. It takes 30 seconds, and you can install a template and try it out instantly.

 

Posted in Customers, Workflows

Granite State automated their New Hire packet. The efficiency is just incredible!

gsil
Granite State Independent Living (GSIL) is a 1000-employee nonprofit organization whose mission is to promote quality of life with independence for people with disabilities and seniors through advocacy, information, education, support and transition services.

As a healthcare organization, GSIL is subject to numerous regulatory requirements. Their New Hire packet had grown to 40+ forms that would take hours to complete. The same information had to be filled in multiple times, time was wasted correcting errors, making copies for filing and finding/auditing the information was tedious.

“PiF Technologies introduced us to frevvo and helped us automate the New Hire packet. The rest is history. The efficiency is just incredible.

frevvo’s modern online system is easy to use and meets our business requirements at a reasonable cost.”
–– Linda Tsantoulis, Vice President of HR

GSIL worked with frevvo’s partner PiF Technologies to digitize the New Hire workflow to use e-forms. Using frevvo’s low-code, visual solution, PiF was able to automate the the process in record time. The documents feed directly into DocStar, their document management system, and index fields are created automatically.

The benefits are enormous since the automated processes are significantly faster and error-free. Filling out the packet used to literally take hours. Now it can be completed in 20-30 minutes. Working with PiF and frevvo, GSIL plans to automate other areas of their business.

Read-Case-Study

Read the Case Study and learn more by visiting our website.