Originally Posted by axipher
Maybe add a field for "Switch Type" and "Main Usage". Then if you'd like I can help out with generating a couple graphs and charts:
- Pie chart showing switch type
- Pie chart showing usage
- Some graphs relating switch type to usage
The only problem with that is that "usage" isn't already part of the form, so I would have to ask every user on there to complete a new form.
Also if I was to try and use the current data in the spreadsheet to create a "switch type" field, then every single entry would have to be done manually. Also users with more than a single mechanical keyboard would have to have extra entries made under their name, one for each board and switch type so a graph could be created.
I like this idea a lot but I'm trying to think of an effective way of doing it without asking everyone to fill out another form or editing cells manually.
Any ideas on how we could streamline this idea?