Hi, my users want to enter and visualise the following information in the CRM for each Account entry:
| 4 Jan 2023 | 1 Jul 2023 | 10 Dec 2023 | 7 Jan 2024 | 5 May 2024 |
CRL | 0 | 1 | 5 | 6 | 6 |
TERL | 7 | 8 | 9 | 9 | 9 |
BRL | 6 | 7 | 9 | 9 | 9 |
ML | 0 | 0 | 1 | 3 | 5 |
I have looked and found a way to do this using subforms (see the attached screenshot) but I'm not completely satisfied with the result. Reasons being a) the user has to enter the date in every row instead of doing it only once; b) when there are many rows, the user has to scroll a lot to get to see information that comes after this subform.
1. Is there another way to implement this functionality than using subforms?
2. I want to show the information as a radar/web chart, or a line chart, preferably in the same view when one is viewing an Account entry. How can I do this?