Teams have a variety of pit scout, match scout, and picklist generator systems. Some are custom proprietary or open source software (I think of the system 842 uses), some teams have generated Android or iOS apps that wither operate independently or feed into a database, and some teams work paper and pencil recording and manually input that into a database or operate just off of the paper. A great place to compare existing scouting systems and maybe try some of them out is the
Chief Delphi Scouting subforum, where teams will post their scouting methods and even put their software up for download for other teams. I know 422 plans on releasing or may have already released the "Poor Man's Scouting" tool, which is a paper record that can be transposed into an excel spreadsheet. Try mock scouting a webcast event this weekend with a tool that already exists and fine tune it to your needs afterwards, or try something totally different.