Branching Forms

%3CLINGO-SUB%20id%3D%22lingo-sub-908644%22%20slang%3D%22en-US%22%3EBranching%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-908644%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20tasked%20to%20create%20a%20form%20for%20Fire%20Truck%20checks%20that%20branches%20depending%20on%20what%20unit%20they%20are%20on.%20I%20have%20gotten%20the%20form%20all%20branched%20out%20and%20a%20rough%20draft%20done%20with%20questions...85%20total...%20however%20I%20was%20wondering%20is%20there%20a%20way%20to%20set%20where%20each%20unit%20has%20its%20own%20sheet%20in%20excel%3F%20for%20example%2C%20If%20driver%20bob%20is%20on%20ladder%204%20he%20opens%20the%20form%20and%20inputs%20the%20basic%20information%2C%20(Name%2C%20Date%2C%20unit%20number)%20what%20I%20would%20like%20is%20that%20after%20he%20selects%20the%20unit%20number%20the%20form%20would%20then%20take%20his%20information%20to%20its%20separate%20sheet.%20This%20will%20help%20with%20data%20logging%20and%20the%20organization%20of%20the%20data%20that%20is%20created%20by%20filling%20this%20daily%20form%20out%20for%2018%20fire%20apparatus%20total%20daily.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-908644%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBranching%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Elarge%20format%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eseveral%20paths%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-910441%22%20slang%3D%22en-US%22%3ERe%3A%20Branching%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-910441%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F424472%22%20target%3D%22_blank%22%3E%40JKeyfayettevillear%3C%2FA%3E%26nbsp%3Bthis%20can't%20be%20done%20just%20with%20Forms%20on%20its%20own%2C%20but%20what%20you've%20described%20is%20definitely%20possible%20by%20combining%20Forms%20with%20Flow.%20When%20the%20form%20is%20submitted%20you%20would%20have%20a%20switch%20control%20which%20is%20a%20type%20of%20condition%20that%20just%20looks%20at%20the%20unit%20the%20fireman%20has%20selected%20or%20entered.%20Depending%20on%20the%20unit%20a%20new%20row%20is%20added%20to%20a%20table%20in%20a%20sheet%20in%20an%20excel%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20my%20very%20simple%20example%20below%20has%20Fireman%20Sam%20on%2012%20October%20in%20Unit%203.%20The%20flow%20gets%20the%20form%20details%20which%20are%20then%20added%20to%20a%20table%20called%20Unit%203%20in%20the%20Unit%203%20sheet%20in%20the%20FireUnits%20spreadsheet%20on%20my%20One%20Drive.%20If%20it's%20Fireman%20Bob%20in%20Unit%204%20then%20you'd%20have%20the%20Add%20a%20row%20action%20in%20the%20Unit%204%20switch%20case%20which%20would%20add%20the%20details%20to%20the%20Unit%204%20sheet%20in%20the%20spreadsheet%20and%20so%20on.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3EMicrosoft%20Flow%20Community%20Super%20User%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20915px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F137281i2747DED2AB386965%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%220-Form.png%22%20title%3D%220-Form.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F137279i22068FA269BDA35A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%221-Flow.png%22%20title%3D%221-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F137280iECFB4F5087EADA57%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222-Spreadsheet.png%22%20title%3D%222-Spreadsheet.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello everyone,

 

I have been tasked to create a form for Fire Truck checks that branches depending on what unit they are on. I have gotten the form all branched out and a rough draft done with questions...85 total... however I was wondering is there a way to set where each unit has its own sheet in excel? for example, If driver bob is on ladder 4 he opens the form and inputs the basic information, (Name, Date, unit number) what I would like is that after he selects the unit number the form would then take his information to its separate sheet. This will help with data logging and the organization of the data that is created by filling this daily form out for 18 fire apparatus total daily.

1 Reply
Highlighted

Hi @JKeyfayettevillear this can't be done just with Forms on its own, but what you've described is definitely possible by combining Forms with Flow. When the form is submitted you would have a switch control which is a type of condition that just looks at the unit the fireman has selected or entered. Depending on the unit a new row is added to a table in a sheet in an excel spreadsheet.

 

So my very simple example below has Fireman Sam on 12 October in Unit 3. The flow gets the form details which are then added to a table called Unit 3 in the Unit 3 sheet in the FireUnits spreadsheet on my One Drive. If it's Fireman Bob in Unit 4 then you'd have the Add a row action in the Unit 4 switch case which would add the details to the Unit 4 sheet in the spreadsheet and so on.

 

Rob
Los Gallardos
Microsoft Flow Community Super User

 

0-Form.png1-Flow.png2-Spreadsheet.png