How to count the number of rows returned by LINKTOFILTEREDVIEW ?

AppSheet AppSheet Q&A
1

My app has a single COMMON_VIEW and an action which, based on a SWITCH condition, triggers the LINKTOFILTEREDVIEW function for a specified column. All working beautifully. eg

LINKTOFILTEREDVIEW("COMMON_VIEW",(AND([Any] >0,
SWITCH([Navigation View],
"Overdue Training",(([Any]>0)>0),
"Getting Started",(OR([Essential] >0,[Safety]>0,[Safeguarding]>0),
"Wood Badge",([Wood Badge Overdue] >0),
[ANY]>0))))

I want to count the number of rows returned in the LINKTOFILTEREDVIEW response - so I can tailor the Description ie “Overdue classes (n)” when ‘n’ is the count of rows.

How do I get the number of filtered rows?

2

Please try below,

Please add a text VC called say [Overdue_Classes] with an app formula “Overdue classes” and show_If property of CONTEXT(“View”) =“Common_View”

In the group by property of the “Common_View” view, add the column [Overdue_Classes] and add count [Overdue_Classes] as the count or sum property option.

Not tested. Replying from mobile.