2

I'm using the HTML calculated column that's outlined on the pathtosharepoint blog, but I'm wondering, is there any way to create a calculated column, that displays a button/check box or anything that will update both my status and % complete columns at the same time?

So essentially a task complete button, which renders both my status as Completed and my % complete as 100%?

Thanks

Rob

Improve this question
1

2 Answers 2

Reset to default
1

I would agree with Marc that a DVWP would be better in this case. I understand it is not an option for you.

Creating the button is the easy part, the problem is the onclick event handler.

Marc, the amount of script is not necessarily an issue, you can always put it in a function that will be called by the button. The main issue with calculated columns is that you cannot reference the item ID in the formula. You need a workflow trick to copy the ID to a standard field.

The bottom line is that it is not too difficult, but involves multiple steps/workarounds:

  • workflow to copy the ID
  • calculated column that creates the formula
  • text to HTML to display the button
  • externalize the onclick event handler in a function that calls the Web service to update the item.
  • and of course error handling along the way

Are you on SP 2007 or 2010?

Improve this answer
2
  • Hi Christophe, Thanks for the advice I'm on Sharepoint 2007. The main problem is that the javascript code itself is too complex for me. Is there any where that I can get the steps you have mentioned above written for me? Thanks - Rob Commented Oct 11, 2010 at 8:28
  • Rob, my advice is not to go down this route, it's not worth the trouble. If you still want to try, you should be able to find the different bricks on the Web (but not the whole procedure): - workflow to copy ID to ItemID - onClick='MarkComplete(itemID)' in your input formula - use a Web Service to write the MarkComplete function (certainly the SPServices documentation can help here) Commented Oct 11, 2010 at 15:06
0

IMHO, while what you're suggesting might be possible with an HTML calculated column, you're going to have something far more maintainable and sensical if you use a Data View Web Part (DVWP). Your button or link would need to have a decent amount of script in it and you might even run into a length problem with the column values.

Improve this answer
3
  • Problem is I don't have access to SPD - does anyone know where I could get help with coding something like this? Commented Oct 9, 2010 at 4:13
  • Marc-Would this be a good place to use your SPServices utilites? spservices.codeplex.com Commented Oct 9, 2010 at 4:35
  • I've managed to get myself the button in to the list now by using this code: =CONCATENATE("<DIV><INPUT TYPE='button' NAME='myButton' VALUE=Complete onClick='alert(",",[Status],",")'></DIV>") Need to sort out the onclick to update both my [Status] and [% Complete] columns - any ideas? Commented Oct 9, 2010 at 5:03