Blogging about SharePoint

2/18/2009

Very Odd Calculated Value Column Behavior

I have a task list, and I have added a calculated value column to it. The calculated value column returns a text string which is recognized as a URL and is a clickable link.

The formula for the column is =concatenate("http://server/managedpath/sitecoll/site/_layouts/UpdateSomethingStatus.aspx?TID=",ID).

When you click on the link, the target page checks a web service to see if one of the columns in the task list (the "Is A" column) needs to be updated, if so updates that column, and then redirects back to the task list. The code does not touch the calculated value column at all.

When the column gets updated, the calculated value field drops the value of the ID field from the displayed link. WHY?

Here is a picture. The calculated value column is named Recheck. See how the there is no number to the right of "TID=" in the first item, but there is in the second item? Of course, all items have an ID, so why did this one disappear?

Ideas?

Michael

Posted at 3:33 PM by Michael Blumenthal | Category: SharePoint Development | Permalink | Email this Post | Comments (4)

Comments

It's a new Sharepoint technology

You've heard about the BDC? Sharepoint also contains "RABIT" or "RAndom Bug Introduction Technology". Apparently this was done at the behest of Avanade et al who bill by the hour!

at 2/18/2009 6:36 PM

Re: Very Odd Calculated Value Column Behavior

I have had the exact same problem! You can re-instate the ID values by editing the calculated column, and clicking OK. it will then update all existing calculated column entries correctly.

But a solution to this 'bug', if anyone knows, would be appreciated!

at 3/25/2009 9:01 AM

How I skinned the cat

Its not beautiful =( but it works

=CONCATENATE("<A HREF='../../myfile.aspx?project=",[id],"'>",[display],"</A>")

at 7/9/2009 7:02 AM

Re: How I skinned the cat

That doesnt work at all

at 9/29/2009 9:32 AM

Add Comment

Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.

Title

Body *

Please put your name at the end of your comment as the Name field doesn't display in the main view of the comments.

Name: *

Your name. If you first name is Michael, please provide initials or the like to clearly distinguish your name from Michael Blumenthal's.
Also, this field does not appear in the main view of the comments.

Need Paid Consulting Services?

Yes

Are you interested in engaging a SharePoint consultant for fee-based consulting services? If so, I can have an Account Executive from my employer contact you. Other site visitors will not see this column.

Additional Contact Information

Please provide additional contact information if you need a direct response. Other site visitors will not see this column.

What is tomorrow's date? *

This is a weak CAPTCHA based on advice from a tweet from @ToddKlindt.

Attachments