Home

Best way to create a Sign-Up sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-313706%22%20slang%3D%22en-US%22%3EBest%20way%20to%20create%20a%20Sign-Up%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313706%22%20slang%3D%22en-US%22%3E%3CP%3ENeed%20to%20create%20a%20sign-up%20sheet%20limited%20to%2030%20users.%20First%20come%20first%20serve.%20No%20waitlist.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWondering%20how%20others%20have%20accomplished%20this%20in%20the%20past%2C%20and%20if%20there%20is%20a%20better%20way%20in%20Modern.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-313706%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314633%22%20slang%3D%22en-US%22%3ERe%3A%20Best%20way%20to%20create%20a%20Sign-Up%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314633%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EYou%20may%20need%20to%20create%20a%20new%20permission%20access%20level%20if%20it%20doesn't%20already%20exist.%20I%20made%20a%20copy%20of%20the%20%22Contribute%22%20level%20and%20then%20unchecked%20the%20boxes%20that%20allow%20users%20to%20add%20new%20items%20or%20delete%20items.%20%3C%2FSPAN%3E%3CSPAN%3ENow%20you%20have%20to%20name%20it.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3ENOTE%3C%2FSTRONG%3E%3CSPAN%3E%20-%20There%20is%20already%20%22Edit%22%20level%20that%20is%20actually%20higher%20than%20Contribute%3C%2FSPAN%3E%3CSPAN%3E.%20It's%20used%20as%20the%20default%20level%20for%20members%20and%20allows%20them%20to%20edit%20columns%20in%20lists%20and%20libraries.%20So%20you'll%20need%20to%20name%20this%20one%20something%20different%20and%20more%20obvious%20like%20%22Only%20Edit%20List%20Items%22.%20Mine%20looks%20something%20like%20this.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThis%20method%20works%20online%20or%20on-prem%2C%20desktop%20or%20mobile%20with%20no%20customizations%20to%20the%20default%20form.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F65986i9C6EFDB64D367659%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Edit%20Items%20Only.png%22%20title%3D%22Edit%20Items%20Only.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314605%22%20slang%3D%22en-US%22%3ERe%3A%20Best%20way%20to%20create%20a%20Sign-Up%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314605%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F57004%22%20target%3D%22_blank%22%3E%40Rachel%20Davis%3C%2FA%3E%3C%2FP%3E%3CP%3EThank%20you%20for%20this%20thoughtful%20reply.%20Could%20you%20expand%20on%20or%20screenshot%20the%20privileges%20you%20give%20to%20achieve%20this%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314570%22%20slang%3D%22en-US%22%3ERe%3A%20Best%20way%20to%20create%20a%20Sign-Up%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314570%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20simplest%20out%20of%20the%20box%20answer%20that%20I've%20used%20for%20years%20is%20this%20-%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3ECreate%20a%20list%20with%20all%20your%20fields.%20I%20use%20something%20like%20%22Preferred%20name%22%20for%20the%20Title%20field%20and%20a%20people%20field%20to%20capture%20the%20corporate%20name%20and%20contact%20info.%20If%20you're%20working%20with%20external%20people%2C%20skip%20the%20people%20field%20and%20add%20an%20email%20field.%26nbsp%3B%3C%2FLI%3E%3CLI%3ECreate%2030%20new%20items.%20I%20fill%20in%20the%26nbsp%3BTitle%20field%20with%20something%20like%20%22Your%20preferred%20name%20here%22.%3C%2FLI%3E%3CLI%3EPut%20it%20on%20a%20page%20displaying%20the%2030%20line%20items.%3C%2FLI%3E%3CLI%3EGive%20the%26nbsp%3Bpeople%20%22edit-no%20contribute-no%20delete%22%20privileges.%20This%20will%20allow%20them%20to%20edit%20existing%20items%2C%20but%20not%20add%20new%20items%20or%20delete%20anything.%3C%2FLI%3E%3CLI%3ESend%20out%20the%20link.%3C%2FLI%3E%3C%2FUL%3E%3CP%3EWhen%20the%2030%20line%20items%20are%20full%2C%20you're%20done.%20No%20code%2C%20no%20Flow%2C%20no%20PowerApps%20so%20it%20has%20a%20consistent%20UI%20on%20every%20platform%20and%20works%20on%20any%20version%20of%20SP.%20Even%20better%2C%20you%20can%20use%20this%20same%20list%20over%20and%20over%20by%20filtering%20the%20next%2030%20items.%20Eventually%20you%20have%20a%20full%20database%20of%20people%20who%20have%20attended%20all%20your%20functions.%3C%2FP%3E%3CHR%20%2F%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-313861%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Best%20way%20to%20create%20a%20Sign-Up%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313861%22%20slang%3D%22en-US%22%3E%3CP%3EChris%2C%20I%20would%20be%20interested%20in%20creating%20a%20powerapp%20that%20would%20be%20redeployable%20for%20different%20use%20cases%20in%20the%20future.%20Maybe%20even%20publish%20it%20to%20the%20gallery%20if%20it%20works%20decently.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-313782%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Best%20way%20to%20create%20a%20Sign-Up%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313782%22%20slang%3D%22en-US%22%3EDepends%20on%20audience.%20PowerApps%20could%20do%20this%20fairly%20easy%2C%20but%20of%20course%2C%20I%20can%20say%20it's%20easy%20because%20I%20know%20powerApps%20pretty%20well.%20But%20If%20you%20wanted%20to%20learn%20it%20a%20bit%20you%20could%20use%20it.%20But%20again%2C%20depends%20on%20audience%2C%20if%20it's%20public%20people%20outside%20the%20org%20signing%20up%20that%20eliminates%20it%20as%20an%20option.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-313713%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Best%20way%20to%20create%20a%20Sign-Up%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313713%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F19689%22%20target%3D%22_blank%22%3E%40Kelly%20E%3C%2FA%3E%26nbsp%3BThank%20you%20so%20much%20for%20this.%20My%20GoogleFu%20failed%20me%20this%20morning!%20I%20remember%20doing%20this%20in%20sharepoint%20last%20year%20on%20older%20sites%20with%20Jquery%20and%20content%20editor%20webparts.%20It%20was%20terrible.%20I'm%20going%20to%20implement%20this%20now%20and%20test%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-313707%22%20slang%3D%22en-US%22%3ERE%3A%20Best%20way%20to%20create%20a%20Sign-Up%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313707%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Robert%20-%20this%20is%20such%20a%20simple%2C%20and%20common%20request%20and%20I%20don't%20know%20of%20any%20out%20of%20the%20box%20tool%20that%20will%20do%20this%20in%20O365.%20Did%20you%20see%20this%20conversation%3F%20Midway%20down%20is%20a%20Flow%20that%20you%20can%20add%20to%20a%20Form%20to%20limit%20responses%3A%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-Forms%2FLimit-number-of-responses-on-a-form%2Ftd-p%2F78704%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-Forms%2FLimit-number-of-responses-on-a-form%2Ftd-p%2F78704%3C%2FA%3E.%20Will%20be%20very%20curious%20to%20see%20if%20others%20jump%20on%20this%20thread%20with%20better%20ideas.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Robert Woods
Super Contributor

Need to create a sign-up sheet limited to 30 users. First come first serve. No waitlist. 

 

Wondering how others have accomplished this in the past, and if there is a better way in Modern.

7 Replies
Highlighted

Hi Robert - this is such a simple, and common request and I don't know of any out of the box tool that will do this in O365. Did you see this conversation? Midway down is a Flow that you can add to a Form to limit responses: https://techcommunity.microsoft.com/t5/Microsoft-Forms/Limit-number-of-responses-on-a-form/td-p/7870.... Will be very curious to see if others jump on this thread with better ideas.

@Kelly E Thank you so much for this. My GoogleFu failed me this morning! I remember doing this in sharepoint last year on older sites with Jquery and content editor webparts. It was terrible. I'm going to implement this now and test it.

Depends on audience. PowerApps could do this fairly easy, but of course, I can say it's easy because I know powerApps pretty well. But If you wanted to learn it a bit you could use it. But again, depends on audience, if it's public people outside the org signing up that eliminates it as an option.

Chris, I would be interested in creating a powerapp that would be redeployable for different use cases in the future. Maybe even publish it to the gallery if it works decently. 

The simplest out of the box answer that I've used for years is this - 

  • Create a list with all your fields. I use something like "Preferred name" for the Title field and a people field to capture the corporate name and contact info. If you're working with external people, skip the people field and add an email field. 
  • Create 30 new items. I fill in the Title field with something like "Your preferred name here".
  • Put it on a page displaying the 30 line items.
  • Give the people "edit-no contribute-no delete" privileges. This will allow them to edit existing items, but not add new items or delete anything.
  • Send out the link.

When the 30 line items are full, you're done. No code, no Flow, no PowerApps so it has a consistent UI on every platform and works on any version of SP. Even better, you can use this same list over and over by filtering the next 30 items. Eventually you have a full database of people who have attended all your functions.


 

@Rachel Davis

Thank you for this thoughtful reply. Could you expand on or screenshot the privileges you give to achieve this? 

You may need to create a new permission access level if it doesn't already exist. I made a copy of the "Contribute" level and then unchecked the boxes that allow users to add new items or delete items. Now you have to name it. 

NOTE - There is already "Edit" level that is actually higher than Contribute. It's used as the default level for members and allows them to edit columns in lists and libraries. So you'll need to name this one something different and more obvious like "Only Edit List Items". Mine looks something like this.

 

This method works online or on-prem, desktop or mobile with no customizations to the default form.

Edit Items Only.png

Related Conversations