MOSS Help

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

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