I’m working on an app where users need to complete various tasks every week, and it has a gamification aspect, so I need to record EACH unique date that specific actions took place.
To give an analogous example, let’s say a user has to run a mile every week, and we need to know the cumulative dates that an action has been completed. Obviously you have a user database and action database (run a mile), but let’s say you want to record how many times a user has taken that action over time. How would you record the multiple dates? (e.g. User “ABC” has “Ran a Mile” on 1/2/2021, 1/9/2021, 1/16/2021, etc.)
Is there anyway to do that? If not, any ideas for a workaround?
If it can’t be done for specific dates, any ideas for figuring out the cumulative totals (e.g. the User has “Ran a Mile” 25 times, even though we might not know the specific dates)?
I’d greatly appreciate any help