This how-to guide includes 3 topics: adding the field, checking the auto-filled timestamp, and sorting or filtering records by creation time; all 3 are available without membership.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Add a Creation Time Field | Free |
| 2 | 2. Check the Auto-Filled Creation Time | Free |
| 3 | 3. Sort or Filter Records by Creation Time | Free |
How-to Guide
1. Add a Creation Time Field
Entry: Tap the header area → Edit → Field Type → Creation Time
- Open the database where you want to add a new field.
- Tap the header area for the field section.
- In the floating toolbar, tap Edit.
- In the field settings window, tap Field Type.
- Select Creation Time.
- Enter a field name and confirm the setting.
Success Criteria
- Interface result: a new Creation Time Field column appears in the database.
- What you can do next: new records can now receive timestamps automatically.
Tips While Using
- Creation Time Field is a system time field for record creation tracking.
- You can rename the field, but the field type should remain Creation Time.
2. Check the Auto-Filled Creation Time
Entry: Create a new record in a database that already contains the field
- Open a database that already includes a Creation Time Field.
- Add a new record.
- Finish entering the record content and return to the table view.
- Find the value in the Creation Time Field for that record.
- Confirm that the system has filled in the current creation time automatically.
Success Criteria
- Interface result: the new record shows a date and time value in the Creation Time Field.
- What you can do next: you can continue reviewing timestamps for other records.
Tips While Using
- The displayed format is
yyyy/MM/dd HH:mm.- After creation, the value cannot be edited manually.
3. Sort or Filter Records by Creation Time
Entry: Use sorting or filtering in the database view
- Open a database that contains a Creation Time Field.
- Choose the Creation Time Field as the sorting basis.
- Set ascending or descending order as needed.
- If needed, add a time-range filter to show only matching records.
Success Criteria
- Interface result: records are reordered by creation time, or only matching records remain visible.
- What you can do next: you can review timeline changes or locate target records more quickly.
Tips While Using
- Before sorting or filtering, confirm that records already have auto-generated creation times.
- This field works well together with other business fields for record organization.