Grid (Table) Control
April 30, 2012 Leave a comment
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.
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.
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.