How to create a Sign off or Registration form in SharePoint?
Greetings,
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Reread my post. It addresses the question you posed. Or read about sharepoint lists on google. Good luck.
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...
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...
ASKER
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
ASKER
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.
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.
Thanks, glad you have it working!
Glad you got it working - thanks for the accepted solution - Walter always has good ideas well.
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.
ASKER
Thanks alot guys.
Do you guys happen to know how to approach this:
https://www.experts-exchange.com/questions/29084027/How-do-I-change-the-name-from-NEW-to-New-Travel-Request.html
Do you guys happen to know how to approach this:
https://www.experts-exchange.com/questions/29084027/How-do-I-change-the-name-from-NEW-to-New-Travel-Request.html
ASKER
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.