Allows the user to select multiple items from the grid.
Add button will be displayed and the user can add/insert rows by clicking on it.
The delete button will be displayed on the right side of the row.
This will enable editing the row by clicking the item.
This will let you search the grid with the search bar.
Grid data can be edited in several modes. Set the Edit Mode property to specify the mode.
A user edits data cell by cell. Changes are not updated until a user clicks the Save button. In this mode, the "Add" button is found above the grid rather than in the grid's header row, along with the Save and Reset buttons.
Batch With External Save
A user edits data cell by cell. Changes are not updated until a user clicks an external Block (e.g. a Button) with Update Data Sources corresponding to the grid's data source.
A user edits data cell by cell. Changes are saved once a cell loses focus, or discarded if a user presses Esc.
A user edits data row by row. When a user clicks an "Edit" button in the right-most column, the corresponding row enters the editing state, and the "Save" and "Cancel" buttons appear in the right-most column. Pressing the "Save" button will update your data source immediately.
This will show a search bar at the top of the Data Grid.
Allow Export to Excel
The export button will be displayed and by clicking it will export the grid into an excel file.
Enable Column Filtering
This will let you filter the results per column by clicking the filter icon next to the column name.
Enable Row Filtering
The search bar will be added for each column and the user can search the results.
Enable Filter Panel
Create Filter button will be displayed and clicking it will open a Filter Builder. If a user changes the filter expression in the Filter Panel the changes are reflected in the Enable Row Filtering and Enable Column Filtering, and vice versa.
This defines the default filter selected in the Filter Panel. Anyone visiting the page for the first time will have the same filter applied to the Data Grid. For example, every time this Data Grid has loaded records that start with the letter "C" are displayed. The filter will still be applied if the filter panel is disabled, which will prevent the user from changing the filter.
Auto-Adjust Column Widths
Will try to adjust the width of the column to show results as much as possible.
Store User Customization
Changes made to the grid are saved in the cookies on your browser between page refresh and window changes. This can include column reordering, resizing and applied filters.
When saving grid rows to a Data Source, you may want to override some values. For instance, if you want to update a column with the current date and time, or replace a column with a Parameter or Variable.
To do this follow these instructions:
On the Data Grid, enable the Allow Updating property and set the Edit Mode to Batch With External Save.
Then, under the Action accordion in the Block Properties of a Button or other Block, click the button with the gear icon of the corresponding Data Source to the Data Grid.
Press the + button to the right of Override Values, select the column to override, and press Add.
In the Value column of Override Values, choose a static or dynamic value.
Press Apply on the Update Data Source page, and Save the App Page.