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)
cred1_floor1 (checkbox)
cred1_floor2 (checkbox)
cred1_floor3 (checkbox)
...
cred1_floor17

name2
department2
cred2_floor1
cred2_floor2
cred2_floor3
...
name20
department20
cred20_floor1
cred20_floor2
cred20_floor3

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.

Thanks,
Mike

Comments

One employee per submission

Instead of duplicating the all of the info, why not just have one name, dept and floor info? Then just have the users enter a submission for each employee.