How to create a Sign off or Registration form in SharePoint?


I have just 3 fields, firstname, lastname, emailAddress that I have been given to create a registration form with in SharePoint.

Normally, this can be done in PHP, ASP.NET, or even classic ASP very easily but users want it done in SharePoint so members can use it to sign up for something.

Does anyone know the easiest way to do this in SharePoint?

Our SharePoint also has Office 365.

Not sure how to go about it. I am pretty sure it is a trivial task if you know your way around SharePoint.

Thanks in advance.
LVL 29
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Keyboard CowboyCommented:
Just set a simple list with a small workflow to send the registrant a confirm email. You can set the list security so that they do not see other registrations.  Do you have further question or requirements?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sammySeltzerAuthor Commented:
Well, you actually did not answer my question.

I need to set up a registration form or sign up form where users can sign up by simply providing their first name, last name, email address.

The email bit may be necessary but I am more concerned about where in sharepoint do I need to set this up?

One other important point that I forgot to mention initially (sorry about this oversight) is that management would like to be able to export the contents of the information users entered into an excel spreadsheet.

Thanks for your help.
Keyboard CowboyCommented:
Reread my post. It addresses the question you posed. Or read about sharepoint lists on google. Good luck.
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Walter CurtisSharePoint AEDCommented:
Step a few steps and think about this. You state:

I have just 3 fields, firstname, lastname, emailAddress that I have been given to create a registration form with in SharePoint.

Keep in mind, unless you have anonymous access enabled on your SharePoint site, for every one on the site you have that information because SharePoint works with names users based on some type of directory such as active directory. You also mention Office 365 which implies SharePoint online, again implies no anonymous access. So the users are known.

So the question is, what are your trying to do exactly?

If you want users to go to some page within SharePoint and have them add their name to a list, (a type of registration), them just do what Keyboard Cowboy suggest, his advice is perfect. If you are trying to do something else, provide some more info so you can be helped in that direction.

Good luck...
sammySeltzerAuthor Commented:
Ok, thanks for that.

Yes, you are correct that sharepoint gets names from Active Directory as is the case with what I am trying to do here.

We have an event that users (employees) can sign up for.

All that is required is for the user to enter his/her firstname, last name and email address and then click submit.

All of this information is then exported into an excel spreadsheet.

I mentioned office 365 because I read that you could use excel survey to do this but not sure how using excel survey gives me the flexibility to add custom columns like the firstname, lastname email and also have the ability to export the data to excel.

I have looked into SharePoint list and I am trying to figure out how this is exported to excel.
Walter CurtisSharePoint AEDCommented:
Thanks for the  clarification, it is useful.

In that case, just do as Keyboard Says and create a simple list, maybe using the template "Custom List" and add the fields you need. You could rename the default column to last name maybe. Workflow is optional.

As far as an export to excel, in the ribbon if you are access the list with Excel installed you will see an icon that says "Export to Excel."

Hope that helps...
sammySeltzerAuthor Commented:
Ok, thanks a lot for clearing up some things.

If I should use the list as you guys have suggested, then there is just one sticking point that I have to resolve in other to sell this to management.

When you create the list using say Custom List for instance.

In my case, I renamte the default column called Title to First Name, then add Last Name and Email.

Now I am set. There is an option as you correctly stated that allows the owners to export the contents of this list to excel.

So, two questions and I hope I can get good answers on this because that will really help me sell this.

1, There is a feature called +New at same level as the Export to Excel feature.

Can this be renamed to something like New User or something?

Can this be renamed, period?

2, can the Export to Excel be hidden so that only management can see it and use it to export the information contained on the list?

Thanks again for your help.
sammySeltzerAuthor Commented:
Thanks guys.

I was able to create an app like you guys suggested using custom list.

I have a question regarding that but I will post that seperately.
Walter CurtisSharePoint AEDCommented:
Thanks, glad you have it working!
Keyboard CowboyCommented:
Glad you got it working - thanks for the accepted solution - Walter always has good ideas well.
Keyboard CowboyCommented:
Oh, you can CSS out the export to excel I believe - however, it would hide it for everyone.  You could use JavaScript to conditionally hide it but it would be a bit messy and require programming.  Maybe someone else has an idea.
sammySeltzerAuthor Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.