Putting Number of items in the current view in the View Name

[djnguyen]

Hello All,

I am currently building a "ticketing" system on AppSheets and I have view pages that are filtered out depending on if one is "assigned". 

I want to mimic the number of notifications, similar to how my iPhone tells me I have 2 unread messages. I know I can customize this using the Display Name of the view but I am having trouble on pulling the number of rows that is displayed just on that view.

For example - my page "Requests Assigned to Me" is filtered out and there are 4 so I'd like the view text to say "4 Requests Assigned to Me" and so on and if my colleague has 6, i'd like to show 6.

Any help on an expression that counts the number of rows in the view? Almost like a Group Aggregate but in the view name. 

[Aurelien · Accepted solution]

Hi @djnguyen 

What about using in the display name of your view:

"My tickets - " 
&
COUNT(
  FILTER("TICKET",
    [assignedTo]=USEREMAIL()
  )
)