Hi,
I don't know if you're still taking suggestions for O365 Forms and / or if my suggestions are already in the backlog... but here it goes.
I would like to pre-program a drop down list with departmental names.
When a person completes a Form they will select their department.
Their response should then be saved to / appended to an Excel spreadsheet depending on the department they select.
For example:
A form gets sent to all staff / students across three different departments: X, Y & Z.
All responses from people who complete the Form in department X get saved to spreadsheet A.
All responses from people who complete the Form in department Y get saved to spreadsheet B.
All responses from people who complete the Form in department Z get saved to spreadsheet C.
I know, in this example, your suggestion may be to setup a separate Form for each department. However, having a feature that stores responses in different Excel files, dependent on a specific response to a question in a single Form would be useful for a multitude of scenarios.
In specific terms, it would allow us to capture data across the University on a single form, but share the responses of each Excel file with the specific department, without breaching data protection regulations as they would only be able to access data relating to their own department.
I hope this makes sense...?!
Thanks,
Jim
