I have a project where the users want to move their credential collecting information from spreadsheets/email to webforms on our Drupal site.
They input a list of up to 20 employees, select checkboxes for the 17 areas the employees may have access to, then submit the webform. Employees may have access to multiple floors, so it's a checkbox not radio-button.
The manager then downloads the results into an Excel spreadsheet.
My problem is, using the Webform module my form is getting HUGE. I have fields like this:
name1 (text field)
department1 (text field)
Am I using the webforms module wrong, or is there another module that would help with this? The form is going to be very long and tedious to look at compared to the old method they used, having a spreadsheet with 20 lines down, then columns for name, department, and the 17 credentials (a 20x19 grid, basically).
I'd prefer to keep using the Webform module for this rather than develop a form using the Drupal form API if possible, since Webform is much easier.
Any pointing in the right direction would help.