Posted in Forms, Workflows

Visual business rules for dynamic forms

Does Anyone Know Where We Keep the Unwritten Rules cartoon. Man shuffling papers from a file cabinet.

Business and educational forms & processes are usually dynamic – think purchase orders, emergency contact forms and travel requests. Our customers love how easy it is to visually design forms. With the Visual Rule Builder, they can easily create dynamic forms without the need to know JavaScript.

Learn more: Watch this 6m video to quickly learn more.

Continue reading “Visual business rules for dynamic forms”
Posted in Database

How to easily create Dynamic Database Forms

Useful processes connect to the database.

Practically every organization has at least one SQL database and often many of them. Many day-to-day business activities are simply more useful if they can access information from SQL databases on-demand.

For example, when a customer calls about a mistake on their order, your Customer Service personnel will be able to better help the customer and solve the problem quickly if they have visibility into order history from the database. Faster problem resolution leads to happier customers.

Continue reading “How to easily create Dynamic Database Forms”
Posted in Forms

Go the extra [online forms] mile

simple-visual-tools.png

Forms are a part of life but they don’t have to be tedious and ugly. Clean, well-designed online forms help customers provide needed information quickly and painlessly. What if your existing employees could do it all using simple visual tools without coding?

Join us for this 45 minute webinar on Nov 15 at 1:00 PM EST. We’ll show you online forms that:

  • Look great on all devices.
  • Dynamically adjust so they’re easy to complete.
  • Never need to be printed.
  • Route automatically for approvals.
  • and more …

save-my-seat

Posted in Low Code Platform, Workflows

[Video] 100% Visual Purchase Order Automation

Workflow automation is the foundation of digital transformation. But, automating everyday processes isn’t always easy. Dynamic forms, complex routing, e-signatures, mobility and more … it’s a lot to handle and that’s if you can find the necessary programming talent. What if your existing people could do it all using simple visual tools? Watch this brief video to see how easy it is with frevvo’s 100% visual, low-code platform.

workflow-automation-video.png

To learn more, visit our website, try frevvo absolutely free for 30 days or contact us for more information.

Posted in Workflows

How Dynamic Forms Streamline your Workflow Process

Paper-based processes throttle the growth of an organization. There are simply too many bottlenecks in designing, filling, and storing paper forms. On top of that, when you consider the costs of correcting errors and dealing with misfiled, damaged or lost forms, it’s easy to see how paper-based processes are expensive and inefficient.

frevvo’s cloud-based software offers fully automated dynamic forms and workflows designed to enhance productivity and drive down process costs. Now, it’s easy to get secure access to your documents and data from your mobile phones, and to share, save and process forms and approvals in a timely manner. frevvo unifies access control, user rights, and administrative settings through all devices ensuring complete security. Continue reading “How Dynamic Forms Streamline your Workflow Process”

Posted in Digital Transformation, Forms, HowTo

How Dynamic Forms Accelerate Digital Transformation in Your Organization

Forms represent about 83% of all business documents. A typical global enterprise uses an average of 400 complex business forms. If you are using printed forms, then you should know that about 15 to 33% of printed forms are either thrown away due to errors or discarded as they become obsolete after a certain time.

Moreover, a printed form will cost extra due to printing and paper cost, but the average processing cost of a smart form is comparatively cheap. Do you know, about 3% of paper forms are filled incorrectly, 7.5% of filed paper documents are lost in transit, and about 90% of the time spent to manage paper forms involves handling and shuffling them?

Smart dynamic forms; on the other hand, offer a chance to amend or update the form virtually on the go. In fact, integrated dynamic smart forms have the capability to streamline your organizations’ document management or workflow process management capability by reducing overhead costs.

Continue reading “How Dynamic Forms Accelerate Digital Transformation in Your Organization”

Posted in Customers, Forms, Workflows

At Tailored Brands, a team of just 2 people has successfully implemented 100+ forms in their 1400+ locations.

suits

With leading menswear retailers such as Men’s Wearhouse and Jos. A. Bank, Tailored Brands provides a one-of-a-kind shopping experience with compelling products and world-class service via their 1400+ locations in the U.S. and Canada.

Read-Case-Study

They were using a different product which generated very large files, required local emails, was hard to use for dynamic forms and was expensive to maintain. Their Manager of Intranet, Jim Rinke, decided to investigate alternative products for their digital transformation journey.

After a lengthy search, Tailored Brands selected frevvo in 2011 for its drag-and-drop design, robust dynamic forms, 100% browser-based interface and the ability to route the form to different recipients based on user data.

“We were looking to replace the product we were using with a system that would work in our 1400+ stores.

Our forms are highly dynamic and can have complex business requirements. Using frevvo’s visual designers, we’ve now implemented 100+ forms & workflows. frevvo Cloud just works and meets our needs at reasonable cost.”
– Jim Rinke, Manager, Intranet & Documentation

Using frevvo’s low-code, visual solution, Tailored Brands’ team of just 2 people has now implemented 104 forms and workflows for a wide variety of use cases such as Inventory Request, Store Appearance Checks by multi-unit managers, Theft/Robbery/Damage forms, Employee or Customer Injuries and others.

The benefits are enormous:

  • Previous forms were seamlessly replaced with online versions.
  • Small file sizes mean they work fast and efficiently in the store locations.
  • Dynamic behavior is easy and the forms automatically show/hide sections based on user data, perform calculations etc.
  • Built-in mobile allows employees to use an iPad to complete forms.

Tailored Brands intends to continue rolling out additional forms and workflows, especially workflows that can route directly to an email address (anonymous user).

Read-Case-Study

Learn more by visiting our website.

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 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 HowTo

How To: Dynamic email addresses

A question we get asked frequently is how to send an email from a form or flow submission where the email address of the recipient is dynamically determined at runtime. For example, I have a drop down control and if the user selects HR, I want the email to go to the HR Department (hr@example.org) and if the user selects Finance, I want to send it to Finance (finance@example.org).

It’s very easy in frevvo.

1. Create a hidden Email control in your form.

AdminEmail

Drag & drop an Email control in your form. In the Properties panel, uncheck Visible so the control is hidden from the end user. Name the control Admin Email. We assume that you already have a drop down control (in the screenshot, it’s called Department and the choices are HR and Finance).

When the user selects HR from the Department drop down, we’ll set the Admin Email hidden control’s value using a business rule.

2. Set the Admin Email address using a business rule

Create a simple business rule.

if (Department.value == ‘HR’) {
AdminEmail.value = “hr@example.org”;
} else if (Department.value == ‘Finance’) {
AdminEmail.value = “finance@example.org”;
} else {
AdminEmail.value = null;
}

In frevvo’s Winter release (expected in late 2017), you’ll be able to create these type of rules visually with the Visual Rule Builder.

3. Use the Admin Email control in the To: email

AdminEmailWizard
Email Wizard that uses a control template

In any Email wizard, you can use the Admin Email hidden control for the To:, Reply to:, Cc: and other fields. In the above example, we’ve used it for the To: field.

That’s it. When the User selects HR, the rule will set the Admin Email control to hr@example.org. When the form is submitted, the Admin Email template in the To: field will be evaluated and will resolve to the value of the corresponding control (hr@example.org). The email will be sent to the dynamically resolved email address.