Fields

Fields in a table define the attributes of data and correspond to columns in a grid view.

Each field is named, such as "product_name," serving as an identifier. Additionally, fields are assigned specific data types, like text, numbers, or boolean values, dictating the kind of data they can store.

Adding Fields

To add new fields within the grid view, follow these steps:

1. Navigate to the grid view.

2. Scroll to the far right.

3. Click on the "+" sign at the very end of the field row.

   
4. In the pop-up dialog, edit the field settings.

5. Click "Save."

Editing Fields

Fields can be edited both during the creation process and whenever modifications are necessary. To edit an existing field, adhere to the steps below:

1. Right-click on the field you wish to edit.

   
2. Select the "Edit Field" option from the menu.

3. Make your edits in the dialog that appears.

4. Click "Save."

Considerations for Field Conversion

Editing a field can trigger a conversion to a new field type, like changing a single-line text field into a single-select field. However, some conversions may lead to data loss. For instance, converting a text field into an attachment field will erase all text data, as plain text cannot be transformed into attachments.

If you notice any cell values missing after a conversion, you can use the keyboard shortcut Ctrl+Z (or Command+Z for Mac) to undo the conversion and restore the field to its previous state, along with any data lost in the process.

For detailed information on each field type and its customization options, please refer to the documentation for individual field types.

Deleting Fields

1. Right-click on the field you want to delete.

   
2. Select the "Delete Field" option from the menu.

3. Confirm the deletion in the dialog box.

Hiding Fields

Fields can be hidden via the right-click context menu or the hide tool, making them invisible in the grid view. You can manage field visibility at any time using the hide tool. For more information on toolbar options in the grid view, visit the grid view article.