Using Teams to create a booking form (then extract to excel)

%3CLINGO-SUB%20id%3D%22lingo-sub-1847564%22%20slang%3D%22en-US%22%3EUsing%20Teams%20to%20create%20a%20booking%20form%20(then%20extract%20to%20excel)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1847564%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20question%20for%20me.%20I%20am%20hoping%20to%20use%20teams%20for%20external%20parties%20to%20follow%20a%20link%20and%20complete%20a%20booking%20form%20for%20a%20session.%20I%20want%20multiple%20sessions%20in%20the%20one%20link%20(so%20the%20user%20selects%20the%20time%20they%20want%20to%20book%20for)%20and%20then%20select%20how%20many%20people%20are%20coming%20(tickets)%20and%20then%20complete%20the%20following%20for%20each%20attendee%3A%20full%20name%2C%20address%2C%20email%2C%20telephone).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20want%20to%20only%20have%20so%20many%20seats%20available%20so%20when%20a%20form%20is%20successfully%20submitted%20the%20session%20total%20will%20cumulate%20until%20it%20is%20full%2C%20so%20there%20can%20be%20no%20overbooking.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20preference%20is%20not%20to%20use%20Trybooking%20or%20Eventbrite%20booking%20tools%20as%20I%20want%20to%20keep%20it%20in%20house%20and%20then%20once%20the%20bookings%20are%20full%20extract%20to%20a%20csv%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20a%20bit%20of%20a%20noob%20but%20willing%20to%20try%20and%20have%20a%20go%2C%20but%20am%20unsure%20(a)%20if%20teams%20has%20an%20addon%20that%20will%20accomodate)%2C%20and%20(b)%20if%20anyone%20has%20ever%20done%20something%20similar%20that%20I%20could%20try.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3CP%3EBenjamin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1847564%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1869408%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Teams%20to%20create%20a%20booking%20form%20(then%20extract%20to%20excel)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1869408%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%2F855445%22%20target%3D%22_blank%22%3E%40ipswichcatholic%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20initially%20thinking%20Microsoft%20Forms%20would%20take%20you%20most%20of%20the%20way%20but%20it%20can%20be%20quite%20limited%20and%20you%20may%20fall%20short%20with%20the%20getting%20full%20requirement%20but%20it%20certainly%20has%20a%20CSV%20that%20can%20be%20generated%20and%20exported.%20And%20as%20you%20would%20imagine%20this%20can%20be%20surfaced%20within%20Teams.%3CBR%20%2F%3E%3CBR%20%2F%3ETo%20get%20a%20bit%20more%20custom%2C%20you%20may%20want%20to%20look%20at%20Power%20Apps%2C%20as%20that%20will%20give%20you%20the%20most%20flexibility.%3CBR%20%2F%3E%3CBR%20%2F%3EMight%20also%20be%20worth%20looking%20at%20the%20Microsoft%20Booking%20App%2C%20if%20it%20is%20still%20going%20that%20is.%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20to%20summarise%2C%20I%20would%20be%20looking%20to%20Forms%2C%20Power%20Apps%20or%20Bookings%20(Not%20sure%20this%20is%20still%20valid)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHenry%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi everyone!

 

First question for me. I am hoping to use teams for external parties to follow a link and complete a booking form for a session. I want multiple sessions in the one link (so the user selects the time they want to book for) and then select how many people are coming (tickets) and then complete the following for each attendee: full name, address, email, telephone).

 

I also want to only have so many seats available so when a form is successfully submitted the session total will cumulate until it is full, so there can be no overbooking.

 

My preference is not to use Trybooking or Eventbrite booking tools as I want to keep it in house and then once the bookings are full extract to a csv file.

 

I am a bit of a noob but willing to try and have a go, but am unsure (a) if teams has an addon that will accomodate), and (b) if anyone has ever done something similar that I could try.

 

Thanks in advance!

Benjamin

1 Reply
Highlighted

Hi @ipswichcatholic ,

 

I am initially thinking Microsoft Forms would take you most of the way but it can be quite limited and you may fall short with the getting full requirement but it certainly has a CSV that can be generated and exported. And as you would imagine this can be surfaced within Teams.

To get a bit more custom, you may want to look at Power Apps, as that will give you the most flexibility.

Might also be worth looking at the Microsoft Booking App, if it is still going that is.

So to summarise, I would be looking to Forms, Power Apps or Bookings (Not sure this is still valid)

 

Thanks

 

Henry