Field Management

In Basemulti, fields are the basic components of tables, used to define the structure of data. This guide will introduce how to manage fields in tables.

Field Types

Basemulti supports the following field types:

Field Types

• Single Line Text：Used to store text information, created using the varchar type
• Multi Line Text：Used to store long text, created using the text type
• Number：Used to store numerical values, created using the int type
• Single Select：Selects one value from preset options, created using the varchar type
• Multi Select：Selects multiple values from preset options, created using the varchar type
• Date：Used to store dates, created using the date type
• Date and Time：Used to store dates and times, created using the datetime type
• Switch：Yes/No option, created using the tinyint type
• Image：Used to store images, created using the varchar type
• Association：Used to establish relationships between tables, not supported for creation
• Created At：Automatically records creation time, not supported for creation, using the datetime type
• Updated At：Automatically records update time, not supported for creation, using the datetime type
• Created By：Automatically records the creator, not supported for creation
• Updated By：Automatically records the last updater, not supported for creation

Adding Fields

Tip

External base currently does not support adding fields.

To add a new field, follow these steps:

1. Enter the table settings page
2. Click the "Create" button
3. Set the field name and display name
4. Select the field type and properties
5. Click the "Save" button to complete the addition

Tip

Field names are recommended to use lowercase English and separate words with underscores.

Editing Fields

You can modify the configuration of existing fields:

1. Click the field to be edited
2. Modify the field configuration
3. Click save to complete the modification

Note

Currently, modifying the field type only changes the display value of the field, not the physical field type in the base.

Field Sorting

Adjust the display order of fields:

1. Enter the table settings page
2. Drag and drop fields to sort
3. Click the "Save Order" button to complete the operation

Deleting Fields

Deleting fields is not currently supported.