Guide to Using Data Table Date Field Feature in AirSheet

Feature Summary

The Date field is one of the basic field types in a data table, used to record date information. It supports multiple date formats and default value settings, making it suitable for scenarios requiring time management, such as project deadlines, creation times, and task scheduling.

Feature Description

Operation Steps

Create a New Date Field

Feature Entry
「+」 button on the right side of the header → "Date" field

1. Click the "+" button on the right side of the header
2. Select the "Date" field from the pop-up field type list
3. Enter the field name and click "Confirm" to complete the creation

Set Date Format

Feature Entry
Right-click "Field Title" → "Field Settings" → "Date Format" area

1. Right-click the date field title and select "Field Settings"
2. In the "Date Format" area, the following options can be configured:

• Display Time: When checked, specific hour and minute information will be recorded synchronously, e.g. 2026/05/26 17:30

Set Default Value

Feature Entry
Right-click "Field Title" → "Field Settings" → "Default Value" option

1. Right-click the date field title and select "Field Settings"
2. In the "Default Value" option, you can choose:

• None: No date is preset; new Records are left blank
• Specific Date: New Records are automatically filled with a fixed date value
• Date of Adding This Record: New Records are automatically filled with the creation date of that day

Enter a Date

Feature Entry
"Target Cell" → Pop-up date picker → Select date

1. Click the target cell, and the system will pop up a date picker
2. Click the target date on the Calendar panel
3. If Show Time is enabled, you also need to set the specific hour and minute using the time slider or input box