Custom Grid Columns View
Custom Grid Columns allow you to define the columns for your Custom Grid [more info] that you want to see along with their order and behaviour. As for the standard grid functionality [more info] the LemonEdge platform will take care of all that.
Custom Column Features
The columns placed in your Custom Grid are automatically displayed appropriately by LemonEdge, along with providing the correct editing control. You simply need only specify the property of the entity you want as a column and LemonEdge will take care of the controls required to display and edit it. This includes controls that allow selections of other entities through relationships. You can also provide formatting options for date/time and number fields for quick control over the display.
Custom Grid Column Properties
Every column has the following properties:
| Name | Description |
|---|---|
| [Key] Sequence |
The sequence specifies which order this column should appear in the grid. This field is hidden in the grid, but you can show it using our standard grid commands. You can easily change it using the Move Up/Down commands too. |
| Prop Name | The name of the property you want to appear as a column in the grid. The system provides a drop down list of all properties against the Entity Type of this Custom Grid. |
| Is Visible | Indicates if this column should initially be visible to the user. If not the user can still make it visible through our standard grid commands and can see the data when exporting the grid to excel. |
| Is Editable | Indicates if the user has permission that they can edit the data in this column. If they don't have permissions they will be unable to edit this field regardless if it is true or not. |
| Format | Apply any custom formatting to the data. [more info] |
| User Friendly Label | The column name will by default be the property name or the user friendly version of it. You can override that by putting a custom column header name here. |
| Tooltip | By default the tooltip will be the description (if any) of this property against the entity in the design. You can override that by putting a custom tooltip here. |
Commands
Note
A custom grid column has the standard set of commands and functions when being viewed from a grid. See our standard grid functionality.
Tip
As a Custom Grid Column has a sequence the standard grid allows you to move the items up and down changing their order.