Timeline for How to store (and import) historical data (date, integer#1, integer #2, etc.)
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 6, 2020 at 17:31 | comment | added | Aidan♦ | 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 | |
| Aug 6, 2020 at 3:29 | comment | added | EricLB | 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. | |
| Aug 5, 2020 at 20:57 | comment | added | Demerit | 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. | |
| Aug 5, 2020 at 19:56 | comment | added | petednz - fuzion♦ | Have a look at the answer here civicrm.stackexchange.com/questions/3957/… | |
| Aug 5, 2020 at 17:38 | history | asked | EricLB | CC BY-SA 4.0 |