I usually test my formulas in Excel. The syntax is the same; if it works in Excel, it’s going to work in SharePoint. (There may be exceptions to this, but I haven’t run into them.) Simply set up some cells with the values you need and then work out your formula. Once you’ve got it…
Yup. Decided to switch themes. Sort of like trying on a new summer wardrobe. I thought that this theme might be a little easier on the eyes and also give a bit more room for code. Let me know what you think! UPDATE 2009-07-26 — Turns out the new wardrobe just didn’t feel right, so I’m…
As long as I’ve been working with Data View Web Parts (DVWPs), I’ve pretty much always done my “joins” manually by diving into the XSL. When I started working with DVWPs, there wasn’t much available to tell me how to do things, so I just made it up based on what worked. Today I saw…
Over the last few days, I’ve been doing some more work with jQuery. It’s really a very cool abstraction on JavaScript, but it does take some getting used to. My latest challenge is to understand .animate. It’s pretty straightforward, but cross-browser issues can make it tricky. I’m having “special” trouble with opacity in Internet Explorer. …
I posted last September about Date Calculations in a DVWP. In that post, I pointed out Andy Lewis’ great post about how to do Filtering and Formatting with Date Values over at the Microsoft SharePoint Designer Team Blog. I’ve been answering quite a few questions about date arithmetic over at the MSDN forums lately, so…