Add event to SharePoint calendar through InfoPath 2010

In this InfoPath demo video you will see an InfoPath form used to add an event to a SharePoint calendar and that has the ability to check for overlapping events before adding the item to the SharePoint 2010 calendar.

In recipe 83 you will learn how to create an InfoPath form that can add an event to a SharePoint calendar and check whether there are any other events already booked in the time slot you selected.

Get more solutions from InfoPath 2010 Cookbook 2 which is available on CreateSpace (An Amazon company)
Watch next video: Connect SharePoint form library form to SharePoint list form through SharePoint web part connections

InfoPath demo video transcript:

Here I'm in SharePoint 2010 on a site with a calendar that currently contains two events. As you can see, there is a team lunch on August 22nd from noon to 2 p.m. and there is a two-day event that is taking place on the 24th and the 25th of August from 8 a.m. on the 24th to 3 p.m. on the 25th. I'm going to be using an InfoPath form to create and add an event to this calendar.

I've already published the InfoPath form template to a SharePoint form library, so if I click on Add document to add a new form and start filling out the details for my event, let's say I want to add an event that falls on the same day as the team lunch and starts within the time slot of the team lunch, which went on from noon to 2.p.m., when I click on Check Overlapping Events, you will see this warning appear: "One or more events already exist for the timeslot you selected." And when I change my start time to be the end time of the team lunch, you will see that the warning disappears.

There was a second event, a two-day event, starting on the 24th at 8 a.m. and it ended on the 25th at 3 p.m. So if I change my end date to be within the time slot of the two-day event, you'll see that when I click this button, the warning will appear again. And even if I change my end date to be after, the warning will stay there.

So let's say I want to change this to be the 24th at 8 a.m., which is the time the two-day event would start. You'll see that the warning disappears, and I can go ahead and add my event.

A workflow will run and as you can see it has already completed. So if I refresh the calendar, I should see my event here, starting at 2 p.m. on the 22nd, ending at 8 a.m. on the 24th.


Related InfoPath Demo Videos:


Copyright: This article may not be used on web sites (whether personal or otherwise), copied, disseminated, altered, printed, published, broadcasted, or reproduced in any way without an expressed written consent. The techniques demonstrated in this article may be used within any Microsoft InfoPath project. This article is provided without any warranties. Copyright for this article is non-transferrable and remains with the author.

InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010