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, Google Apps for Business, Google Apps for Education, Google for Work, Google Spreadsheets

[Video] 05 ways you can use frevvo + Google Apps today

Customers are combining frevvo + Google Apps in many ways to solve real business problems, and to improve productivity and efficiency. We recently described “05 ways you can benefit from combining frevvo with Google Apps in your organization TODAY” in this recent e-Book. We’ve also created a short (3 min) video that describes the benefits of combining the two.

From dynamic pick lists to using Google Drive as a content repository to approval workflows, the combination just makes completing routine, day-to-day business tasks easier and faster.

It’s 2016! There’s simply no excuse for outdated, manual systems that cause delays, result in unhappy employees and wasted time and money. Visit our website to and see how customers are using frevvo today to improve efficiency and productivity.

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

Google Apps Issues this week “invalid_grant”

A customer reported that their frevvo forms integrated with Google Apps (Sheets, Drive) mysteriously stopped working on Monday. Yesterday our own frevvo Training Registration form which pulls back a list of available training classes from a Google Sheet suddenly failed to populate the class list dropdown from the sheet.

Our frevvo Cloud server log files contained Google “invalid_grant” errors. The Google oauth access token had mysteriously disappeared from the user’s Google Account. Your Google Account connected apps & sites page should look similar to this image below but instead showed that frevvo Live Forms App had gone missing.1-843To solve this, create a new Google frevvo app access token and then update all your forms/flows that used the old missing access token with the new token. This means updating both the Google Sheets frevvo wizard connections and any business rules which used the access token.

We do not yet know why Google automatically deleted the frevvo app access token in our customer’s Google Account or in our own Google Account. We are still investigating and have submitted a bug report with Google.

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

[eBook] -05- ways you can use frevvo + Google Apps today

frevvo-google-apps-2
Download e-Book

In previous articles, we’ve described the many ways you can combine frevvo + Google Apps to solve real business problems, improve productivity and efficiency and allow employees to focus on customers, students and patients instead of being bogged down in paperwork.

Download this new e-Book that describes “05 ways you can benefit from combining frevvo with Google Apps in your organization TODAY”.

From dynamic pick lists to using Google Drive as a content repository to approval workflows, the combination just makes completing routine, day-to-day business tasks easier and faster.

It’s 2016! There’s simply no excuse for outdated, manual systems that cause delays, result in unhappy employees and wasted time and money.

Learn more by visiting our website. Explore some of the examples, read customer success stories and contact us for more details.

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

[Video] frevvo + Google Apps

Several customers are combining frevvo + Google Apps in interesting and useful ways to solve real business problems. From electronic signatures to dynamic pick lists to using Google Drive as a content repository to approval workflows, the combination just makes completing routine, day-to-day business tasks easier.

Our infographics and other blog articles discuss how frevvo’s affordable, cloud-based workflow products work with Google Apps can improve efficiencies in these areas. We’ve also created a short (2 min) video below to show you the benefits of combining the two.

Interested in learning more? Visit our website to and see how customers are using frevvo today to improve efficiency and productivity.

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

[Infographic] frevvo + Google Apps

Print

Organizations use frevvo to digitize day-to-day approval workflows in the Cloud such as expense reports, purchase requisitions and employee on-boarding. These workflows generate documents that must be securely stored and managed somewhere – typically some sort of ECM (Enterprise Content Management) system.

Organizations (including frevvo Inc.) use Google Drive as a Cloud-based system to store and manage enterprise content and to collaborate on that content including both unstructured content such as videos, images, spreadsheets, & presentations and structured content such as invoices, sales orders, & expense reports.

The fit is obvious and natural. If your organization uses Google Apps, you can combine frevvo + Google Apps to solve real business problems, improve productivity and efficiency and allow employees to focus on customers, students and patients instead of being bogged down in paperwork.

Check out this new infographic on the benefits of e-forms and approval workflows with frevvo integrated with Google Apps.

From electronic signatures to dynamic pick lists to using Google Drive as a content repository to approval workflows, the combination just makes completing routine, day-to-day business tasks easier.

It’s 2016! There’s simply no excuse for outdated, manual systems that cause delays, result in unhappy employees and wasted time and money.

frevvo already has pre-built forms and workflows that can be customized in next to no time and deployed online. They can all be signed online, routed to the proper person electronically, used on mobile devices, delivered in multiple languages, generate PDFs, work with Google Apps and a whole host of advanced capabilities. There’s no need to deal with printing PDFs for signatures, correcting Excel-based time sheets, or tracking down approvals in email.

Learn more by visiting our website. Explore some of the examples, read customer success stories and contact us for more details.

Posted in Approval Process, Customers, Google for Work, Google Spreadsheets

[Customer Success Story] High Hopes frees up personnel to focus on participants

High HopesHigh Hopes, established in 1974, is a non profit, therapeutic horseback riding center. They serve individuals with disabilities through equine assisted activities, offer educational opportunities for professionals and rely on their volunteer corps for many administrative duties.

With a growing staff and significant volunteer corps, they were finding their paper-based processes (to track cancellations, volunteer inquiries, training and education candidates) to be cumbersome and wasteful.

“Now that we use frevvo regularly to manage our daily communication chains and workflows, it’s hard to imagine how we managed without it.” Megan Ellis, Volunteer Manager, High Hopes

They turned to frevvo’s cloud-based solutions to automate these. Using electronic forms and approval workflows that work with Google Spreadsheets, they’re saving time & money and, most important of all, they’ve freed up employees’ time so that that they can focus  on the participants they serve.

Read the Case Study and Sign up for a Free 30 day trial today.

Posted in Approval Process, Forms, Google Apps for Business, Google Apps for Education, Google for Work, Google Spreadsheets, Workflows

frevvo + Google for Work == So much you can do!

Google for Work is an awesome suite of apps that brings together essential services for your business. It’s amazingly cost effective, cloud-based and you can access it anywhere, anytime. Add frevvo web forms and workflows to the mix and there’s so much you can do. Check out the short 5 min video below to learn more.

Like what you see? Visit our web site or contact frevvo for more information.

Posted in Forms, Google Apps for Business, Google Apps for Education, Google for Work, Google Spreadsheets, Mobile, Usability, Workflows

10 reasons to choose frevvo over Google Forms

Google Forms is a great free option for the simplest forms. But, business forms very quickly go beyond the basics and frevvo is a powerful and affordable option. So, why should you pay for forms? Here are a few real-world reasons. frevvo + Google Apps Click this link if you prefer to watch a 5m video.

  1. Confirmation email: You’ve put up an event registration form and you’re collecting responses in a Google Spreadsheet. Obviously, you want to send a confirmation email. With Google forms, get ready to write code. With frevvo, it’s a few clicks in a wizard.
  2. Signatures: It’s one of the most common things you might do. From Emergency Contact forms for students to Purchase Requisitions to Employee On-boarding to Patient Information, everyone needs to collect a signature. With frevvo, sign using your finger on a touchscreen device or a mouse on the desktop. No need for wasteful printing and scanning. Try an example now.
  3. PDF Generation: Sometimes you just have to generate a specific PDF. Maybe a Government W-4 or I-9 for HR or a Permission form that needs to be filed away. Another thing that frevvo just does without a fuss. Try an example now.
  4. Workflow: Forms rarely live by themselves. Most business forms have an associated workflow where person 1 fills out the forms and others comment, review, and sign them. frevvo comes with built-in routing, notifications, task lists, audit trails and more. Watch this 3m video to learn more.
  5. Responsive, mobile forms: Need to support smart phones and tablets? Of course, you do. With frevvo, there’s nothing to do. Our forms and workflows just work automatically and naturally on all devices. Watch this 4 min video, check out these blog articles or try any of the examples in this article.
  6. Attachments: Expense reports, purchase orders, student applications you name it – users need to attach supporting documents all the time. Just drag in an Upload control and it just works with frevvo. On a mobile device, users can just take a photo with the camera and attach it. Another thing you simply can’t do with Google Forms. Try an example now.
  7. Save documents to Google Drive: Ok, your form or workflow is now generating some documents – a PDF or two, some attachments. What to do with them? Email, print and file them away? frevvo integrates with Google Drive so you can simply save your documents online so they’re easy to find, backed up and secure. Try an example here.
  8. Dynamic pick lists from a Google Spreadsheet: Do you have dynamic forms? For example, the user picks a value from a pick list and the form needs to do something – maybe populate a few other fields from some back end. With frevvo, you can pull this dynamic information from a Google Spreadsheet no less. Try an example here. And this is just the tip of the iceberg. frevvo forms are incredibly dynamic and sophisticated – database, REST services, XML/XSD it’s all built-in.
  9. Multiple languages: Unprecedented demographic shifts in the U.S. are creating a communications gap between organizations and their customers. frevvo can help you combat these language barriers. Provide access in multiple languages (frevvo works in all languages worldwide) so they can provide important information easily and accurately. When complete, the system can generate PDF confirmations in multiple languages. Try an example here: Spanish version and English version.
  10. Calculations: frevvo forms can perform sophisticated calculations including using cloud services. Try this example that does automatic mileage calculations using the Google Distance Matrix API. Subtotals and totals, tax calculations etc. – it’s a normal requirement for business forms and trivial to do with frevvo.
  11. Bonus Reason – LOOKS: Let’s face it. Good looks matter. The nicer your forms look and the better the user experience, the more likely it is that users will complete your forms and do so accurately. frevvo looks fantastic everywhere, strives for a people-first user experience, is easy to brand and customize and provides a world-class user experience.

There’s a lot more like an intuitive drag & drop Form Builder, Conditional Sections, Spaces (built-in portals), Geo-Location, sophisticated XML/XSD-based integration, powerful API for embedding, Database connectivity, LDAP support and on and on and on …

Want to learn more? Learn more by visiting our web site and contact us today. STILL want to try Google Forms?

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

Save submission data to a Google spreadsheet (take this short quiz)

With frevvo, it’s trivial to save your submissions to a Google spreadsheet.

  • Drag and drop to create your form as usual.
  • You can include sophisticated layouts, signatures, PDF, calculations etc.
  • Create your Google spreadsheet.
  • Run the Google Spreadsheets wizard to connect the form/flow to the spreadsheet.

VolcanoCheck out this short 5-question quiz. It has 3 pages, has several types of questions – free text, multiple choice with one/more correct answers, an image, and a video-based question. The quiz cannot be submitted unless all answers are completed. When you Finish the quiz, your answers are saved to this Google Spreadsheet and the spreadsheet is displayed. Try it out for yourself by clicking the image or this link. Try it on your mobile device.

There are many powerful things you can do with frevvo + Google Apps. Click the Google Apps category above for more articles and examples or contact us to learn how you can automate your approval workflows and integrate with Google Apps to manage your documents and reports.