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:
- Convert InfoPath form to Word via SharePoint
- InfoPath SharePoint Search form
- Create InfoPath form through SharePoint Designer 2010 workflow
- Link InfoPath form to Excel in SharePoint 2010
- Calculate business days between two dates excluding holidays using Excel Services
- Connect SharePoint form library form to SharePoint list form through SharePoint web part connections
- Extract emails from people picker in InfoPath 2010
- Display Access 2010 data in an InfoPath 2010 browser form
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 of S.Y.M. Wong-A-Ton. 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, S.Y.M. Wong-A-Ton.