Filter records

[John_Krenkel]

I made an app to track attendance as well as equipment insurance for a football team I run.  I have the method to checkout equipment but it’sa little bulky in searching for the players as I have rosters from previous years and just update Season (year) and team

 i want to filter it by year = 2022 and sort by team.  So basically when I click on player it notes the player Id from the roster and what equipment that have.  

i have a helmet inventory sheet and we scan that barcode.  

so the record for checkout helmet would indicate 

player Id, helmet id. And date of checkout or check in

The issue is when I click player is it shows everyone and doesn’t limit

 any help will be appreciated

[Suvrutt_Gurjar]

You could make your requirement clearer. It sounds that you have possibly two requirements

1. Limiting records to current year and sorting them by team

2.  A Helmet inventory checkout check in table. You may want to elaborate your issue here.

For the first requirement please take a look at security filters, since you mention search is taking time and you have many years of data. For sorting by team you could use sort option in table view.

Security filters: The Essentials - AppSheet Help

Control row sort order - AppSheet Help