Share via

How do I create an event registration system with Office 365?

Anonymous
2023-12-11T07:57:03+00:00

I am looking to create a registration for a conference of about 400 people. There are about 15 sessions or so the attendees can go to. Each room has an attendance cap (for fire code reasons). Is there a way (using Office) to create a way for those folks to register all at the same time? I was planning on using a Microsoft form and having attendees list their preferences (but I think that would take me too long to sort all that data to make a finalized attendee list for each session). I don't believe forms have a way to "hide" an option when a capacity has been reached (EX: Session A becomes unavailable on the form after 30 people have registered for it). Does anyone have any ideas on how I could make this work? The ideal goal would be for me to export everything to Excel so I can see their name, email, and the three sessions they're signed up for. Appreciate any help!

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-12-11T08:55:00+00:00

    You may use data validation to limit the max number of each session.

    When a session is reach to the max number (30), it will be removed from Dropdown.

    You may check my test file in private message.

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-12-13T11:04:31+00:00

    Hi,

    Session A becomes unavailable on the form after 30 people have registered for it).

    this topic is interesting.

    Customerize an online form.

    let's suppose 3 people named : Alice,Peter and Jack

    3 sessions and restrict: Session A only 2 people Session B only 1 people Session C 2 people

    create table:questionnaire

    question correct_answer option1 option2 option3 option4 option5 Name Session A Session A{2} Session B{1} Session C{2}

    online form https://e.anyoupin.cn/EData/1129.html result https://e.anyoupin.cn/EData/1128.html

    https://www.bilibili.com/video/BV1FC4y1c7aa/?buvid=XX85E838539534AD650323D79CEE8DA100517&from_spmid=default-value&is_story_h5=false&mid=FSMZLyVVbtrPTKay0/c9Fg==&p=1&plat_id=116&share_from=ugc&share_medium=android&share_plat=android&share_session_id=02a81911-1169-4f5a-823b-c74e66b6b180&share_source=COPY&share_tag=s_i&spmid=main.ugc-video-detail.0.0&timestamp=1702465098&unique_k=5V9rFQP&up_id=634143044

    0 comments
  3. Anonymous
    2023-12-12T06:26:23+00:00

    No worries. Thanks!

    0 comments
  4. Anonymous
    2023-12-12T06:01:16+00:00

    I have no idea on restricting selection on Forms.

    0 comments
  5. Anonymous
    2023-12-12T05:27:21+00:00

    That's awesome! Thank you! One more question--there isn't a way to tie this to a form, correct? In other words, as sessions filled up, they'd disappear off the form so other people couldn't select it.

    0 comments