Answers

• paintitblack Posts: 60Questions: 20Answers: 0

  February 2017

  Sorry, but I solved it -> https://editor.datatables.net/reference/field/hidden
• Apezdr Posts: 43Questions: 4Answers: 5

  February 2017 Answer ✓

  Howdy,

  If you want to omit fields from showing in the Editor you can simply omit it from the editor instancing.

  Example.

  var table = $('#ClientData').DataTable( {
          ajax: ajaxURL,
          columns: [
              {
                  "title":"Client Name",
                  "data": "ClientData.ClientName"
              },
              {
                  "title": "Rev Projection:",
                  "data": "ClientData.RevProjection",
                  "render": $.fn.dataTable.render.number( ',', '.', 0, '$' )
              }
  

  var editor = new $.fn.dataTable.Editor( {
          ajax: ajaxURL,
          table: '#ClientData',
          fields: [
              {
                  "label": "Client Name:",
                  "name": "ClientData.ClientName"
              }
  

  If you don't define it in the editor instance it wont load the field in the editor form.
• paintitblack Posts: 60Questions: 20Answers: 0

  February 2017

  Oh I see and I will try this solution as well.

  Thank you very much man

  Cheers Patrick
• bpernikoff Posts: 4Questions: 1Answers: 0

  March 2018

  I tried this solution of omitting the field from the editor fields: definition and received the following error:

  dataTables.editor.js:2771 Uncaught Unknown field name - itemSize

  I'm looking for the same solution - to display the column but hide it from the edit form. Thanks in advance.
• colin Posts: 15,238Questions: 1Answers: 2,599

  March 2018

  Hi bpernikoff,

  The most likely cause, without seeing your code, is that the field itemSize really doesn't exist - is it a typo, or has it been removed?

  If that's not the cause, please post your code and we can take a look. It might be best to do it in a new forum thread and just link to this one.

  Cheers,

  Colin
• bpernikoff Posts: 4Questions: 1Answers: 0

  March 2018

  Hi Colin,

  Thanks for replying. Here is my code which is only using the in memory table to be used to post the data back to an endpoint.

  The table definition: itemSize is a hidden column used as a placeholder so the total for all file sizes can be calculated.

  
     $('#savedItemsTable').DataTable({
              dom: "Bfrtip",
              data: $.map(todo, function (value, key) {
                  return value;
              }),
              columns: [
                  { data: "itemID"},
                  { data: "itemLocation" },
                  { data: "itemCustodian", className: 'editable' },
                  { data: "itemEvidenceID", className:'editable' },
                  { data: "itemSize", visible:false }
              ],
              select: {
                  style: 'os',
                  selector: 'td:first-child',
                  blurable: true
              },
              buttons: [
                  //{ extend: "create", editor: editor }
                  { extend: "edit", editor: editor },
                  { extend: "remove", editor: editor }
              ]
          });
  
  

  Here is the Editor: I was hoping to omit the itemSize from the fields as per your instruction so that it does not appear on the edit form but doing so throws that error (dataTables.editor.js:2771 Uncaught Unknown field name - itemSize)

         var editor = new $.fn.dataTable.Editor({
              table: '#savedItemsTable',
              fields: [{ label: "Item Id", name: "itemID" },
                       { label: "Title", name: "itemLocation" },
                       {
                           label: "Custodian", name: "itemCustodian", type: "select",
                           options: [
                               { label: "Mary Goodman", value: "Marty Goodman" },
                               { label: "John Lewis", value: "John Lewis" },
                               { label: "Howard Jones", value: "Howard Jones" }
                           ] },
                       { label: "Evidence Id", name: "itemEvidenceID" },
                       { label: "File Size", name: "itemSize", visible: false }],
  
              ajax: function (method, url, d, successCallback, errorCallback) {
                  var output = { data: [] };
  
                  if (d.action === 'create') {
                      // Create new row(s), using the current time and loop index as the row id
                      var dateKey = +new Date();
  
                      $.each(d.data, function (key, value) {
                          var id = dateKey + '' + key;
                          value.DT_RowId = id;
                          todo[id] = value;
                          output.data.push(value);
                      });
                  }
                  else if (d.action === 'edit') {
                      // Update each edited item with the data submitted
                      $.each(d.data, function (id, value) {
                          value.DT_RowId = id;
                          $.extend(todo[id], value);
                          output.data.push(todo[id]);
                      });
                  }
                  else if (d.action === 'remove') {
                      // Remove items from the object
                      $.each(d.data, function (id) {
                          delete todo[id];
                      });
                      ///... update the file size total here
                  }
                  // Show Editor what has changed
                  successCallback(output);
              }
          });
  
• colin Posts: 15,238Questions: 1Answers: 2,599

  March 2018

  Hi again,

  Please take a look at second comment in this thread, it points to this page. If you add the hidden then that'll sort you out.

  Cheers,

  Colin