Is this possible? I just need to have a checkbox in the grid that the user can check/uncheck to select rows and a submit button. And obviously I need to be able to identify the selected rows in the server-side code.
It is possible to create editable grids. I've done it, but it is quite hard work. There are tools provided by partners. Qmulus in the UK have editable grids, CRM Together has a tool set and I think Leading Edge used to offer editable grids too.
Hi Paul,
You don't necessarily need editable grids to do this in .asp. But Costi's editable grids add-on is certainly worth a look https://leadingedge.ro/sage-crm-add-ons/editable-grids-for-sage-crm/
We did something with checkboxes and multi record updates in .asp about 4 years ago. https://vimeo.com/353395812 so in answer to your question and as per Jeffs reply, yes its definitely possible.
Hi Paul,
If you are familiar with the .net API, then there is an article that describes how you can start to achieve this. Article
There is existing functionality in the Relationships section that does exactly what you want (there should be a download somewhere that has the project for the relationship dll "King Jeff" might know where this is :-) )
Hope this helps.
The Relationships project ships with the .NET SDK. Sage CRM Community
Thanks everyone for ideas posted. As I only needed to add a checkbox to each row on the grid I created a calculated field in the view the grid is based on and added the calculated field to the grid. The calculated field outputs the html to create the checkboxes:
'<input type="checkbox" id="_chkselect'+CONVERT(varchar(20),Prod_ProductId)+'" class="_chkselect" data-pid="'+CONVERT(varchar(20),Prod_ProductId)+'" data-code="'+ISNULL(prod_code,'')+'">' AS prod_select
A button on the list page runs some javascript code to loop through the checkboxes and execute a function for all those that are checked.
*Community Hub is the new name for Sage City