Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Count records since 7 days ago?

Topic Labels: Formulas
382 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Table “Companies” is a list of companies.
Table “Posts” lists blog posts, and has a Date field.

They are linked related between Companies’ “Posts” field and Posts’ “Company” field. ie. Posts relate to companies.

On the Companies table, I am able to successfully show a “Total Posts” count of the number of corresponding posts, by adding a Count field for the Posts table.

However, how can I add another column to Companies which only counts those Posts whose Date fields fall within the last seven days?

tl&dr - How do I count the number of linked records whose date falls within the last seven days?

1 Reply 1

In your Count field, turn on the option to “only include linked records that match certain conditions”, and specify your date field “within the last week”.