Answers

• allan Posts: 63,498Questions: 1Answers: 10,470 Site admin

  April 23

  DataTable.render.select was introduced in Select 2, which requires DataTables 2 or newer.

  For a checkbox with Select 1 and DataTables 1.x, see this example.

  With that fixed, hopefully the inline editing will spring into action.

  Allan
• martinconnollybart Posts: 21Questions: 8Answers: 0

  April 23

  Ah, OK, I now have a checkbox that works in the first column, but it shows [object Object] too, and when I click another cell I get

  Unable to automatically determine field from source. Please specify the field name.

  Doesn't the "this" establish which field is to be used?
  Thanks
• kthorngren Posts: 21,327Questions: 26Answers: 4,949

  April 23 edited April 23

  but it shows [object Object] too

  Its probably due to the columns.data definition for that column. Please post your current config for the checkbox column.

  See if the technote link helps you resolve the issue.:
  https://datatables.net/manual/tech-notes/11

  If not please post the full Editor fields and Datatable columns config. Also tell us which column or columns have the error.

  Kevin
• martinconnollybart Posts: 21Questions: 8Answers: 0

  April 24

  Here's my column config (as per the V1 compatibility example, I hope)

  var spreadsheetTable = new DataTable('#sheet', {
              ajax: 'php/table.TApplicationsSpreadsheet.php',
              columns: [
                 {
                      orderable: false,
                      className: 'select-checkbox',
                      targets: 0
                  },
                  {
                      "data": "id", "label":"ID"
                  }{
                      "data": "id", "label":"ID"
                  },
                  {
                      "data":"fundname", "label":"Fund Name"
                  },
                  {
                      "data": "prompt"
                  },
                  {
                      "data": "submitted",
                      "type": "datetime"
                  },
                  {
                      "data": "purpose"
                  },
                  {
                      "data": "appprogress"
                  },
                  {
                      "data": "reqy1", render: DataTable.render.number(null, null, 2, '£')
                  },
                  {
                      "data": "reqy2", render: DataTable.render.number(null, null, 2, '£')
                  },
                  {
                      "data": "reqy3", render: DataTable.render.number(null, null, 2, '£')
                  },
                  {
                      "data": "reqy4", render: DataTable.render.number(null, null, 2, '£')
                  },
                  {
                      "data": "reqy5", render: DataTable.render.number(null, null, 2, '£')
                  }
              ],
              layout: {
                  topStart: {
                      buttons: [
                          { extend: 'create', editor: appeditor },
                          { extend: 'edit', editor: appeditor },
                          { extend: 'remove', editor: appeditor }
                      ]
                  }
              },
              scrollY: "500px",
              "paging": false,
              "autoWidth": true,
   select: {
                  style: 'os',
                  selector: 'td:first-child'
              },
              order: [[1, 'asc']]
  
          });
  

  and the editor fields:

  var appeditor = new DataTable.Editor({
              ajax: "php/table.TApplicationsSpreadsheet.php",
              fields: [
                  {"label": "id", "name":"id"},
                  {"label": "fundname", "name":"Fund Name"},
                  {"label": "prompt", "name":"Prompt"},
                  {"label": "submitted", "name":"Submitted"},
                  {"label": "purpose", "name":"Purpose"},
                  {"label": "appprogress", "name":"Progress"},
                  {"label": "reqy1", "name":"Req Y1"},
                  {"label": "reqy2", "name":"Req Y2"},
                  {"label": "reqy3", "name":"Req Y3"},
                  {"label": "reqy4", "name":"Req Y4"},
                  {"label": "reqy5", "name":"Req Y5"},
              ], table: "#sheet"
          });
  

  Clicking in any cell triggers the error (apart from the first column). This is the code snippet:

   // Activate an inline edit on click of a table cell
          $('#sheet').on('click', 'tbody td:not(:first-child)', function (e) {
              appeditor.inline(this);
          });
  
• allan Posts: 63,498Questions: 1Answers: 10,470 Site admin

  April 24 Answer ✓

  layout is not available in DataTables 1.x. That is a DT2 property.

  You need to use something like dom: 'Bfrtip' if you want the buttons to appear.

  {"label": "fundname", "name":"Fund Name"},

  Looks like label and name are the wrong way round. You presumably what what the users sees to be "Fund Name" - try reversing the values.

  Allan
• martinconnollybart Posts: 21Questions: 8Answers: 0

  April 24

  too long a day yesterday...inline and checkbox both working, now I have the tn/4 error again. I'll figure that out. Thanks Allan!