Blog

Add new rows using the grid

  • 21 January 2019
  • 0 replies
  • 422 views
Add new rows using the grid
Badge
Previously, you always had to have a form component on your screen to be able to add new rows. This is no longer necessary, because the grid now also supports adding new rows. This feature is released with version 2018.2 of the Thinkwise Platform (Windows GUI only).

What’s new?

When adding new rows is enabled for a grid, an empty ‘add row’ is displayed at the top of the grid. Be aware that only the values of columns that are visible in the grid can be filled in.

The ‘add row’ is positioned directly under the grid column header, so it is clear which input field belongs to which column. It is also possible to only show the ‘add row’ while adding or copying. This can be configured in the Software Factory.


A new row can be created by clicking on a cell of the ‘add row’ or on the ‘Add’ (Ctrl+Plus) or ‘Copy’ (Ctrl+Alt+Plus) buttons in the ribbon. If the screen type has both a grid and a form, make sure the grid has the focus! After filling in the mandatory values for the new row, it can be saved by leaving the row or clicking on the ‘Save’ (Ctrl+Enter) button in the ribbon.

Adding new rows in a grouped or sorted grid

When adding or copying a row in a grouped grid, the values of (editable) fields that are grouped on will be copied to the new row. This way, the grouped columns that aren’t accessible in the grid will have a correct value and the newly added row will end up in the right group. A grouped grid never has a fixed ‘add row’, the new row will be displayed only when adding or copying.

It is also possible to mark other (non-grouped) columns that should be ‘copied’ from the selected row when inserting a new row. Only the values of columns that are sorted on will be copied. You can use it to simulate inserting a row between other rows too, by copying the order number of the selected row and using that value in the default procedure to calculate the new order number.



Software Factory Configuration

Three options have been added to the Software Factory to configure the new features: the ‘Include in insert’ column setting (see image above), and the ‘Add’ and ‘Add row visibility’ grid settings (see image below). Just check the ‘Add’ checkbox and the ‘Add row visibility’ field will be shown. The default value for the visibility of the ‘add row’ is ‘When adding’, because we prefer clean screens. However, it is also possible to always show the ‘add row’, to indicate to your users that it is possible to add new rows using the grid.


0 replies

Be the first to reply!

Reply