One of the most common approval workflows customers automate with frevvo is Leave Approval (Vacation or Absence Request). There are several types of leave (Annual, Sick, Floating etc.) and the typical workflow is Employee -> Line Manager -> Payroll/HR. Easy enough to automate.
But, wouldn’t it be nice if the form knew how many days of each type were left so there’s no way for the employee to request more days than he/she has available? Integrating with payroll/HR systems is possible but messy.
An easy alternative is to just use a Google spreadsheet. Here’s an example spreadsheet and a frevvo form that uses the spreadsheet. Based on the logged in employee, the form will pull the available days from the spreadsheet. For this demo, select an employee from the pick list (which itself comes from the spreadsheet) and you’ll see the available days pick lists updating dynamically. This demo only shows whole days but it’s trivial to extend to allow half days or even hours if necessary.
When the workflow completes and the leave is approved, frevvo will update the Google spreadsheet so it’s automatically kept in sync.
Yet another way frevvo helps you get MORE out of Google Apps for Work. Contact us for more information.