Clay Icon

Tracking Date and Time When Values Are Added to a Column

·
·

Is there a way to create a see the date and time a value was added to a column, like the change date? I tried a new column that generated with AI the last modified date, but instead changed the last modified column date.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Yes, you can view when values were added to your table by using the Table History feature. To access this:1. Open your table 2. Click the ⟲ View Table History button located at the bottom right of your tableYou can also use filters to see records based on their creation date by:1. Clicking the filters button at the top of your table 2. Selecting "+ Add filter" 3. Choosing the "Created at" column 4. Setting the appropriate date comparison Sources: Customizing your table view | Documentation | Clay University View Table History

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!

  • Avatar of Owen C.
    Owen C.
    ·
    ·

    Hey Sebastian, thanks for reaching out! While there isn't a direct feature, there’s a workaround for this, try adding a formula column with something like: If {{column you'd like to monitor}} exists, return "moment().format('MM-DD-YYYY')". Keep this as a text column for now and give it a try! Out of curiosity, what’s your use case for knowing when the column was last updated? Is this for tracking in a CRM, or are you hoping to use this information for something specific? Let me know! :)

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.