locked
Form that shows only modified data? RRS feed

  • Question

  • Not sure if this is something that would need to be coded but I'm looking for a way to build a form that will show only the fields that have been modified.  For example, user A modifies column 1 and 3 but not 2.  WF fires and emails user B with a link to a custom form.  Custom form will have column 1 and 3 data shown but not 2. Or, alternatively, the form would show all fields but mark in bold/red/etc. those fields that have been modified.

    I know I could do this utilizing 2 lists and copying items to list 2, then comparing them but that seems extremely cumbersome.  With version history, SP must keep record of which fields have changed and what the previous data was in those fields.  I'm lost on how to surface it.

    • Edited by Mike Walsh FIN Friday, May 7, 2010 3:20 AM "Form" etc. added to Title
    • Moved by Mike Walsh FIN Friday, May 7, 2010 3:21 AM Moving to General as clearly asking for suggestions on which approach to take. (From:SharePoint - Setup, Upgrade, Administration and Operation (pre-SharePoint 2010))
    Thursday, May 6, 2010 7:13 PM

Answers

  • I believe you are using sharepoint object model to do this. You can match the column value with new and old. Append only modified value in your email.

    refer this link you will defiantly find the solution:

    http://geekswithblogs.net/AnneBougie/archive/2009/01/23/copy-a-sharepoint-list.aspx


    Cheers, Hemendra-MCTS
    Friday, May 7, 2010 7:04 AM
    Moderator
  • i would look into some third party application add-ons that you can probably buy for cheaper than spending the man-hours to develop that kind of solution (with 200 columns). some off the top of my head that may or may not work are CorasWroks and WebParts360.
    http://www.henryong.com
    Sunday, May 9, 2010 3:55 AM

All replies

  • I believe you are using sharepoint object model to do this. You can match the column value with new and old. Append only modified value in your email.

    refer this link you will defiantly find the solution:

    http://geekswithblogs.net/AnneBougie/archive/2009/01/23/copy-a-sharepoint-list.aspx


    Cheers, Hemendra-MCTS
    Friday, May 7, 2010 7:04 AM
    Moderator
  • Thanks for the reply.  I feel as though this would be similar to copying items and comparing them via a workflow.  This wouldn't be an issue if the list were small but it's going to be a bit of a monster, probably 200 columns or more.
    Friday, May 7, 2010 3:27 PM
  • i would look into some third party application add-ons that you can probably buy for cheaper than spending the man-hours to develop that kind of solution (with 200 columns). some off the top of my head that may or may not work are CorasWroks and WebParts360.
    http://www.henryong.com
    Sunday, May 9, 2010 3:55 AM