How To send Submit if Cell Checkbox checked

Sunilgoel

Hi ,

I have cell type "checkbox" , if Checked then Value will be "Y" else "N" .

If checkbox select or unselect , how to submit and set value Y or N in tables.

Regards.
Sunil

Paulus

Do you have license to the Editor or you are only using the DataTable?

Sunilgoel

Hi
Yes i have Editor License.

Regards.
Sunil

allan

Hi Sunil,

You should be able to use the options parameter for the checkbox field type to set the values and labels that you want to use.

There is an example of that available here.

Allan

Sunilgoel

Hi Allan,
When i Checked checkbox , does not send data to server where as if i changed anything changed value in cell then works well. Please suggest.

Regards.
Sunil

Paulus

Hello Sunil,

Sorry, I missed the reply. Have you tried this sample

https://editor.datatables.net/examples/api/checkbox.html

Make sure you set the options (with the value to 'Y')

options:   [
      { label: '', value: 1 }
]

and this code, which submits the changes

    $('#example').on( 'change', 'input.editor-active', function () {
        editor
            .edit( $(this).closest('tr'), false )
            .set( 'active', $(this).prop( 'checked' ) ? 1 : 0 )
            .submit();
    } );

Sunilgoel

Hi Paulus,
work done. Thanks Guys.

Regards.
Sunil