I'm working on a new project that requires users to fill out a lengthy survey to assess their skills. These skills will then be used to query for users with a front-end interface. My question has to do with how to store these ~120 skills and query them later.
Each skill with have a range of values such as:
Skill: Crosscut Saw Experience Possible values: 0) none 1) performed with supervision 2) performed independently 3) Have Supervised 4) Trainer
So, that first makes me thing of radio button fields. The issue is that there is about 120 of these skills that need to be recorded for each user with a front-end form. And, the must be the ability to quickly query user based on skill/skill level.
At first I considered a static Super Table, but I don't believe querying that is easy or efficient, based on other questions I've browsed.
Plan B is to create a Skills channel, creating ~120 skill records, related to each user. This would make querying simple a matter of finding records relatedTo a skill. But how to create all these records on the front end as the user is filling out a form?
I've not used any of the form plugins, such as Sprout Forms or Freeform. Anyone have any experience with these that might shed some light?
Any other suggestions on how to best go about this?
Thank you for any ideas or advice.