how to set a column value onsubmit

xnrsisbi

Hi,

i need to save a generated string in a hidden column when i submit the form to the database. How can i achieve this?

Many thanks in advance :-)

nguyenm9

check https://editor.datatables.net/reference/event/preSubmit or https://editor.datatables.net/reference/api/submit()

xnrsisbi

Hi nguyenm9,

thank you for your answer :-)

since i'm new in DataTables, i code it like this:

editor.on( 'onInitCreate', function () {
editor
.set( 'id', 'wrh_test_test1827' )
.hide('id');
} );

but no new records are saved in the database :-(

should i do it in a different way?

Thanks in advance

allan

The preSubmit method that @nguyenm9 linked to is probably the best way. You would use something like:

editor.on( 'preSubmit', function ( e, d ) {
  d.data.myExtraField = "myValue";
} );

Then myExtraField is submitted to the server.

Perhaps another option is to use the hidden field type and set its value in the initCreate event if you wanted.

Allan

xnrsisbi

Thank you both
have a good one :-)