Very Odd Calculated Value Column Behavior

Published 18 February 09 06:33 PM | Blogging about SharePoint: Posts
Body:

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?

image

 

Ideas?

Michael

Published: 2/18/2009 3:33 PM
Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks

Read the complete post at http://feeds.feedburner.com/~r/BloggingAboutSharepoint/~3/542823833/ViewPost.aspx