I want to store data (date, integer #1, integer #2, integer #3) for an organizational contact in CiviCRM. Each month a new record record with the same format will be created for each contact, but with new data.

What is the best way to do that in CiviCRM?

I also want to import that data (historical data from past dates). Can that be done?

  • Have a look at the answer here civicrm.stackexchange.com/questions/3957/…
    – petednz - fuzion
    Aug 5 '20 at 19:56
  • That might work but I'd probably do it with activities and "regular" custom fields on the activity instead of multicustom, but to answer "best" properly depends on what the daily tasks are that use these fields and what reporting you need.
    – Demerit
    Aug 5 '20 at 20:57
  • Each month a new record would be added (date of data, integer #1, integer #2, integer #3). The data would be used record and then also to report on the changes (increase or decrease) of the data (integer # 1, integer # 2, integer # 3, etc.) from month to month. I was thinking of making a report for that, possibly exporting data to a csv for use elsewhere and so that I could create annual totals or averages of the data.
    – ErlcTB
    Aug 6 '20 at 3:29
  • So then custom fields on activities looks a good option as @demerit says. There are lots of reports for activities both standard ones and those provided by extensions
    – Aidan
    Aug 6 '20 at 17:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.