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
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
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |