May 25, 2021 12:56 PM
There are two linked tables:
Companies already has a Count field column to display the total Posts by given Company.
However, I’d like also to count the posts by Company within the last seven days.
One view of Posts is filtered to show records with dates within the last week.
But how do I utilise this or similar on the Companies table?
Thanks.
Solved! Go to Solution.
May 25, 2021 01:17 PM
Hi @Robert_Andrews - you can use the “conditional” setting on the count field:
When you toggle this on you can set the conditions much like a filter on a view (but you’re not using an existing view here directly - just replicating its conditions within this count field)
May 25, 2021 01:17 PM
Hi @Robert_Andrews - you can use the “conditional” setting on the count field:
When you toggle this on you can set the conditions much like a filter on a view (but you’re not using an existing view here directly - just replicating its conditions within this count field)
May 25, 2021 01:19 PM
Ahh… perfect, @JonathanBowen. Diolch/thanks!