cell with conditional display text

[TenarisDev]

Hi,

I'm trying to make it so that when a cell in the grid has a value "TRUE" it shows "validated" and in the case that it is different from "TRUE" , it shows "not verified"
var dataMock2 = [{"VALID_EMAIL":"TRUE"}];
 

var obj3 = {
      width: "100%",
      height: 800,
      resizable: true,
      title: "",
      showBottom: false,
      scrollModel: { autoFit: true },
      dataModel: { data: dataMock2 },
      colModel: [
        { title: "VERIFIED MAIL", dataType: "STRING", dataIndx: "VALID_EMAIL",formula: function (ui) {                       
          var rd =  ui.rowData=="TRUE"?"VALIDATED":"No VALIDATED";
          return rd;
      } }
      ]
    }

    $("#grid_json").pqGrid(obj3);


Thank you very much for the help

[paramvir]

that can be done with column.render callback.

Code: [Select]

colModel: [
        { title: "VERIFIED MAIL", dataType: "string", dataIndx: "VALID_EMAIL",
          render: function (ui) {                       
            return ui.cellData == "TRUE"?"VALIDATED":"No VALIDATED";
         }
       }
]


[TenarisDev]

Thanks, this is great!