The Last Updated Field is a read-only system field automatically included in every new table. It tracks when records were last updated, along with the name of the member who made the change and the time of the update.
Plan Availability | All plan types |
Permissions | Read-only system field, automatically included in all tables. |
Related Reading |
Key Features
Tracking: Displays the date, time, and member who last updated the record.
Dual Information: Shows "First Created" information for new records until the record is updated.
User Profiles: Provides a link to the member profile of the person who last updated or created the record, facilitating easy communication.
System Field: Cannot be duplicated, edited, or deleted.
Time Zone Adjustments
The date and time values are displayed according to the viewer's time zone.
Members can update their time zone in General Preferences under their profile.
Time zone defaults to the Workspace's time zone, configurable in Workspace Settings.
Customizing the Last Updated Field
Solution Managers can modify the display format of the Last Updated Field:
Display Options
Avatar: Shows the profile picture of the last updater.
Date: Displays the date of the last update.
Avatar and Date: Combines both for comprehensive visibility.
Date Format
Days Ago: Displays relative time (e.g., "2 days ago").
Exact Date: Displays the exact date and optionally the time of the update.
Note: To adjust default settings, add the field to Grid View and modify display options from there.
Record Updates and Activity History
The Last Updated Field integrates with a record’s Activity History, providing a log of changes.
First Created Field: Displays at the top of the history, while updates are logged below it.
Monitoring Specific Fields
If you need to track changes to specific fields rather than the entire record, use the Formula Field with the following functions:
1. LAST_MODIFIED_TIME
Purpose: Returns the date and time a specified field was last changed.
Syntax:
LAST_MODIFIED_TIME([Field])Example:
LAST_MODIFIED_TIME([Status], [Priority]) → Result: Oct 7 @ 5:00PM (if "Status" was last updated then)
2. LAST_MODIFIED_BY
Purpose: Returns the name of the member who last modified a specified field.
Syntax:
LAST_MODIFIED_BY([Field])Example:
LAST_MODIFIED_BY([Status], [Priority]) → Result: Brian Dollen (if "Status" was last updated by Brian)
Examples of Use
1. Project Management
Track when project tasks are updated and by whom.
Use the Last Updated Field to maintain accountability and ensure smooth workflows.
2. Customer Support
Monitor when customer records were last modified and who handled the update.
Use formulas to focus on specific fields like Status or Priority.