Derived fields in contact DB
In Excel I can have a Date of Birth field, say D2. Then I can have E2 which is the derived year from D2 and F2 which is the derived month from D2 and so on. I can also have H2 which is the year of the current date minus E2. - that is the contacts age in years.
Whenever D2 gets updated, the other fields update automatically.
Should also have the ability to refresh the DB to update fields like H2 on an as required basis as these would obviously be changing from time to time
Dmitry Buterin commented
Can you elaborate - what's the main underlying need for this and what are some scenarios for how this would be used/useful?