Configure grids for editing
You must configure the Grid widget to allow app users to add, edit, or delete grid data.

Grid columns are initially set to a read-only state. To edit the value of a field within a record, you must make the related column editable.
- In the Grid Properties dialog box, on the Columns tab, for each statement that specifies to include a column in the grid, select the Made Editable or Read-only button.
The appearance of the button changes to indicate that the column is now editable.
— read-only state
— editable state

- In the Grid Properties dialog box, on the Options tab, select the Allow Adding and Deleting of Rows check box.

- In the Grid Properties dialog box, on the Columns tab, for a column configured to display the date and time data type, select the edit column properties button.
- In the Column Properties dialog box, for Display Format, type the following:
dd-MM-yyyy (HH:mm:ss)
This is a case sensitive string. - Select the Include Time Value When Editing Dates check box.

- In the Grid Properties dialog box, on the Button Visibility tab, select or clear any of the following check boxes:
- Refresh
- Add Row
- Delete Selected Rows
- Delete Selected Rows
- Edit in Excel
- Bulk Update
- Save Changes
- Revert Changes
Some toolbar buttons are displayed only when the app user is capable of performing the related function. For example, the Save Changes and Revert Changes buttons are displayed only after a grid is edited.
Last modified: Friday May 12, 2023