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.
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.
This feature would support our desire to build list reports which utilize data stored within customer tables more effectively.
Ditto!
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.