SharePoint Designer 2007

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... »

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=>         <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... »

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... »