Conditional Survey by Department

%3CLINGO-SUB%20id%3D%22lingo-sub-1517404%22%20slang%3D%22en-US%22%3EConditional%20Survey%20by%20Department%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1517404%22%20slang%3D%22en-US%22%3EHey%20there!%3CBR%20%2F%3E%3CBR%20%2F%3EI've%20been%20trying%20to%20figure%20this%20out%20for%20a%20while%2C%20so%20any%20help%20would%20be%20appreciated.%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20trying%20to%20create%20a%20survey%20using%20Microsoft%20Forms%2C%20in%20which%20I%20am%20limiting%20answers%20to%20my%20organization%2C%20once%20per%20user%2C%20and%20collecting%20the%20names%20of%20said%20users.%3CBR%20%2F%3E%3CBR%20%2F%3EThing%20is%2C%20I'd%20like%20to%20either%20forward%20to%20a%20secondary%20form%20or%20to%20a%20specific%20question%20within%20said%20form%20depending%20on%20which%20department%20the%20user%20is%20a%20part%20of.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20naming%20scheme%20that%20we%20use%20at%20our%20organization%20implies%20both%20the%20department%20and%20the%20employee%20number%20on%20the%20username%20of%20each%20user%2C%20so%20I%20could%20either%20parse%20through%20the%20logged%20in%20username%20to%20define%20branching%20(where%20the%20first%20two%20letters%20are%20the%20department%20ID%20and%20the%20following%20six%20numbers%20are%20the%20employee%20number%2C%20followed%20by%20the%20domain%20name)%2C%20or%20parse%20the%20identifying%20elements%20of%20the%20account%20based%20on%20any%20element%20of%20an%20Excel%20Workbook%20containing%20the%20company%20directory%20to%20redirect%20them%20to%20their%20corresponding%20section.%3CBR%20%2F%3E%3CBR%20%2F%3EThing%20is%2C%20I'm%20not%20quite%20sure%20where%20or%20how%20can%20I%20define%20said%20restrictions%2C%20given%20the%20ideal%20result%20would%20be%20as%20following%3A%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20user0%20from%20department_x%20opens%20form0%2C%20redirect%20to%20form_department_x%3CBR%20%2F%3EElse%20if%20user0%20from%20department_y%20opens%20form0%2C%20redirect%20to%20form_department_y%20(...)%3CBR%20%2F%3EThen%20export%20form0_results%20to%20Workbook_0%20and%20append%20user0.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20this%20possible%20using%20forms%20by%20itself%2C%20or%20perhaps%20by%20doing%20scripting%3F%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1517404%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EEducation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESurvey%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor
Hey there!

I've been trying to figure this out for a while, so any help would be appreciated.

I'm trying to create a survey using Microsoft Forms, in which I am limiting answers to my organization, once per user, and collecting the names of said users.

Thing is, I'd like to either forward to a secondary form or to a specific question within said form depending on which department the user is a part of.

The naming scheme that we use at our organization implies both the department and the employee number on the username of each user, so I could either parse through the logged in username to define branching (where the first two letters are the department ID and the following six numbers are the employee number, followed by the domain name), or parse the identifying elements of the account based on any element of an Excel Workbook containing the company directory to redirect them to their corresponding section.

Thing is, I'm not quite sure where or how can I define said restrictions, given the ideal result would be as following:

If user0 from department_x opens form0, redirect to form_department_x
Else if user0 from department_y opens form0, redirect to form_department_y (...)
Then export form0_results to Workbook_0 and append user0.

Is this possible using forms by itself, or perhaps by doing scripting?
0 Replies