Is it possible to have the data from the form uploaded to a 2nd (separate) spreadsheet based on the answer to a single question?
For instance, I am building an order sheet for items that will be shipped from different branches. The user will select the branch city they are in. The data from that order form should then be uploaded to the spreadsheet for that branch ONLY. So the person at that branch only recieves the orders designated for them.
Currently we cannot upload responses to different spreadsheets based on answers to a single question at the time of submission, but a person can filter the responses to view the ones that he's interested in. In View Responses tab, he can click on "Filter" button and then choose a column and value to filter the data. Here is a screenshot of the filter dialog:
If it doesn't meet your needs, please vote or submit an idea at http://forums.adobe.com/community/formscentral?view=idea. We use that to priority our feature list.