# Field Group

Field group is a group of fields. Field group can be generated from excel, database, and manually.

Excel and database are same as data structure.

## **Manual**

To create a field group manually, fields must be generated before field group.

 

1\)     Click Add Field button.

2\)     Double click a field.

3\)     Selected field is displayed in the field list.

!\[Graphical user interface, application

Description automatically generated]\(<https://support.xnarum.com/download/manuals/ISM-Manual-2023.fld/image107.png)&#x20>;

Each field in the field list can be edited or moved.

&#x20;

<figure><img src="https://support.xnarum.com/download/manuals/ISM-Manual-2023.fld/image108.png" alt="" width="188"><figcaption></figcaption></figure>

1. Choose a field from field list
2. Delete a field
3. Move up a field
4. Move down a field.

Each field can be edited in field group menu. Click the field id, then field editor popup is displayed.

![](https://support.xnarum.com/download/manuals/ISM-Manual-2023.fld/image109.png)

The fields in a field group have these properties.

<table><thead><tr><th width="198">Property</th><th>Description</th></tr></thead><tbody><tr><td>Nullable</td><td><p>This property is used to set null data to columns for database operation.</p><p>If nullable, null value is set. Otherwise, an exception is thrown.</p></td></tr><tr><td>Key</td><td>If this property is yes, this field is used as one of key columns for update/delete/select operations.</td></tr><tr><td>SQL Function</td><td>If this property is yes, the value of this field treated as an SQL function.</td></tr></tbody></table>