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

Workflow Automation Any_____

I spend a lot of time with our customers. Most of them easily grasp the benefits of process automation. But many of them still have questions that generally fall into the “Will it work with my _____”?

Automating manual processes helps reduce paperwork and increase efficiency for a 50 or 5000-person company, for those who prefer Cloud or On-Premise, independent of where the organization operates, and the systems you have. Let’s look at how:

Workflow AnyTime

time-sheet.pngYour customers, partners and users want to interact with your organization on their own timelines. Often, they’re distributed all over the world.

If you can only process Sales Orders, Purchase Requisitions and routine approvals during business hours in your timezone, you’re probably losing business and wasting people’s time.

Automated workflows with frevvo are instantly available 24×7 – there’s no need to wait till you’re in the office at your desk, approvals can be processed from any time zone worldwide and your business can flow faster.

Continue reading “Workflow Automation Any_____”

Posted in Approval Process, Confluence Workflows, Financial Process Automation

[Video] Install and Modify a PO Template

purchase-order-videoPurchase Order Approval is a very routine day-to-day workflows. Many customers choose Live Forms to digitize this workflows.

Starting with one of our pre-built templates, you can easily customize it to create your own fully electronic, mobile-capable and business-ready PO in very little time. You won’t need expensive and hard-to-find skills like iOS/Android app development or HTML5/CSS3 expertise to create a beautiful, electronic app that just works on all devices.

At frevvo, we just digitized a completely customized Purchase Order approval workflow for a University customer in 45 man-hours.

Watch this short (7 min) video to quickly see how. We’ll show how to:

  • Install a pre-built PO workflow template with a single click.
  • Modify it to meet business requirements (we’ll add a Finance step).
  • Run it in frevvo’s Cloud.

Hundreds of customers are already benefiting. 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 Misc

Tracking with Google Analytics

frevvo-analytics

Google Analytics is a freemium web analytics service offered by Google that tracks and reports website traffic. It’s the most widely used web analytics service on the Internet. If you’re using Google Analytics, you can integrate frevvo forms and workflow traffic into Analytics.

The simplest way to track form or workflow usage is to add your Google Analytics Tracking Id in the form’s Tracking Id property. Now every time someone uses this form or workflow, frevvo will transmit a Pageview to Google Analytics. You’ll be able to see this as a standard web page view in all Analytics reports.

If you wish, you can enable fine-grained tracking. For example, you want to track events like specific value changes on the form, form submission etc. You can use Custom JavaScript to call Google Analytics during these events.

Here is a sample script to call Google Analytics when user submits the form:

var CustomEventHandlers = {
setup: function(el) {
if (CustomView.hasClass(el, ‘s-submit’)) {
FEvent.observe(el, ‘click’, this.submitClicked.bindAsObserver(this, el));
}
},
submitClicked: function(evt, el) {
_gaq.push([‘_trackEvent’, ‘Purchase Order form submitted, ‘clicked’]);
}
}

You can observe a wide variety of events on any control in your form and track them individually at any level you desire. Please see the documentation for details on custom event handlers.

Posted in Approval Process, Confluence Workflows, Forms, HR Process Automation, Workflows

[Workflow Template] Travel Authorization and Reimbursement

travel-authorization
8.5m video. Create your own fully functional travel authorization & reimbursement workflow

Travel Authorization and Reimbursement is a common workflow that’s used by employees to request authorization for expenses prior to travel and t
hen to reconcile actual expenses before submitting for payment. If actual expenses exceed estimated expenses, the workflow will obtain additional approval. Finally, the workflow routes to the Finance Department for payment.

We’ve created this short (8.5m) video to help you install, configure and try out this template. We know that it’s one of our most frequently downloaded workflow templates.

Click on the image to view the video and see how you can start with a pre-built template and have a fully-functional travel authorization workflow in less than 15 minutes. You can also view the documentation for this template.

Posted in HowTo, Product

frevvo 7.1: Submissions Search

We’re always working on improving frevvo based on customer feedback. We have ambitious longer-term plans but we’re tackling some of the most common requests ASAP.

frevvo V7.1 (which will be available later this year) includes one such item: the ability to search for submissions based on form data. There’s also a new Submissions View and Excel export. Let’s take a look using a Contact Form.

searchable-fields
Searchable Fields wizard

First, you have to define your Searchable fields using a wizard. Simply add/remove Searchable fields as desired. Once defined, frevvo can also go back and re-index your existing submissions so you can search them using the same fields. In our Contact Form, we’ve chosen First Name, Last Name and Email Address.

Then, go to the Submissions View for the form. By default, you’ll see the Submissions for the past month with no other filters applied. Searchable Fields appear in the table if they fit.

Expand the Submissions Filter Section. You can filter and search for submissions by a wide variety of criteria. There’s Date Range and Submission State but you can choose other criteria including the Searchable fields. You can also create a logic expression as shown in the image. We’re searching for Submissions this year where the email address contains frevvo.com and the first name begins with either M or P as the shown in the logic expression field.

filter
Filter/Search for submissions

If the columns don’t fit on the screen (for example, on a mobile device), you can click + for any row to view them. As usual, you can double click any submission to view details (XML document, PDF, attachments, signatures etc.) and delete unwanted submissions.

submssions
Expand/Collapse individual submissions to view details

Similar functionality is available in the Task List as well – we’ll describe it in a separate article. And, in a future release, we plan to unify these user interfaces so you can handle tasks, submissions and reports from the same place in the UI.