Gridform Ribbon
The Gridform ribbon above the grid contains the following buttons:
Note: Depending on settings in the gridform, you might not see all the buttons described below.
Ribbon Button |
Description |
---|---|
Save |
Saves the values you added, modified, or deleted in the grid to the database. This button is visible when the gridform is changed in any way. Note: Always remember to save your values before closing the gridform or logging out. |
Add |
Adds a new row in the grid in order to add more records. |
Refresh |
Refreshes the data in the grid. Caution: All unsaved values will be lost. |
Close |
Closes the gridform. Caution: All unsaved values will be lost. |
Cancel |
This button is visible when you modify the gridform. Click Cancel to reverse your changes. |
Back to Design | Leaves the gridform and goes back to the design template. |
Selection Pane |
Opens the selection pane when the gridform is connected to a selection pane. If not, this button will not be visible. |
Select Rows |
Select multiple rows to duplicate. |
Duplicate Rows |
Duplicates the active row in the grid. An identical row is added. From version 8.7 its possible to select several rows and duplicate these. Previously only one row at a time could be duplicated. |
Quick Update |
Shows a quick update row where you can update several rows at the same time. Note: It is important to filter the grid with rows you want to update at the same time, otherwise all records in the grid will be updated with the same value (not available in 8.0). |
Group |
Drag any column in the grid to the Group field and the rows will be grouped by that column. To ungroup, drag the column back to the grid (from the Group field). |
Filter |
Opens a filter field the top of the grid. Here, you can select a value that you want to filter the rows by, or you can enter a value to filter on. In some columns, a filter icon displays in the column heading. Select the filter icon within the column heading to choose a filter. Select the filter icon at the top of the grid to hide the filter field altogether. |
Export |
Exports the grid to Excel. |
Share |
Select this button to copy the link to this gridform. Then, choose if you want to include Navigation and/or Header, and if you want URL or a link to embed the gridform. |
By default, the gridform opens in batch mode. On mobile, the default edit mode is pop-up. However, you, as a user, can select another edit mode. The following options are available:
Form mode and popup mode can be useful when the grid contains a large number of columns that need to be filled out for each record row. |
|
By default, the grid will fit the columns to content. However, you, as a user, can change this in the menu. The following options are available:
|
|
Grid Mode |
Changes grid mode between paging and scrolling. By default, the grid mode is set to Paging. |