Creating a web service for an InfoPath form in 25 easy steps

It took me a while to figure out how to do the InfoPath/webservice thing starting with an InfoPath form. Maybe this is blindingly obvious to everyone but me, but here it is anyway: 1) Create an InfoPath form from a new, blank form:   2) Lay out your form, using sections, grouping, and naming controls…

9

Stupid SQL Tricks

Argh. Classic Schroedinbug. I had an outer join between two tables to populate an InfoPath multi-select listbox. (So I needed a list of potential options with indications of which options had been selected). I created an outer join and put my parameter in the WHERE clause, like this: SELECT dbo.NeedRequestType.NeedRequestID,    dbo.NeedType.NeedTypeID,    dbo.NeedType.NeedType,    dbo.NeedCategory.NeedCategory FROM dbo.NeedCategory…

6

A "drill through" web part

This MSDN article shows how to implement a SharePoint web part that can act as a consumer or a provider. However, if you try to use it as a “drill through” web part (another web part filters the results in this web part; clicking on this web part filters or populates another web part), it won’t…

1

Emailing a different InfoPath form

I recently needed to create an InfoPath form that enabled the user to post the data to another user in a format they could open in *their* InfoPath form. After some thought, I went with the idea of running an XSL transform on the data and posting it via an email connector. Of course, first…

2