DateAdded and DateChanged for Smartfield tables

Mitchell Gibbs

Hi community!


We're struggling with improving the performance of our Data Warehouse ETL and one of the biggest culprits are Smartfields. We don't have a lot of them, but they tend to expand quickly when you've got a lot of donors. The key missing piece is having Date Added and Date Changed fields on the Smartfield tables, unlike almost all other tables in CRM. If we could know when a Smartfield had been changed, we could include or exclude it from loading to the data warehouse. It would save hours.


If someone has a great solution, please share. Otherwise, please cast your votes for the idea in the IdeaBank: https://bbcrm.ideas.aha.io/ideas/CRM-I-3082


Thanks!


Mitch

Chris Geady

I don't have any magical answer to this, but agree and added my vote.