Formating boolean

[Dennis]

Hi I've got a grid and one of the columns is bound ta boolean value. I would like to format it to something else other than true and false (On / Off for instance), and i realize I don't know how to do that. With a format field inside the columns property? How would such a format look like? Thanks in advance!

[Alexander Valchev]

Hi Dennis,

To achieve that you can use a column template and JavaScript Conditional operator. As an example:

columns: [
    {field: "foo", template: "#= foo ? 'yes' : 'no' #"}
]

Kind regards,
Alexander Valchev
the Telerik team

[Dennis]

Never even thought of templates, and their the natural solution here. Thanks, you helped me out a lot!

[Dennis]

Hey, i tried this out but when i put a template inside my columns property the whole table just gets messed up and starts looking like the picture in the attachment.
  
this is the code for my grid, I'm using declarative binding. It's start looking like this once I turn on a template, I've tried putting anything in it. I even turned off all the other CSS and left only the kendo ones, because i thought that something there was messing it up but it's the same.

<div id = "TeamMembersGird" data-role="grid" data-sortable="true" data-pagable="true" data-editable='{"mode" : "popup", "confirmation" : "Are you sure you want to delete this team member?"}'

     data-bind="source: teamMembersSource"

     data-columns='[{"field":"FirstName", "title":"First name"},

                    {"field":"LastName", "title":"Last name"},

                    {"field":"IsCompanyAdmin",  template: "#= IsCompanyAdmin ? 'Yes' : 'No' #", "title":"Admin"},

                    {"title":"Action","width":"300px",

                     "command":["edit", "destroy", {"text" : "Reset password", "click": "ResetPassword" }]}]'>

</div>

[Iliana Dyankova]

Hi Dennis,

The reason to get this appearance for the grid when using template is due to the quotation marks - you should escape them. I believe the following definition of the template should help to resolve the issue: 

<div id = "TeamMembersGird" .... data-columns='[... {"field":"IsCompanyAdmin", "template": "#= IsCompanyAdmin ? \"Yes\" : \"No\" #"}]'>

As a general information, please note that the template should be in quotes:

<div id = "TeamMembersGird" .... data-columns='[... {"field":"...", "template": "...}]'>

 

Regards,
Iliana Nikolova
the Telerik team