Forum Discussion
Best way to create a Sign-Up sheet
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.
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.
- Hi,
Brilliant and simple solution. However, the ways to set up a permission group or levels requires a lot of knowledge to set up properly?
I figured out how to find list permissions based on your screenshot. However, there are groups such as:
Site Owners
Site Members
Site Visitors
Site Members and Visitors has the generic SharePoint permissions. So, if I'm correct in my thinkings, I need to remove the groups (Site Members and Site Visitors) and create a new group for "Sign up Visitors", then add list permissions to that group? It's not simple as I thought it would be because of my lack of knowledge of permissions levels or groups. I'm little confused.
