1

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?

Improve this question
4
  • Have a look at the answer here civicrm.stackexchange.com/questions/3957/…
    – petednz - fuzion ♦
    Commented Aug 5, 2020 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
    Commented Aug 5, 2020 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.
    – EricLB
    Commented Aug 6, 2020 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 ♦
    Commented Aug 6, 2020 at 17:31

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.