One of the great benefits of running online workshops is that it pushes me to refine my solutions.
The cornerstone of Tuesday’s visualization workshop is the HTML calculated column. So for the occasion I revisited my script and worked on several improvements. The main one is to make the filter menu work for HTML calculated columns (see screenshot).
Another enhancement I am working on is to allow the use of HTML calculated columns for grouping (see second screenshot).
The first to benefit from the improvements will of course be the workshop participants, as the filter menu will be included in the script they’ll receive. The complete version (v3) of the HTML Calculated Column with all the enhancements should be published by the end of the year.
Update [11/01/2009] Another screenshot of my work in progress: HTML calculated columns used for two level grouping.
17 comments
Comments feed for this article
November 2, 2009 at 12:40 am
Links (11/1/2009) « Steve Pietrek – Everything SharePoint
[...] Sneak Peek: HTML Calculated Column v3 [...]
November 4, 2009 at 3:48 pm
tbone
awesome, can’t wait to see it. When do you plan on rolling this out?
November 5, 2009 at 1:51 am
Pman
That filter screenshot looks awesome. Really looking forward to this release.
November 6, 2009 at 2:30 pm
Christophe
It will take me some time to finalize v3. I’ll write the script for SP 2007 exclusively, which means that I’ll be able to include some improvements that were not possible in previous versions (that applied to both SP2003 and SP2007).
I’ll be happy to send the work in progress to people who are willing to volunteer as testers. Just send me an e-mail with “HTMLcc” in the subject.
November 6, 2009 at 3:01 pm
Patrick
Amazing job ! Thank you, I feel impatient to see the results
March 8, 2010 at 1:34 pm
RD
Love the site and the help. I have a random question regarding using the calculated columns.
I have a project tracking type list i am using to show what deliverable a certain site is in. It is using the Today function in the calculated cell. Knowing that the list will not update unless the record is modified, is there a way to modify every item in the list (sort of open and save) to update that column, or a better way to get the information I am wanting.
Code snippet:
=IF([tBAND Start Date]=”",”(XV) No Start Date Defined”,IF(Today>=[tBAND Start Date],”(XIV) Projected Started”,IF(Today=[tBAND Start Date]-1,”(XIII) T-1 Day Email Notification”,IF(Today>[tBAND Start Date]-3,”(XII) T-3 Day Email Notification”,IF(Today>[tBAND Start Date]-7,”(XI) Site tBAND Go/No Go”,IF(Today>[tBAND Start Date]-10,”(X) T-10 Day Email Notification”,IF(Today>[tBAND Start Date]-14,”(IX) BigFix and App Readiness teams confirmed changes”,CurrentDeliverable2)))))))
Using this code i get it to calculate correctly when entries are created, but they do not update themselves as the date changes. (typical Today issue)
any and all help is greatly appreciated.
March 11, 2010 at 9:46 am
Christophe
Just the typical Today issue as you say. That’s why I don’t recommend this trick.
That said, re-creating the Today column and re-deleting it should do the trick.
March 23, 2010 at 8:19 pm
Wanda
Hi Christophe – is V3 ready? if not, I have a potential opportunity to test the rollups…
March 28, 2010 at 1:30 pm
Christophe
v3 is not ready, and with SP 2010 coming soon I am not going to release a new version until I have tested it in SP 2010…
April 28, 2010 at 2:46 pm
Santhosh
Hi Christophe,
I have been using your idea of calculated coulms and javasrcipts. I have three calculated columns (hyper link, Progress Indicator Bar, Red Amber Green status). I had implemented this because I wanted to improve the visual effects. Now, My client wants filtering on those columns(It displays plain html when I click on the column to filter). I am really looking forward for your updated script (V3) or any other work around/ideas to accomplish this. I am ready to help you with testing of versions. Do you have any estimated time to rollout version 3 so that I can promise my client.
April 28, 2010 at 4:09 pm
Christophe
Santhosh, I won’t have v3 available soon because I’ll need to do some testing on SP 2010.
I have sent you v2.2 (beta) that may address your need.
May 7, 2010 at 11:24 am
Fran
Hi Christophe!
You HTMLcc have improve my sharepoint sites a lot! Thanks!
I would like to test your new version with my lists when using the grouping option!!
September 2, 2010 at 9:18 am
Richard
I am also experiencing the problem when trying to filter on R/A/G calculated column whereby the actual html is being shown. I would be interested in trying out the beta fix.
December 10, 2010 at 3:39 pm
Duncan
HTMLcc
Hi,
I’ve just arrived at the problem of displaying html in the drop down filters and look forward to seeing V3
December 11, 2010 at 11:16 am
Christophe
Follow up to my comment from April: the improvements featured in the post won’t apply to SP 2010. I am currently working on a new v3, trying a completely different approach. This will certainly take a couple more months.
January 21, 2011 at 1:53 pm
Darren Kellum
Hi Christophe, would you be able to send me the fix for being able to filter these HTML calculated columns as shown in your screenshot?
January 23, 2011 at 4:49 pm
Christophe
Darren: as I said in the previous comment, this code is obsolete. I’ll share another solution in a couple weeks/months. You can see a live demo of the work in progress in my latest blog post (countdown/countup).