I’m a middle school assistant principal. I have a Student table with around 450 students listed in it. When I am in meetings with teachers, I often need to find a student record in the table rapidly. Often, the teachers (who work much more closely with their students than I do) bring up the student by first name (“Joey’s really been struggling this week…”) and I have to race to find Joey’s record in the table so that I can take notes, reference data, etc.
Scrolling through the table takes too much time. I have tried using an interactive filter on the name field, but it lists all 450 names in the menu and doesn’t make it easy to find “Joey”. Is there a faster way to accomplish what I am trying to do?