Hi,
I would like to show my users some information based on their activity per month.
For example: This month you …X times.
The X will “restart” every 1 of month and last until last day of the month.
What is the right approach to it?
Thank you.
I assume you are already recording the activity. You need to make sure to record the date at the same time… then have a column called “month num” which you can use to calculate the month:
Now in your user table, create a new column called “related/activity” which will be a relationship between the user table and the activity table based on user id.
Finally, you can then create a column called “activity count” which is a rollup of the related/activity column - using “count”.
You can then use that count in a template column to output the text as you want to display to the user.
2 Likes
Thank you, I understood your idea but did not really understand the way.
Could you describe more?
- I have Users table.
- I have Records table.
I already have relation between then, based on user’s email.
A. I created in ‘1’ new Math column that calculates the current month.
B. I created a new column in ‘2’ that convert user’ full activity date only to month.
C. I created new relation in 1 that matches the information between ‘A’ to ‘B’.
That did not work.
How do I continue from here?
Thank you.
In what way did it not work?
1 Like