Conditional Options on Editor Field

wolphitdepartment

Hello. How would I the options for select dependent on a field's value?

`
(function($){

$(document).ready(function() {

var myEditor = new $.fn.dataTable.Editor( {
    serverSide: true,
    ajax: 'myphpfile.php',
    table: '#my_table',=
    fields: [
        {
            "label": "Status",
            "name": "mytable.status",
            "type": "select",
            "options": [
                if (mytable.status=="OKAY") {
                    { label: "A", value: "A" },
                    { label: "B", value: "B" },
                }
                else if (mytable.status="NOT OKAY)") {
                    { label: "C", value: "C" },
                    { label: "D", value: "D" },
                }
            ]
        }
    ]
} );

`

allan

Use dependent(). It provides a way to give a function that can be used to update the Editor form whenever required (e.g. on start edit, create, etc). There is an example available here.

Allan

wolphitdepartment

The example on the link you sent is only for hiding/showing editor fields. How do I make this code work to where dependent() API can be used to populate options for a SELECT field?

editor.dependent( 'mytable.status', function ( val ) {
        if (val === 'APPROVED') {
            // SET SELECT OPTIONS for mytable.status
            mytable.statusoptions [
                { label: "A", value: "A" },
                { label: "B", value: "B" },
            ]
        }
    } );

allan

dependant()'s return value can include an options parameter, or you could call field().update() directly on the field in question:

editor.dependent( 'mytable.status', function ( val ) {
        if (val === 'APPROVED') {
            editor.field('mytable.status').update([
                { label: "A", value: "A" },
                { label: "B", value: "B" },
            ]);
        }
} );

Allan

wolphitdepartment

Thank you for your response. It's working. However, I'm using AJAX and upon update, I'm getting this error:

Field is still processing For more information, please refer to https://datatables.net/tn/16

I tried to fool around using this code but I don't know where to put the code you provide inside this code here:

editor.dependent('mytable.status', function(val, data, cb) {
        $.ajax({
            url: '/mydependentapi.php',
            data: data,
            success: function (json) {
                if (val === 'APPROVED') {
                    editor.field('mytable.status').update([
                        { label: "A", value: "A" },
                        { label: "B", value: "B" },
                    ]);
                }
                else if (val === 'PENDING') {
                    editor.field('mytable.status').update([
                        { label: "C", value: "C" },
                        { label: "D", value: "D" },
                    ]);
                }
                cb(json);
            }
            
        })
    
    });

colin

I can see that error be displayed if the ajax call doesn't succeed - the callback is only being called in the success() function. Are you seeing errors in the browser's console, or any errors in the server-side logs?

Colin

wolphitdepartment

The condition is working but there's a DTE_Processing_Indicator in the modal and when I checked the browser console after clicking the update button, it shows that field is still processing error.

allan

We'd need a link to your page showing the issue to be able to debug the problem. The code above looks correct.

Allan