Formula for value for badge

1

Hi…

I hope this isn’t so obvious that I should have figured it out for myself.

If I have a view of a table and a button that filters by today’s date, let’s say, and the filter produces 12 rows of data today…what would the formula be to make the button badge show 12?

Thanks!

Gregg

2

Hello @Gregg_Stebben!
Don’t worry it happens even to the best of us!
To do that you would need the next formula:

[Your table view filtered by today].count()

Edit: Reading your question again makes me think you want to know the values before applying the filter?
In this case your formula would look like this:

[Your Table].Filter([Date column]=today()).Count()

2 Likes
3

Thank you! I think this might be exactly the tweak I was looking for!

1 Like