What is the best method for creating an online signup sheet? #M365AMA

In this episode, the #M365AMA panel discusses the following community question:

“How would I use Excel, Teams, or Forms (or a combination) to create online signup spreadsheets? I’d like to have an online document where students can type their first name, last name, and others column for details of whatever they are signing up for. They should be able to edit so they can add their info in one row, but not be able to delete what other students write. I also want them to be able to see what other students write, because I usually ask that they all choose a different topic/date for their presentations. I know I could set up a survey through Forms where they can tell me their info and then I can download a spreadsheet of answers, but then they can’t see what others have written. Thanks!”

Check out the discussion here:

 

Participating in this discussion were:

• Christian Buckley @buckleyplanet 
• Sharon Weaver @sharoneweaver
• Shari Oswald @shortcutshari
• Hal Hostetler @tvwizard
• Kirsty McGrath @kirstymcgrath13

Some relevant notes/links shared by the team:

• As we discuss in the video, there are several ways you can approach this depending on your requirements. You can create a Microsoft Form using a Power Automate flow to populate a SharePoint List with view only access. Or create a solution using Power Apps (our suggestion). Or you can share an Excel file with locked cells via OneDrive. You have options.