When configuring the Editable Grid, you can choose a column to be a field from its based table.
Copy and Delete: Note in the upper right corner are icons to copy and delete the column.Name in database: The field name in the table.
Column type: You can set the column to Read only if you don't want users to edit this column. Linked fields will automatically be set to Read only.
Header title: the text shown in the header row of the grid.
Show title: Toggle the visibility of the title in the header row.
Width : Set the width automatically or set it with a fixed pixel size. You can further customize the width to be Small, Medium, or Large, relative to other columns in the grid.
Alignment: How the value is aligned within the cell of the grid.
Default value: The default value for the field when edited and saved.
Validation rules: Specify validation for the field column. For more information, see the article "Field Validation".
Column events: Add actions to the Change event for the field column. A change event occurs when the user makes any change to the data in the grid.
There are different options depending on the type of field for the column, which will be noted below.
For example, numeric fields will have an option to show a column total, date fields will show formatting for the date, and dropdown fields will show different options relating to their linked fields, among other things.
Date/Time Column
There is only one extra parameter for Date/Time fields, and that's Format As, where you can set its date format.
Decimal, Integer, and Money Columns
Numerical columns will have the following extra parameters:
Formatting:
Number - Display the field as a regular number
Money - Show the monetary symbol based on the Currency Code Source dropdown.
Rounding (Decimal and Money only): Number of digits to round to.
Show column total: Beneath the column, show a sum of the values for the current page.
Dropdown Column
The value of a dropdown field is usually not the value needed to be displayed, especially if it contains a Record ID. The Display Value option will allow the user to set an alternate value like a linked field.
Yes/No Column
By default, a checkbox is shown in a Yes/No field. Alternatively, the column can be set to show Yes or No values.