I've recently started working with SharePoint 2013 and have been researching how to manage events in a SharePoint datagrid view for a list. Specifically, I'm interested in the Excel-style view that allows quick editing of items in a list.
My question is: how can I handle an event that triggers when a user moves from one cell to another? I want to implement some custom business logic validation or other actions. Please note that I am not looking to customize the column and use default column validation as it does not provide the functionality I require.
I would like assistance with event handling in the datagrid (SPgridView?) such as: - when a cell gains or loses focus - when a new row is added - before a row is edited/saved/deleted
Please refrain from suggesting the use of Visual Studio to create a web part with a GridControl and deploy it as a SharePoint solution. I am aware of this option but currently do not wish to pursue that route.
I believe there must be a way (possibly using JavaScript? What application? SP Designer?) to handle these events within the Excel-style datagrid view.
Any ideas or suggestions would be greatly appreciated!