SaltfishTry for free

How to Add a Last Modified Time Field in Airtable

·2 min read
In this article

This guide will show you how to add a 'Last modified time' field in Airtable, allowing you to automatically track when records are updated. This feature helps monitor changes and maintain an accurate history of your data.

Explore more Airtable tutorials with interactive Saltfish walkthroughs.

Here's how to add a last modified time field in Airtable

  1. Open your Airtable Base

    Navigate to the Airtable base and table where you want to add the 'Last modified time' field. Ensure you have the necessary permissions to modify the table structure.

  2. Add a New Field

    Click the '+' button located at the end of your table's column headers. This action will open a menu to configure a new field for your table.

  3. Select Field Type

    From the list of available field types, choose 'Last modified time'. This special field type automatically records the timestamp of the last modification.

  4. Name the Field

    Provide a descriptive name for your new field in the 'Field name' input box. A clear name like 'Last Updated' will make it easy to understand its purpose.

  5. Configure Tracking Scope

    Under the 'Fields' tab, decide if the field should track changes to 'All editable fields' within the record or only 'Specific fields' that you select. This controls what actions trigger an update.

  6. Adjust Formatting (Optional)

    Click the 'Formatting' tab to customize how the date and time will be displayed in your table, including date format, time format, and timezone options.

  7. Create the Field

    Once all settings are configured to your preference, click the 'Create field' button to add the 'Last modified time' field to your table. The new column will appear with timestamps.

Your turn to show how it works.

Build a walkthrough of your product with Saltfish, then share it with your customers.

Create a guide with Saltfish

Frequently Asked Questions

The 'Last modified time' field automatically records the date and time of the most recent edit made to a record. You can configure it to track changes to all fields or only specific ones.