Ability to Color cells based on cell value

kolate_sambhaji · January 25, 2016, 6:48am

@rmehta
Hi,
This is a standard slickgrid feature and it is coming automatically in frappe framework.
Many ERPNext developer already using it. (AFAIK @BhupeshGupta is first member to using it)

To link slickgrid formatter we need to add formatter function in query_report.js
Example

github.com

BhupeshGupta/Flows/blob/master/flows/flows/report/inventory_balance/inventory_balance.js#L25


      
          			"fieldname": "to_date",
          			"label": __("To Date"),
          			"fieldtype": "Date",
          			"reqd":1
          		}
          	],
          	"tree":true,
          	"name_field":"warehouse",
          	"parent_field":"parent_warehouse",
          	"initial_depth":0,
          	"formatter":function (row, cell, value, columnDef, dataContext, default_formatter) {
          		if (columnDef.df.fieldname == "warehouse") {
          			value = dataContext.warehouse;
          			columnDef.df.is_tree = true;
          		}
          
          
		value = default_formatter(row, cell, value, columnDef, dataContext);
          
          
		if (!dataContext.parent_warehouse) {
          			var $value = $(value).css("font-weight", "bold");
          			value = $value.wrap("<p></p>").parent().html();

We can use following features of slickgrid by adding function in query_report.js

Thanks @BhupeshGupta

@rmehta I am also working on editable report. This will enable user to enter data from excel like view.