Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

Subform customization

hanstel
Posts: 28
Joined: Sat Apr 30, 2016 2:51 am

Re: Subform customization

Unread post 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);
Post Reply