Dependent columndef

karlie

columndef when value of other column is 'x'

I have a column called 'Type' with 3 options EACH, PCT,GRAM
I want to set a column definition for the 'Price' column If 'Type' = PCT

{ targets: ['price'], render: function (data, type, row, meta) {var row['type'] == ['PCT'];return row['ct'] * row['ppct'];} },

The above code doesn't work, but any pointers would be fab.

allan

I don't believe your Javascript is correct. The var row['type'] == ['PCT']; uses a comparison operator rather than an assignment among a few other issues with it.

Try:

if ( row['type'] = 'PCT' ) {
  return row['ct'] * row['ppct'];
}
// .. else return what ?

Allan

karlie

I tried this but it gives an Uncaught SyntaxError: Unexpected token if

{ targets: ['price'], render: function (data, type, row, meta) 
if ( row['type'] = 'PCT' ) {
  return row['ct'] * row['ppct'];
} },

tangerine

Your function doesn't seem to have an opening curly brace.

karlie

Thanks for the help Tangerine & Allan, this worked for me in the end

//Price when different TYPE is selected
        { targets: ['price'], render: function (data, type, row, meta)
        {
        if ( row['type'] == 'PCT' ) {
        return "£" + row['ct'] * row['ppct'];
        }
        if ( row['type'] == 'EACH' ) {
        return "£" + row['each_price'];
        }
        }
        },

Not sure if it's the most efficient way to be honest as I'm a bit out of my depth!