Page 3 of 3

Re: Subform customization

PostPosted: Tue Jul 05, 2016 6:49 am
by hanstel
Put
nuSetHash('LogModDate',date());
into javascript side, meaning before PHP event calls g.e. nuOnSave())

function nuOnSave() {
nuSetHash('LogModDate',date());
}


then on your PHP code, you can use the Hash as

$s = "
UPDATE inventory
SET inventory_log_TN_modified_by = '#nu_user_name#'
SET inventory_log_modified_at = '#LogModDate#'
WHERE INVENTRORY_ID = '#RECORD_ID#'
";

nuRunQuery($s);