Posted in HowTo, Product

[HowTo] Create a Salesforce Lead from frevvo

art-cogs-colorful-171198 (1).jpg

In the last post, we described how to integrate a frevvo form/workflow with Quickbooks to create a new customer. Another common integration we see is with Salesforce. Similar to the Quickbooks integration, you can use the combination of Google Sheets + Zapier to make things happen in Salesforce when a frevvo form/workflow is submitted.

For example, let’s say you want to create a new Lead in Salesforce. The process is very simple and similar to the Quickbooks example.

1. Create your Google Sheet

Screen Shot 2018-05-21 at 9.23.54 PM.png

Our example has several fields as shown above and test data in the first row. Make sure yours has a header row and at least one row of sample data. The columns in your sheet will depend on your Salesforce Lead fields. You must have a column for each required Lead field.

2. Create a Zap (in Zapier) and setup Google Sheets

Select Google Sheets as the trigger app, choose “New Spreadsheet Row” as the trigger, connect your Google Account, choose the Spreadsheet and Worksheet and pull in the sample row you created earlier.

 

This slideshow requires JavaScript.

3. Connect the Action of the Zap to Salesforce

Choose Salesforce as the Action App, select the Create Lead action, connect your Salesforce account, map fields to setup the Salesforce Lead template, and run a Test. Assuming the test is successful, give your zap a name and activate it.

 

This slideshow requires JavaScript.

4. Create your frevvo form or workflow and connect it to Google Sheets

Create the frevvo form with the appropriate fields and connect it to Google Sheets using the Save to Google Sheets wizard. When the form is submitted, a row is created in your Google Sheet. After a few minutes, the Zap will pick up the new row from the sheet and create your new Salesforce lead.

That’s all there is to it. With frevvo + Google Sheets + Zapier, you can easily and affordably integrate with 1000s of applications that Zapier supports without writing a single line of code.

Give it a whirl – sign up for a free trial today.

Posted in HowTo, Product

[HowTo] Create a Quickbooks customer from frevvo

google-sheets-1.png

As many of you know, it’s trivial to integrate frevvo forms and workflows with Google Sheets. There are many things you can do with this integration but the simplest and most common is to create a new row in the Google Sheet when a form is submitted. By combining this with Zapier’s integration platform, you can accomplish a vast array of integrations.

You can integrate with 100s of systems in this manner e.g. create a new Customer in Quickbooks. Here are the steps (this post has a lot of screenshots):

1. Create your Google Sheet

Screen Shot 2018-05-15 at 11.25.25 AM.png

Our example has several fields as shown above and test data in the first row. Make sure yours has a header row and at least one row of sample data.

2. Create a Zap (in Zapier) and setup Google Sheets

Select Google Sheets as the trigger app, choose “New Spreadsheet Row” as the trigger, connect your Google Account, choose the Spreadsheet and Worksheet and pull in the sample row you created earlier.

This slideshow requires JavaScript.

3. Connect the Action of the Zap to Quickbooks Online

Choose Quickbooks Online as the Action App, select the Create Customer action, connect your Quickbooks Online account, map fields to setup the Customer template, and run a Test. Assuming the test is successful, give your zap a name and activate it.

This slideshow requires JavaScript.

4. Create your frevvo form or workflow and connect it to Google Sheets

Create the frevvo form with the appropriate fields and connect it to Google Sheets using the Save to Google Sheets wizard. When the form is submitted, a row is created in your Google Sheet. After a few minutes, the Zap will pick up the new row from the sheet and create your new Quickbooks customer.

This slideshow requires JavaScript.

It’s as easy as that. With frevvo + Google Sheets + Zapier, you can easily and affordably integrate with 1000s of applications that Zapier supports without writing a single line of code.

Give it a whirl – sign up for a free trial today.

Posted in HowTo, Product

Workflow Templates & Guided Tours

frevvo is very powerful form and workflow software for automating your day-to-day processes. But, we recognize that there’s a learning curve. We offer numerous forms of no-obligation help including Online Chat, Office Hours and Templates.

Templates

frevvo’s recent V7.3 Cloud release includes several pre-built workflow and form templates. When you sign in to your Cloud account, you’ll see a box at the top.

templates.png
frevvo Cloud comes with several pre-installed templates

install-template.png
Click the green install button

These are pre-built form and workflow templates. You can click the More template apps green button to view all available templates. When you hover over any template, a green Install button appears. Simply click the button to install the template and you will be navigated to the Forms or Flows page for that template.

The pre-built templates are designed to let you quickly try out a workflow. They don’t apply any routing to specific users or roles so it’s easy to run the workflow for the first time.

Guided Tours

guided-tour.png
Guided Tours help you quickly try out templates

All workflow templates come with short Guided Tours. They usually take just a few minutes and we strongly recommend you follow along the first time. When you install a template, the Guided Tour should automatically launch. It’s walk you through the application screens, how to run the workflow and finally, how to modify the workflow to add some real routing.

If the tour does not launch for some reason or if you want to re-launch it, simply click the orange Guided Tour button on any screen. The tour will begin from that point on.

We hope you’ll find these pre-built workflow Templates and Guided Tours to be helpful in evaluating frevvo. We’re here if you need help. Click the yellow Online Chat at the bottom of your screen on our website or application. You can also sign up for Office Hours or Online Group Training on our website.

Posted in Product

V7.3 – SharePoint + other features …

We’re excited to announce that V7.3 is now available for Cloud customers. The on-premise version will be released approximately at the end of September. This release contains significant enhancements:

SharePoint Connector V1

sharepoint-workflow.pngYou can drag & drop using our intuitive browser-based form & workflow designers to create powerful business forms and approval workflows with all of frevvo’s advanced capabilities. Upgrade [not just replace] your InfoPath forms with frevvo’s advanced forms and workflows. Use point-and-click wizards to save your documents to a SharePoint library or to write data to a SharePoint list. It’s easy to try out online. Check out the short video demo of SharePoint workflows on our website.

Guided Tours and Page Help

guided-tour.pngIt’s easier than ever to try out a frevvo workflow. Simply sign up for a free 30-day trial account and you’ll be guided through installing a workflow template, trying it out and editing the workflow to make a simple change. Guided tours are also available for any workflow template. Context-sensitive help is available for many screens in the frevvo application. So, give it a whirl – it’s easy and takes just a few minutes.

Tons of Customer-requested fixes & enhancements

In addition, we’ve added many smaller new features. You can Test changes to a form or workflow without exiting the designer. It’s small but we’re thrilled about it – incredibly useful when you’re actually designing flows and want to test out a business rule change.

Step preconditions can be created visually using a wizard similar to the Visual Rule Builder, message controls limitations have been eliminated, the ComboBox control now connects directly to web services without the need for a JavaScript rule, and many other changes. You can read all about them in the Detailed Release Notes.

Interested in learning more. Sign up for a free trial on our website and try it out.

Posted in HowTo, Product

V7.3 – Dynamic pick lists & web services

One of the most common features our customers use is dynamic pick lists (or radio/checkbox controls). Examples abound such as a List of products for a Sales Order / PO, Number of available vacation days for a Leave Approval, List of projects for a Time Sheet and many others. With frevvo, you could always setup dynamic options using a business rule written in JavaScript.

/*member productCode, productName, resultSet*/
var x;
if (form.load) {
eval(‘x=’ + http.get(‘http://localhost:18080/database/BIRT/allProducts’));
var opts = [];
for (var i=0; i < x.resultSet.length; i++) {
if (x.resultSet[i]) {
opts[i] = x.resultSet[i].productCode + ‘=’ + x.resultSet[i].productName;
}
}
Products.options = opts;
}

V7.3 – no JavaScript

Products-WS
Selection Control connected to a web service

Starting with V7.3 (late August 2017), you can select an Options Source in the Properties pane for the selection control (drop down, radio or checkbox). By default, the Source is Design Time which simply means the choices are static and the designer specifies the list of options by typing them in at design time. But, you can now select Web Service. If you do that, three additional properties appear below:

 

  • Options URL: This is the end point for the web service. If you’re using the database connector,  it’ll be the same as the URL used in the JavaScript rule above. The assumption is that this call returns either XML or JSON.
  • Value binding: the path in the returned XML or JSON that determines the value of the select control (what’s in the submission).
  • Label binding: the path in the returned XML or JSON that determines the label of the select control (what the user sees).

That’s it. The URL can also be dynamic.

Edmunds
Selection control connected to the Edmunds API

For example, the screenshot at left shows a checkbox control that’s connected to the Edmunds API. The Options URL depends on the Year since that web service API returns Car Makes for a particular year. The URL is set to:

https://api.edmunds.com/api/vehicle/v2/makes?state=new&year={Year}&view=basic&fmt=json&api_key=<key hidden>

When the user types something in Year, the web service is automatically called, the results are refreshed and the choices in the Car Makes checkbox will change based on whatever the web service returned.

V7.3 will be released at the end of August. Visit our website and sign up for a free 30-day trial if you’d like to learn more or contact us for more information.

Posted in Product, Usability

Announcing frevvo 7.2

form-workflowToday we’re happy to announce the general release of frevvo 7.2. Cloud customers were automatically upgraded on April 29. On-Premise availability is coming up shortly – subscribe to Release Announcements for the precise date. This release also includes upgrades to the Database Connector.

We know that frevvo is powerful software but there’s also a learning curve. frevvo 7.2 is the first in a series of updates this year focused on making it easier to use.

Visual Rule Builder

VRBTopDiagram3

One of the main areas customers tell us about is Rules. They’re really really powerful and many customers love the flexibility of being able to write JavaScript code and create very complex, dynamic behavior. But, they can be hard to use. Enter the Visual Rule Builder. Using it, you can create many rules visually rather than writing JavaScript. Read more in this blog article and find detailed documentation here. We’re excited about this new capability and expect improvements over multiple releases to make it easier and increasingly capable of replacing JavaScript-based rules.

This release also includes some security enhancements – e.g. user ids no longer appear in URLs and are replaced by opaque UUIDs – and other under-the-hood improvements needed for future ease-of-use improvements.

Database Connector

The DB Connector is one of the most widely used connectors – customers have created all kinds of integrations with their SQL databases. Most of the improvements made in this release are fairly technical and we won’t go into details here. See the Release Notes for reasons to upgrade. We’ve also made several under-the-hood improvements so we can make this oft-used connector easier to use and as point-and-click as possible. We’ll detail those in future blog posts.

We’re excited about this release and several upcoming ones. The focus is squarely on updating and making so many of the good things we do easier to use.

 

Posted in Product

[Webinar] 45m to automate PO approvals

roiPurchase Order Approval is one of the most common day-to-day workflows. Many customers choose Live Forms to digitize this workflow and quickly see positive ROI.

Join us on this webinar where we’ll show you how to:

  • Install a PO template with a single click.
  • Run the template.
  • Edit the template and modify it.
  • Add users & roles for routing.
  • Add the workflow to a portal and use it on multiple devices.

Webinar Details
Date: Tuesday, Mar 21, 2017
Time: 1.30 PM EST
Duration: 45 minutes (including Q&A)

Register Now

Posted in Product

[Webinar] What’s new in frevvo 7?

webinar1frevvo V7 has been out for a few months. We’ve improved it in a number of ways that are really important to customers. We’re also really excited about some upcoming developments, especially the Rule Builder.

Join our webinar on Thursday, February 9, 2017. We’ll be covering:

  • One-click templates
  • Business Insights (Reports)
  • Improved Submissions & Task Search
  • Visual Rule Builder (coming soon)
  • File System Connector & Wizard
  • box.com Connector & Wizard

Webinar Details

  • Date: Thursday, February 9.
  • Time: 1:00 PM EST
  • Duration: 50 minutes (including Q&A)
  • Speaker: Ashish Deshpande

Register Now

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.