A little background first: I am building a dashboard for our accounting department which has various metrics and actuals displayed in a Kendo UI Grid object. I am hosting this dashboard on our company's SharePoint site and am building the datasource for the grid by combining information found in multiple SP lists using SPServices and a custom JS array join function.
My problem is that each one of these 16 rows of metrics and actuals are unique in the type of information they contain; some rows contain monetary values, some contain decimals, some contain whole numbers. I need to find a way to format a couple columns in the grid based upon what type of information that row contains. I know I can build some ugly and overly complex JS function to loop through each row and apply formatting based upon values found in that row, but I'd rather do something a bit more elegant with the Kendo markup if possible.
My though is this: if I stored the formatting code for each row in the SP List that becomes the JS array which I am using for the grid's datasource, could I use then somehow use this stored formatting code in the grid markup, thus eliminating the need to loop back through the grid once it has been rendered?
Thanks in advance for any input, and if I missed a related forum post please point me in the right direction!