Tag: frevvo form

Grid (Table) Control

One of the most common things we have heard from our customers is the need for a data-entry Grid /Table. It’s possible to create this today using a repeat control and some fancy layouts but it’s cumbersome. We’ve been working on that and it’s close to complete.

Using it is simple: there’s a new control in the palette called Table. Drag and drop a Table into your form. By default, it has three columns. You can edit the table name, column names, drag and drop new controls from the palette, and set the widths of the columns. You can control the min/max number of rows in the table – Add/Remove icons will automatically appear to the left. You can also use business rules as usual for computed values, enabling/disabling fields, showing/hiding fields etc.

The image below shows an Expense Report created using the Table. Users pick the date and specify their expenses by category with a description. Additional rows can be easily added by clicking the + button. The form contains rules to compute the mileage expense based on the miles traveled and the Total expenses. In this example, the Table is placed in a Section which the user can digitally sign and lock so that it cannot be modified.

Expense Report using Table Control
Expense Report using Table Control

The Table control can also be used for static grids where the number of rows is fixed. The image below shows a time sheet with one row for each day of the week. Obviously, the user cannot add more rows or remove existing rows but simply fills in data into the grid according to the number of hours worked in a given week.

Time sheet using Table Control
Time sheet using Table Control

The Table control provides an easy way for customers to create data-entry grids that are common in forms. As with all frevvo controls, it is fully internationalized and supports input in all languages worldwide including right-to-left languages such as Hebrew and Arabic.

Development on the Table is almost complete and we expect to release it soon.

How to process form/workflow data

Now that you’ve created your form or workflow, what are the various things you can do when it is submitted? With frevvo, there are many many flexible options. You can simply view your submissions online or send them to your own web server for processing or use the frevvo API to perform detailed post-processing of submission data. We’ve documented this in this new Tutorial on processing form data.

We’ll keep updating this as required but if you want to see all the optionsĀ availableĀ to you, check it out.

Reusable controls with the custom palette

With Live Forms, you can create complex reusable controls including sophisticated layouts, validation patterns, business rules etc. Once these controls have been created, you can publish them within the form designer. Other users can search for and find the published controls and re-use them in their own forms without having to re-create the layout, rules etc.

If you think you can use this, check out this 4.5 min video that shows all:

Form layouts using Panels, Sections, Tabs & Repeats

With Live Forms you can create forms with very sophisticated layouts that are similar to your most complex existing forms. The best part is there’s no programming or CSS or JavaScript involved. Just drag and drop.

  • Using Panels, you can easily create multi-column layouts with controls next to each other.
  • Sections allow you to create collapsible groupings of controls and place logically-related controls together.
  • Tabs are a great way to fit large forms into limited real estate.
  • Repeat controls are extremely powerful and can be used to create repeating individual controls (nick name, phone …) or repeating sections (address, incident …). frevvo will manage min and max occurrences automatically and ensure that invalid forms cannot be submitted.

This short (5 min) video introduces you to using these grouping controls for form layout.

There are many other cool things you can do with frevvo forms but that’s for another article and another video.

Creating/Updating Confluence pages

Customers have long inquired about the ability to create Confluence pages from frevvo forms for structured content. For example, a Client dashboard or Customer support application in Confluence.

Let’s say you want to create a Client dashboard with a Confluence page for each client. Either clients themselves or internal employees can easily create/update their information using the wiki editor. The problem is that it’s hard to keep the pages consistent since the wiki editor lets people create free-format pages. That’s where frevvo comes in.

Instead of creating/updating these pages via the wiki editor, clients and employees are presented with a form. The form enforces structure, business rules, validation etc. When the form is submitted, frevvo will generate a Confluence page for the client; the page can be named using data from the form (e.g. client name). frevvo can also generate an Edit link on the page. When clicked, it takes you back to the form pre-filled with the client data. You can edit the data and submit. frevvo will then update the client page with the updated data.

It’s really quite easy to do. You can see for yourself in the 4 min video below:

Drop-dead simple Confluence Workflows

Workflows, in particular, simple approval workflows are extremely common at business organizations of all sizes. For example:

  • An Expense Report that must be approved by your Manager
  • Vacation Request that needs approval
  • Patient Referrals where a Nurse or Physician’s Assistant fills out the top part of a form, a Doctor has to sign it and then send it to the hospital
  • Issue Tracking where an Employee creates an internal support issue and admin support staff take multiple actions on the issue before closing it

It’s easy to automate these workflows using Live Forms for Confluence. You can view a 7 minute video or read this article in the documentation.

We’re excited about these powerful, easy-to-use workflows seamlessly integrated into Confluence. We think customers are going to find them super useful too.

Excited about our new Confluence release

It’s been an unbelievable time – obviously, we haven’t updated the blog at all recently. We’re really excited about our new product for Atlassian Confluence. We’ve been working with quite a few customers who have now successfully used frevvo within Confluence for things like:

  • Issue tracking systems
  • Event registration (download submissions to MS Excel)
  • Patient referral
  • Student enrollment

and many other applications.

The new version has full user/group integration with Confluence, works with your Active Directory/LDAP systems, includes workflows, digital signatures, task lists in Confluence, the ability to create/update Confluence pages from forms & workflows, the ability to collect multiple submissions in a single Confluence page etc.

I’ll be writing more about these over the next several weeks.