Creating a form to publish info on WSS

J

Jeff Koviack

Hello,

I have been working with Windows Sharepoint Services on a Windows Server
2003 machine. The use of sharepoint in an intranet environment has turned
out to be fantastic and well received. We use a sharepoint front end
webserver with all content being kept on a backend SQL2000 database.

People have started to request features beyond what comes out of the box.
The one request is as follows:

We have an intranet: http://intranet with each department having a subsite:
http://intranet/<dept>. There are two departments that have committees who
have almost taken over the the department site creating an issue within the
deparment, so a subsite for their committe was created:
http://intranet/<dept>/<committee>

On each of the sites intranet | dept | committe there is a team events
calendar. The committees are requesting that certain events (not all
events) be published on the department calendar--and there has been a couple
of departments that wanted events published on the main intranet calendar.

My thought is to use infopath to create an event form with selection boxes
to choose which calendars to publish the event(s) to.

Could that be accomplished in infopath?

Second, there is one particular department where EVERY user in the
department is inputing their ENTIRE calendars (personal events and all) onto
the team calendar--which is working out really well for them. However, they
would like to have each person's events to be published under a different
color on the calendar.

Again, could infopath be used to create an event form that would give the
option of what color to publish the event on the calendar?

I am an extremely novice user of anything related to SQL data. I have never
used infopath and have no idea how to get started.

Any assistance would be hugely appreciated.

/Jeff
 
L

Lee Rosenberg [MSFT]

Jeff,

I can tell you that everything you describe sounds possible with InfoPath.
By developing an InfoPath Template with Full Trust privilege that resides on
a SharePoint site and connects to a SQL backend, you'll be able to write
scripts that can save data to specific locations and perform operations on
the XML contained in the form. There are many on this newsgroup who've
written similar scripts that can likely provide some assistance for someone
getting started.

Thanks,
Lee
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top