Answers

• allan Posts: 63,522Questions: 1Answers: 10,473 Site admin

  December 2023

  Hi Ionut,

  I would suggest having two Editor instances on your table. Have one that is tied to a "Create" button and one that performs the inline editing. Define the fields as needed for each.

  Regards,
  Allan
• rf1234 Posts: 2,996Questions: 87Answers: 421

  December 2023 Answer ✓

  Simple solution: Use two different Editors with the same Data Table. No problem. If your Data Table is ajax sourced all of the Editors would have the same url. I use up to four different Editors with the same Data Table.

  The other option is to use the same Editor with the form and inline in parallel. You only limit the inline editable cells and of course you can also hide other fields dynamically in the form. That also works well.

  This is an example of the latter with special inline form options:

  var cashFlowEditor = new $.fn.dataTable.Editor({
          ajax: {
              url: 'actions.php?action=tblCashFlow',
              data: function (d) {
                  var selected = contractTable.row({selected: true});
                  if (selected.any()) {
                      d.contract_id = selected.data().contract.id;
                      d.instrument = instrument;
                  }
              }
          },
          table: "#tblCashFlow",
          formOptions: {
              inline: {
                  submit: 'allIfChanged',
                  onBlur: 'submit'
              }
          },
  

  and the activation for inline editing for special rows (not all rows) and special columns.

  // Activate an inline edit on click of a table cell
  $('#tblCashFlow').on( 'click', 'tbody tr.inlineRepaymentInterest td.inlineCashFlow',
      function (e) {
          cashFlowEditor.inline( this, {
              onBlur: 'submit'
          } );
  } );
  

  You see the "onBlur" option redundantly: That was due to a bug in Editor. Might be fixed by now.

  Now if you want to exclude fields from form editing you can use this:

  editor.on( 'open', function ( e, type ) {
      // Type is 'main', 'bubble' or 'inline'
      if (type === 'main') {
          this.hide(['field1', 'field2']);
      } else {
          this.show(['field1', 'field2']);
      }
  } );
  
• ionut.voda Posts: 2Questions: 1Answers: 0

  December 2023 edited December 2023

  Hi rf1234,

  Actually, this did the trick:

  editor.on( 'open', function ( e, type ) {
      // Type is 'main', 'bubble' or 'inline'
      if (type === 'main') {
          this.hide(['field1', 'field2']);
      } else {
          this.show(['field1', 'field2']);
      }
  } );
  

  Thanks!