Automate your PO. Save $50,000 !!

roiWe’ve seen that many customers use frevvo to automate Purchase Orders. It’s the most frequent one. One of our partners asked me if I could quantify what’s it really worth. So, I tried to measure it for a 3-step approval workflow and the result was surprising at least to me. Here are the assumptions:

  1. An Employee costing $80,000/year (including benefits/taxes/vacation etc.) saves 10 min using an e-form.
  2. A Manager costing $100,000/year saves 3 min for each approval.
  3. An Accounting Manager costing $60,000/year saves 3 min for each invoice.
  4. There are 400 approvals/month (for all kinds of workflows PO, Leave Approval, Travel Authorization, Time Sheet etc.).

You’ll save ~$50K every single year or 57% of your costs. It’s amazing how much the paper/email process actually costs you – close to $85K per year. You’ll see positive ROI in just a bit over 2 months. And that doesn’t even take into account the time spent trying to track down emails, chasing down managers for signatures or, perhaps of greater importance, the Opportunity Cost of delayed approvals.

Try this ROI Calculator for your own organization. It’s often hard to see how much those paper/email workflows are really costing you. Visit our website to view customer success stories and signup for a free trial.

Aero Communications replaces paper, Excel and InfoPath with automated workflows integrated with SQL

Aero Communications inc. provides customer-focused technology solutions to broadband and wireless providers, businesses, public venues, government facilities, and residential subscribers.aero-communications

The company was using a number of paper, Excel & InfoPath forms for everyday business processes such as Vehicle Inspections, Facilities Maintenance, Financial Forms and Warehouse Orders. Many of them require approvals forcing employees to email them around and print/sign/scan for approval. In addition, the existing forms could not pull data from SQL databases resulting in excessive and duplicate data entry, errors, corrections and inefficiencies.

“We were looking for a single, affordable solution that could address all our requirements.

frevvo’s modern, online system is easy-to-use, and meets our needs at a reasonable cost. Live Forms is the best web-based forms & workflow solution on the market today for our needs.”

–Adam Wiener, Applications Specialist

Aero Communications considered a dozen+ solutions before selecting frevvo Live Forms because it provided an easy-to-use solution that works with their database, and integrates with Active Directory at an affordable cost.

They have already replaced multiple forms and workflows with fully automated online versions. Read the Case Study and learn more by visiting our website. Explore some of the examples, read customer success stories and contact us for more details.

[eBook & Video] frevvo +SQL: dynamic forms & workflows

db-video

Dynamic database forms and workflows with frevvo + SQL (3m video)

Day-to-day business activities are simply more useful if they can access information from SQL databases on-demand. If Customer Service has visibility into order history from the database, they can better help the customer. HR applications can access employee data and so on.

Download frevvo + SQL eBook or Watch 3m video

frevvo provides a Database Connector that allows you to perform sophisticated integration with your database. From dynamic dependent pick lists to master-detail views to creating and updating records in SQL and running stored procedures, you do it all with frevvo.

Learn more by downloading our new eBook or by watching the video at the links above and visit our website to view customer success stories and signup for a free trial.

[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.

Mercy Ships replaces Adobe LiveCycle & DocuSign to automate over 70 day-to-day forms/workflows

Mercy Ships, a global charity, has operated a fleet of hospital ships in developing nations since 1978. Mercy Ships follows the 2000-year-old model of Jesus, bringing hope and healing to the world’s forgotten poor.
africa-mercy
The organization was using Adobe LiveCycle forms or DocuSign and e-mailing documents around for signatures and approvals. However, as major browsers on desktop and mobile devices dropped support for the Adobe plugin, it was getting increasingly difficult to use. They decided to standardize on a single product that could handle forms, workflows and signatures.

We wanted a single, affordable solution that would be able to address our forms, workflow and document signature requirements. frevvo’s modern, browser-based solution is easy-to-use, meets all our business needs at a reasonable price.

Live Forms is the best web-based forms & workflow solution on the market today to address our needs.

Chris Gregg,
Chief Information Officer

Mercy Ships selected frevvo Live Forms because it provided an easy-to-use solution that handles forms, workflow as well as signatures at an affordable cost. In addition, frevvo’s generous support for non-profit organizations and world-class Customer Success team have ensured a successful deployment.

Mercy Ships has now automated 70+ day-to-day forms and workflows from HR to Volunteer processes with several more to be rolled out in the near future.

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

[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.

frevvo + SQL: Part 5. Create/Update records

DBConnectorPrevious articles in this series (Create dynamic pick lists initialized from SQLMaster-detail views from SQL and Handling multiple results from a Query) have focused on reading information from the database and dynamically initializing fields on your form.

But, many business problems require creating new records or updating existing records in the database. Today, we’ll take a look at these scenarios and see how you can create complex forms without programming using frevvo’s Database (DB) Connector. Fair Warning: this is a fairly technical article so we’ve only touched upon the highlights here. You can explore in detail by reading the DB Connector Tutorial in the documentation.

As before, you’ll need to install and configure the DB Connector one-time so it can connect to your SQL database. After that, the steps are very similar to the previous articles:

1. Define the SQL Queries

This time, there are multiple SQL queries.

<queryset name=”BIRT” …>
  <query name=”createOrder”>
    <retrieve>
      <statement>SELECT orderNumber as onum, customerNumber as cnum from Orders WHERE orderNumber=10100
      …
    </retrieve>

<create>

      <statement>INSERT into Orders (orderNumber,orderDate, requiredDate, status,customerNumber) VALUES ({onum}, Now(), Now(), ‘In Process’, {cnum})

      …

2. Generate an XML Schema

The first query is used to generate an XML schema and form controls bound to that schema. There will be two (onum and cnum). In this case, you’ll have to modify the XML a bit due to a current limitation in the DB Connector. See the documentation for detailed instructions.

3. Create the form

Generate the form using the above XML schema as a data source.

4. Link to the database

Connect it to the DB query defined above. We use Doc URI wizards with the only change being that we configure a Write URL using HTTP POST (create) instead of a Read URL.

That’s it. When the form is submitted, frevvo will generate an XML document with values for onum and cnum and send the XML to the DB Connector. The Connector will extract onum and cnum from the XML and execute the INSERT operation.

Insert Multiple Records

It’s easy to build upon this to satisfy far more complex business requirements. For example, in this case, you want to insert an Order but there will also be multiple Order Line Items. This means running an INSERT for the Order itself + multiple INSERTs for the line items with different data. Fortunately, with frevvo you can create forms with multiple Data Sources. Each one generates its own XML document and each one can have its own Doc URI.

dbconnector-post

A single frevvo form can process multiple documents and execute multiple SQL queries when the form is submitted.

Update Existing Records

You can equally easily update an existing record with the DB Connector. The process is almost identical. The only difference is that you will use an <update> query instead of a <create> query and the document is sent using HTTP PUT instead of POST.

<queryset name=”BIRT” …>
  <query name=”customerCreditLimit”>
  <update>

      <statement>UPDATE Customers SET creditLimit = {creditLimit} WHERE customerNumber={cnum}

      …

The rest is identical. Generate the form using an XML schema, connect the resulting document to this query and frevvo + the DB Connector take care of the rest.

Auto Create Rows

You can also setup the queries so that they will first try an update and if it fails, create a new record.

<query name=”customers” autocreate=”true”>

The autocreate feature is particularly useful when working with Repeat Controls or Tables. With these controls, your forms can work with dynamic collections, for instance: customers, cars, addresses, dependents and others. When the user loads the form, the form may be initialized with some items. If the user adds new items to the collection, updates a couple and submits the form, the items will be automatically added to the database and the existing ones will be updated if autocreate=true.

Auto Delete Rows

Auto-creation raises the obvious question. What if the user deletes a row from the repeating collection described above. If you want the DB Connector to delete the corresponding records from the database, you can simply set the autodelete property and provide a key.

<query name=”customers” autocreate=”true” autodelete=”true” deleteKey=”customerId”>

Behind the scenes, the connector compares the items in the database with what is submitted in the form. That comparison is based on a key that you define with the attribute deleteKey (required). The deleteKey value is normally the name of the primary key in the table that contains the repeat items.

Interested in learning more? The Database Connector Tutorial explains this in great detail. Register for an upcoming webinar and visit our website to view examples, watch videos, sign up for a free 30-day trial or contact us for more information.