Forum Discussion

huffnic's avatar
huffnic
Data Storage
04-12-2024
Solved

Seeking help with a widget script for cell.value

Hello, I am currently using the following widget script for a pivot using rows (no values or columns) on windows OS: widget.transformPivot({}, function(metadata, cell) { if (cell.value...
  • TriAnthony's avatar
    04-16-2024

    Hi huffnic,

    The script you are using utilizes our Pivot 2.0 API which is for Linux only. You can try the below script for Windows. Let me know if this is helpful.

    -Tri

    widget.on('ready', function(){
    	$('td[class*=p-value] div').map(function(i, cell) {
    		switch (cell.innerHTML) {
    			case "Resolved": cell.style.backgroundColor='#90EE90';
    				break;
    			case "Open": cell.style.backgroundColor='#FF7F7F';
    				break;
    			case "In Progress": cell.style.backgroundColor='#FFFFE0';
    				break;
    			case "Not Applicable": cell.innerHTML='';
    				break;
    		}
    	}) 
    })