Re: Creating an intranet signup sheet for use with SharePoint

Clay Fox — Wed, 19 Dec 2007 14:27:09 GMT

Hey Josh.

The ulitimate signup solution.

I would recommend SQL server with Web Services from the Database Accelerator.Qdabra Database Accelerator Suite Version 2.1 - Developer

You have one form which an admin uses to setup the event and specify the items needed and the amounts.

They email everyone a notification with the link to the signup form.

Then your sign up form uses an active directory web service to identify the form user.

They see the "menu" and the remaining numbers needed for each component.

They select items and amounts and/or add themselves to the volunteer roster.

When they submit they recieve an email receipt and the data from the form is submitted to the database so the next form user can see only the amounts remaining.

SQL reports can be ran on the SQL data showing the percentage complete or the distribution of participation or to create an email list for those participating.

Fulfillment could also be tracked if neccessary.

Those are some of my ideas.

Creating an intranet signup sheet for use with SharePoint

joshk — Mon, 17 Dec 2007 21:16:42 GMT

Hello everyone!

I'm tasked with creating and supporting a new signup method for different things within my agency. We often have meals to support charities or raise money to help a fellow employee going through a difficult time. For these meals, we used to pass around a paper signup sheet with blanks under categories for people to write their name in. What I suggested was we try to use InfoPath to replace this time intensive and annoying process with an easy to use InfoPath form.

I created and published a form for our Thanksgiving meal last month, and for the most part it was well received. However, being new to SharePoint and InfoPath I'm certain that the process can be improved upon. So I was hoping that someone out there had done something similar or would at least join in my brainstorming on how to do this best.

If you'd like to know the ridiculous lengths we went to for the Thanksgiving meal let me know, but for the sake of keeping this post as short as possible I decided to omit that for the time being. Thanks for your help. I look forward to looking at this more closely with anyone who is interested.

Thanks,
Josh

General

Re: Creating an intranet signup sheet for use with SharePoint

Creating an intranet signup sheet for use with SharePoint