none
Event handling for Sharepoint datagrid RRS feed

  • Question


  • I'm relatively new to SharePoint 2013.  For the past weeks I have been looking through on the web how to handle events in a sharepoint's datagrid view of a list. To be clear, I'm referring to that Excel style view that SharePoint allows you to edit quickly for a list of items.

    The question is: how and what should I use to handle an event that fires up when the user goes from one cell to the other.  I want to make some business logic validation or whatever.  Hence, please do not tell me to customise the column and use the default column validation, it works well but in my case I need much more than that...

    Hence, I would like you to focus on event-handling of that datagrid (SPgridView?) and to specifically be able to handle events such as: - on cell focus or leave - new row added - row before edit/save/deleted

    Also please do not tell me to use Visual Studio to create a web part with a GridControl and deploy it as a SP solution. I'm aware of that too and I don't want for now to go down that route :)

    What I think is that there should be some way (JavaScript? but how? what app? SP designer?) how I can handle those events that happen in that Excel-style datagrid.

    any ideas please?

    Wednesday, February 5, 2014 12:26 PM

All replies

  • THe "excel-style" datagrid is actually an active x control provided by the office install.  So not sure if you would be able to handle any of those events in any way other than maybe doing something with the DOM -> jquery/javascript... 

    The next thing you could do would be to create your own custom list view:

    http://www.martinhatch.com/2013/08/jslink-and-display-templates-part-5-creating-custom-list-views.html

    Might be a lot of work to get it the way you want it, though...

    Wednesday, February 5, 2014 3:03 PM
  • Thanks for your feedback.  From what I can see the link refers to some customisation of the display of fields.  Which is not what I need, unless I'm missing out something.  

    Further to that, what I'm really looking for is a solution of not having to "re-invent the wheel", to maximise the benefit of the investment from Sharepoint and most of all, a solution that can quickly be customised for any list in sharepoint.  That is why I don't want to make packages with VB; otherwise I would have to do a package/feature and build web parts for each list that a user decides to customise.  Am I asking a lot :) ?

    That native/built in datasheet (activeX?) is excellent for data entry! too bad it can't be customised... ?

    Wednesday, February 5, 2014 7:03 PM