The Last Modified Time field automatically records when a record was last edited. It can track all fields or only selected fields, which makes it useful for recent updates, inactive data cleanup, and collaboration review.Documentation Index
Fetch the complete documentation index at: https://help.teable.ai/llms.txt
Use this file to discover all available pages before exploring further.
Use Cases
| Scenario | Good for |
|---|---|
| Recent updates | Sort by Last Modified Time to see records that changed recently |
| Selected field tracking | Update the time only when key fields change, reducing noise from unrelated edits |
| Inactive data cleanup | Filter records that have not been updated for a long time |
| Collaboration review | Use with Last Modified By to see the latest edit time and editor |
Create and Configure
Choose the field type
Click the
+ icon on the right side of the table header, then choose Last Modified Time from the field type list.Tracking Options
| Option | Description |
|---|---|
| Track all fields | Updates Last Modified Time when any field in the record changes |
| Track selected fields | Updates Last Modified Time only when selected fields change |
Display Format
| Setting | Description |
|---|---|
| Date format | Choose how dates are displayed, such as 2024-01-30 or Jan 30, 2024 |
| Time format | Controls whether a specific time is shown, and whether it uses 12-hour or 24-hour time |
| Time zone | Uses a fixed time zone or follows the viewer’s system time zone |
Common Uses
- Find recently updated tasks: Sort by Last Modified Time descending so changed records appear at the top.
- Track key content changes: Choose Track selected fields, then select key fields such as “Title” and “Status”.
- Clean up inactive data: Set a filter such as
Last Modified Timeis before90 days agoto find records that have not been maintained.
Notes
- Last Modified Time is read-only and cannot be edited by hand.
- If selected field tracking is enabled, changes to fields that are not selected do not update the time.
- If you need to record when a record was first created, use Created Time.