01-11-2019 07:01 AM
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.
01-11-2019 07:09 AM - edited 01-11-2019 07:10 AM
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.
01-11-2019 07:14 AM
@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.
01-11-2019 08:30 AM
01-11-2019 10:59 AM
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.
01-14-2019 06:27 AM
The simplest out of the box answer that I've used for years is this -
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.
01-14-2019 07:15 AM
Thank you for this thoughtful reply. Could you expand on or screenshot the privileges you give to achieve this?
01-14-2019 07:51 AM
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.