Two part question - Microsoft Forms

Question

I created a form with four sections and branching as a way to record and capture event feedback. The results are unfortunately quite unwieldly because essentially they are four forms within one. It's not easy to filter by date or location because of the section breaks. I have since made changes to the workbook, deleted responses out and changed the wording in the questions on the live form. Although I synced the Form to the workbook, firstly, it created an 'Other' category which looks blank on the live form but the results do show on the Excel Workbook. The second part of this is that the workbook has then duplicated and triplicated some of the options because of how many times it has been synced or, modified. If I replicate the form exactly with the same four sections I understand this would reset the form to what it should look like. If I add branching to a new form using the same questions I think this would give me the option to filter by date and location as I need. What I can't figure out, however, is if the first part of the questions follow a numerical model 1- 10 for example but the next lot of questions I want to refer back to Q2 for it then to follow on automatically onto the next question from there. So 11 would filter to 2 but then Q3 needs to be answered after that. I am concerned this might further duplicate my answers if I am referring back to previous questions. Is there a way around this please? How do I make this form easy to read for staff inputting information in and easy to search on the workbook end?

Answer 1

Hi George,

Thanks for your reply.

Please see the first part re the Other category. There is not an option for Other when referring to the type of activity but by deleting out and changing the questions, this Other category has been created. The data pulls through on the worksheet which is fine just unsightly on the front end:

The screenshot below then shows the duplicate and triplicate answers that I mentioned shown in the worksheet:

I've previously been advised to delete this and start the form again which is what I am currently doing.

That is correct re the numbers referring back, however, a member of staff will only fill in one type of activity each time they submit information i.e. a one off event and then follow the corresponding question for that option. They would not fill in data for a one off event and a regular activity at the same time. Essentially, I need one form to pull all the responses together which makes it easy for staff to enter in but, redirects them around the form to only the questions they need (hence the branching and sections but this has made the data difficult to pull and read). In my example, if they have already answered question 2 for their specific activity type, I don't want to redirect them to a question later in the form which is the same as what already exists.

I would be happy to screen share via Teams if this would be easier to explain.

Thanks.

Answer 2

Hi KJ-NCL,

Thanks for posting in the community. We are happy to help you.

Per your description, for "the 'Other' category", could you please share a full screenshot including the whole interface? You can click "Insert Image" to upload it.

For the second question, my understanding is that there are 10 questions in the first part (section), when the user needs to answer other questions, like Q11, Q12, etc., Q11's option will redirect the user to Q2.

If my understanding conflicts with your meaning, please point it out and provide more details.

If so, I suggest you copy Q2 and put the copied question under Q11. In this case, the user won't go to the original Q2.

We look forward to your response. Thanks for your cooperation.

Sincerely,

George | Microsoft Community Moderator