Skip to Main Content
Status Already exists
Categories Reports
Created by Guest
Created on Jul 20, 2021

Include system captured date in reports

I would like to be able to include a "last updated" field in reports based on a system captured date. For example, in a report viewing all active initiatives, I’d like to pull the date the Summary field (for example) was last updated. This would allow you to easily identify when data is becoming stale. I know the data exists in the history, but that requires reviewing the history for every active item separately which is time consuming.

  • Attach files
  • Guest
    Reply
    |
    Aug 10, 2021

    Hi Austin,

    The available capability does not meet the need. The ask is to be able to report on when specific fields were last updated.

    The context behind this is to be able to tell if an Initiative status (I am using a custom field for Executive Summary) has been recently updated. Unfortunately, because any change updates the last updated field - even those from integrations - it creates a lot of false negatives. Work around is to have users add a date in a custom field but that requires user admin and is error prone.

    Thanks!

    Lori

  • Admin
    Austin Merritt
    Reply
    |
    Jul 28, 2021

    Hi Lori, yes any update to the initiative should trigger the field to update. This would include updates from integrations as well.

  • Guest
    Reply
    |
    Jul 27, 2021

    What causes that date to be updated? Is it a change to any field in the Initiative layout you are using, including custom fields? And would an update from an integration trigger it?

  • Admin
    Austin Merritt
    Reply
    |
    Jul 23, 2021

    Hi there, thank you for your idea. Many records in Aha! include a "last active" field that is reportable. This will update based on any changes made to the record...so not just the description like you noted. Would this be useful for your use case?