I ran across a post over at the MSDN SharePoint – Design and Customization forum which intrigued me enough to want to figure it out. The question was about showing subtotals for a given column’s values, with the results sorted by the subtotal, descending. In other words, for a list with these items: Title Amount…
Christian Ståhl left me a good question in another post: Have you tried to ‘formfill’ a SharePoint column for date and time with ‘today’s date’, that would be cool if its possibly? Of course it’s possible! You can pre-fill any columns value based on rules which you decide. There are probably a few common situations:…
In parts one and two on this topic, I gave an overview of SharePoint form validation and gave an example of how you can implement some validation with JavaScript. In this post, I’ll show how you can use more standard .NET validation with a custom form. (Be sure to check out Part 4 as well,…
I had some questions today from a respected colleague about when to use separate Site Collections, and I sorta liked my response, so I’m going to foist it off on you, too. The gist of the questions was this: They are fighting the battle of site collections here (IT wants several) which of course will…
In my previous post I outlined a few approaches to validation in SharePoint forms. In this post, I’ll give some simple examples of how you might validate some date inputs. For this example, I’m using a little Paid Time Off (PTO) application I built for one of my clients. The basic idea was that the employees…
There are many occasions where you might like to do some validation on NewForm.aspx and/or EditForm.aspx in SharePoint beyond the simple column by column validation which the form provides automagically. For instance, if you have two dates, you might want to ensure that the second is after the first, or you may want the entry…
In an earlier post, I wrote about Eliminating Duplicates in Data View Web Parts. I just got a question on that post about how to create the dropdown in the first place, and it seemed post-worthy. Generally, you’ll want to create a separate DVWP containing a dropdown and use it to trigger the display of…
I’ve been spending quite a bit of time over on the SharePoint – Design and Customization forum at MSDN trying to provide answers to some of the questions there. Based on many of the questions that I’ve seen, my favorite Data View Web Part (DVWP) continues to be underused, even given its tremendous potential. Something…
I’m unlikely to unearth better details on this than good ‘ole SharePoint Joel. Check out Joel’s post for all the dirt. If, though, you’re like me and you just say “Gimme the downloads!” here are the key bits: 2007 Microsoft Office servers Service Pack 2 (x86) http://www.microsoft.com/downloads/details.aspx?FamilyId=B7816D90-5FC6-4347-89B0-A80DEB27A082 2007 Microsoft Office servers Service Pack 2 (x64)…
I’ve alluded to this in the past, but I had a client situation in the last few days that brought it top of mind again. One of the quirks of a Crosslist DVWP is that you *must* specify all columns you would like to display in the CAML for the Data Source. You can add…