Type in your suggestion - new feature or improvement idea

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

2 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    RobinRobin shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Dmitry ButerinDmitry Buterin commented  ·   ·  Flag as inappropriate

        Robin,

        Can you elaborate - what's the main underlying need for this and what are some scenarios for how this would be used/useful?

      Feedback and Knowledge Base

      Wild Apricot Inc. 144 Front Street West Suite 725, Toronto, Ontario, Canada M5J 2L7