MOSS Help

How to Add the Meeting Workspace Button in the Outlook 2010 Ribbon to Create a Meeting Workspace

In the module on Meeting Workspaces in our Introduction to SharePoint 2010 – Using SharePoint Foundation 2010 class, we teach students that there are three ways to create a new Meeting Workspace: From any site, just like you would create any other site (Site Actions > New Site or View All Site Content > Create). From any Event on a SharePoint Calendar (check the box beside “Use a Mee... »

How to Add and Subtract Hours and Minutes from Date and Time Fields in SharePoint Lists

I recently needed to write a SharePoint Designer workflow to send a reminder email 12-hours before the end of a multiple-day event. It’s easy to use the Pause Until Date activity to pause until the necessary time, but it’s not so obvious how to calculate the date and time ithe workflow needs to pause until. The easiest way to calculate the Pause Until date and time was to create it as a calcul... »

SharePoint-InfoPath 2007 Video Tutorial: Displaying SQL Data in Data View Web Parts (Part 2)

How-to video: Create an InfoPath form that stores form data in SQL Part 1: Create a web-enabled InfoPath form that stores form data directly in SQL Part 2: Create data view web parts in SharePoint Designer to display/update SQL data in SharePoint pages Part 3: Filter SQL data with a form web part and create SharePoint list items from SQL data This SharePoint video tutorial is based on a simple con... »

SharePoint-InfoPath 2007 Video Tutorial: Storing InfoPath form data in SQL (Part 1)

How-to video: Create an InfoPath form that stores form data in SQL Part 1: Create a web-enabled InfoPath form that stores form data directly in SQL Part 2: Create data view web parts in SharePoint Designer to display/update SQL data in SharePoint pages Part 3: Filter SQL data with a form web part and create SharePoint list items from SQL data This SharePoint video tutorial is based on a simple con... »

Create a Detailed Custom Task Notification with a SharePoint Designer Workflow

Update June 6, 2012: If you would like to know how to do this in SharePoint 2010, click here for a video tutorial. It seems that few SharePoint users are happy with the out-of-the box task notifications. While they serve their purpose, we often want highly customized emails that contain more information about the task. I recently created a workflow that used the Collect Data from a User activity. ... »

Using Google Search Appliance on Your SharePoint Site

Adding a Google search to a web page is pretty simple. Just drop in the search form code. Something like this: <form id=”search-form” method=”get” action=http://search.yoursitehere.com/search>         <input type=”text” name=”q” size=”25″ maxlength=”255″ value=”"/>  ... »

Use Multiple Selection Columns in Calculated Fields

I recently had a need to create a hyperlink in a custom list and the hyperlink needed to contain parameters that came from a Choice type column that allowed multiple selections. I’m very comfortable using Excel’s string functions (LEFT, RIGHT, MID, LEN, and FIND) to parse strings and I’ve done so many times. However, when I tried to write a formula using the Multiple Selection field, I got a... »

InfoPath Form with Multiple, Dynamic Approvers

A question came in to the MOSS Help and How To forum about creating a form that allowed multiple approvers to be specified at the time the form is being filled out. I went ahead and created a form in InfoPath and a simple workflow in SharePoint Designer to allow the selection of the approvers and assign tasks for the approvers. It is a simple form and workflow both. For production you would want a... »

Hiding SharePoint List Action Menu Items

A question came up about how to go about hiding list action menu items on SharePoint lists. There were some actions that either didn’t make sense for their extranet users or they didn’t want to support. For example they would like to hide the “Edit in Datasheet” and “Alert Me” buttons. A number of people have posted different types of solutions. Some requiring development, some recomme... »

Use SharePoint Lists to Create a Filtered Drop Down in InfoPath 2007

While teaching our online class on InfoPath and SharePoint Designer Workflows (Essentials of InfoPath and SharePoint Workflows), I was asked about using SharePoint list data to populate InfoPath drop-down list controls and filtering a list control based on the selection of another drop-down. Goal: To create an InfoPath form that includes two drop down lists populated from an external source (Share... »