Skip to Main Content
Status Future consideration
Categories Application
Created by Guest
Created on Mar 18, 2020

Add a column in a custom table that is automatically updated with the last date and time the row was changed/updated, and another column to track the last user that updated

This would help us keep track of how and when entries in custom tables are updated, and to make sure this is happening with enough frequency. We use custom tables for many business critical functions.

  • Attach files
  • Taylor Wolf
    Reply
    |
    Sep 25, 2020

    This feature would support our desire to build list reports which utilize data stored within customer tables more effectively.

  • Geoffrey Kim
    Reply
    |
    May 14, 2020

    Ditto!

  • Anthony Lau
    Reply
    |
    May 14, 2020

    It would be extremely useful if each Custom Table Record had a date stamp when a record is create and another date stamp for when it was last updated. Technically the data is there in the History. But I need it in a view where I can filter and sort it. Looking to each record history will not work.

    I have three use-case for this capability.
    1. The created date stamp would help use identity newly create records. In some cases, people are not suppose to create records on their own. Since AHA does not have access control for this, we want to sort by newly create records to identify them.
    2. The last update date stamp will allow us know know how fresh or stale the data in the record is.
    3. The last created and updated date stamp will give me the ability to find and clean up old records that may no longer being used. Sometimes people create records but never attached them to a feature. So we would like to identify old items and clean up these records. I also be really help if you had a data or calculation column that would give the total features attached to the custom table record similar to what Feature Tags does. Currently, we create a pivot table and look for the empty cells.