Replies

• allan Posts: 64,660Questions: 1Answers: 10,690 Site admin

  January 2018

  Using the dependent() method sounds like the way to go here. You can have it make an Ajax request to get any options from a database (if you need that) and also set other field values.

  Allan
• rf1234 Posts: 3,127Questions: 91Answers: 432

  January 2018 edited January 2018

  As a start you could look at this example as well:
  https://editor.datatables.net/examples/api/dependentFields

  and here is an example from my own coding:

  contractEditor
          //preset Iban with saved iban from table govdept as soon as department
          //is being selected
          .dependent('contract.govdept_id', function (val, data, callback) {
              //if the govdept id is filled and the iban isn't set yet   
  //              if ( val > '0' && contractEditor.val('contract.iban') <= '' ) {
              if (val > '0' && data.values['contract.iban'] <= '') {
                  $.ajax({
                      type: "POST",
                      url: 'actions.php?action=getIban',
                      async: true,
                      data: {govdeptId: val},
                      dataType: "json",
                      success: function (data) {
                          return contractEditor.
                                  set({'contract.iban': data.iban});
                      }
                  });
              }
          })
          .dependent('contract.expired', function (val, data, callback) {
              if (val == '1') {
                  contractEditor
                          .show(['contract.exp_date']);
                  if (contractEditor.val('contract.exp_date') <= '') {
                      contractEditor
                          .field('contract.exp_date').set(yesterday);
                  }
              } else {
                  contractEditor
                          .set({'contract.exp_date': ''})
                          .hide(['contract.exp_date']);
              }
          })