# Showing information based on 1 month, each month . How to?

**URL:** <https://community.glideapps.com/t/showing-information-based-on-1-month-each-month-how-to/68006>\
**Category:** Ask for Help\
**Created:** [November 21, 2023, 7:12pm UTC](https://community.glideapps.com/t/showing-information-based-on-1-month-each-month-how-to/68006 "2023-11-21T19:12:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ohad](https://avatars.discourse-cdn.com/v4/letter/o/f04885/32.png) [@ohad](https://community.glideapps.com/u/ohad)\
**Post date:** [November 21, 2023, 7:12pm UTC](https://community.glideapps.com/t/showing-information-based-on-1-month-each-month-how-to/68006/1 "2023-11-21T19:12:33Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![AdamMartin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adammartin/32/66650_2.png) [@AdamMartin](https://community.glideapps.com/u/AdamMartin)\
**Post date:** [November 21, 2023, 7:23pm UTC](https://community.glideapps.com/t/showing-information-based-on-1-month-each-month-how-to/68006/2 "2023-11-21T19:23:02Z")

</div>

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:

 ![Screen Shot 2023-11-22 at 8.17.38 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/c/8cdfd5999af3c61d30607e98f57fefaa748c68cf.png)

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.

---

<div class="post-metadata">

**Author:** ![ohad](https://avatars.discourse-cdn.com/v4/letter/o/f04885/32.png) [@ohad](https://community.glideapps.com/u/ohad)\
**Post date:** [November 22, 2023, 6:56am UTC](https://community.glideapps.com/t/showing-information-based-on-1-month-each-month-how-to/68006/3 "2023-11-22T06:56:44Z")

</div>

Thank you, I understood your idea but did not really understand the way.

Could you describe more?

1. I have Users table.
2. 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.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [November 22, 2023, 12:35pm UTC](https://community.glideapps.com/t/showing-information-based-on-1-month-each-month-how-to/68006/4 "2023-11-22T12:35:56Z")

</div>

> [@ohad](#):
>
> That did not work.

In what way did it not work?