I'm using drupal 7.12 and webform 3.15 currently. I have two webforms I've created for a medical site. One form asks patient specific questions and the other asks physician related information. The forms as they are work fine, however, a request we had recently was that the group who accesses this data wants to have it all placed in one excel file, not two, and I'm unsure if this is possible for webform to do. The previous site had a custom php form to email to that output it's responses to the same db then generated a single file from that. Personally, seeing their previous results I don't like the method at all, as it creates a table that has a lot of columns with empty cells in them, but it's what they want.
Ideally what we would do is have one webform with both the physician and patient questions and then have a page that displays only the patient related fields and then another page that displays only the physician related fields. Is that possible with webform or should I go back to using their old php form to email?
Comments
I have never used it, but
I have never used it, but maybe http://drupal.org/project/webform_report can be used to display data of both webforms on one page.
What I ask myself is: Do you really need webform to collect the data? With two content types instead of two webforms you would be more flexible. It would be easy to ceate a view that shows the results of both forms and to create an Excel file from it.
You can split the webform
You can split the webform into multisteps, by using pagebreak as an option. Webform is ideal for this as you don't want to create nodes for each, and anyway you can access the data from a webform with views or data module if you want to do something more fancy.
I'm not sure if reordering
Thanks, I'm not sure if reordering the questions and including a pagebreak would work in this case. For example I want the fields from http://50.56.214.182/webform/patient-request-information and the fields from this http://50.56.214.182/webform/physician-request-information to both sync to one excel file.
But I think your idea of making a view that pulls both data types and then exporting that to excel could work, of course I've never created a view that output to excel so I'll have to look into how I go about that.
If it's only Excel export
If it's only Excel export what you need, http://drupal.org/project/views_export_xls should help.
I like http://drupal.org/project/views_bonus to export views into files. But it has no D7 version (yet).
Webform Conditional can be
Webform Conditional can be used to reveal or hide fields based on the value of a previous field. So if you can use a dropdown to select patient or physician, then once the selection is made the proper fields will be revealed.
http://drupal.org/project/webform_conditional
That is awesome! Thank you!
That is awesome! Thank you!