Questions for Confluence license has expired.

Please purchase a new license to continue using Questions for Confluence.

Compare two value in one spreadsheet

 
1
0
-1

Hi I'm Newbie,


I would to compare two value(numeric) (different column) in one spreadsheet and do some custom field format if this two value are different. If put this code in format in spreadsheet (field id: VCR_TABLE1.total ), but the comparison with VCR_TABLE1.Weight_kg (field in spreadsheet) are not working.

{{renderer:function(instance, td, row, col, prop, value, cellProperties)
{console.log(value);
if(parseInt(value)<>VCR_TABLE1.Weight_kg)
{td.innerHTML="<strong span style='color: black; background-color: red;'>"+value+"</span>";}
else{td.innerHTML="<span style='color: white; background-color: green;'>"+value+"</span>";}}}}


thanks.

    CommentAdd your comment...

    1 answer