JQuery.BootGrid data types and data formatters

jquery jqgrid-formatter jquery-bootgrid
pashute picture pashute · Aug 14, 2015 · Viewed 7k times · Source

What data types and data formatters are available with JQuery.BootGrid? Or are the data-type and data-formatter fields actutally JQuery DataTypes or some other property? If so what are the JQuery DataTypes? (I couldn't find documentation about that)

I want to set a column as currency (with a dollar sign to the left), how do I do that with JQuery.BootGrid?

But I want to understand the data-type/data-formatter in general. Do I have to understand jqGrid formatter for that, or is bootGrid a totally different product?

Answer

Abdul Manaf Saparuddin picture Abdul Manaf Saparuddin · Mar 19, 2017

Actually I've been using jquery bootgrid for the last 8 months and Using its formatter function to reformat any columns.

In the js file:

$("#grid").bootgrid({
  money: function(column, row) {
    return '$ '+row[column.id];
  },
  priceFormat: function(column, row) {
    return '<span class="price-format">'+row[column.id]+'</span>';
  }
});

In the html:

<thead>
  <tr>
    <th data-column-id="id" data-identifier="true" data-type="numeric">ID</th>
    <th data-column-id="nama">Nama</th>
    <th data-column-id="merk">Merk</th>
    <th data-column-id="harga_limit" data-formatter="money">Harga Limit</th>
    <th data-column-id="harga_satuan" data-formatter="money">Harga Satuan</th>
    <th data-column-id="harga_total" data-formatter="priceFormat">Total</th>
  <tr>
</thead>

Related questions

How to change date format in jqgrid

I have one issue related to jqgrid. I have date shown in jqgrid table like "FRI MAY 17 00:00:00 IST 2013" .I want to change its format to "17/5/2013".how i can do it? {name:'checkin', index:'checkin', width:60, searchoptions:{sopt:['eq']}}, this is …

Read More
How to unselect the selected row from jQgrid when the custom formatter text field value is empty

When i tried to check the check box in jQgrid it selecting the values that's fine ,and in that i have the custom formatter text field with out entering the values in text field and tried to select the check …

Read More
How to provide a hyperlink to a column data in JQgrid and navigate to respective Url based on data clicked?

I have a JQgrid which contains has just 2 columns..I am pasting my code which i have tried below.. var UserArr = new Array(); function Grid() { $("#users_grid").jqGrid({ colNames: ['Site_Name', 'Details'], colModel: [{ name: 'Site_Name', index: 'Site_Name', width: 130,…

Read More