nuBuilder Forum

Posted: **Tue May 09, 2023 10:01 pm**

Hello,
Searching the forum I came across this thread. I will try to use this advice, but not working.
I'm greenhorn.

I need to save the user to the database who ran the report.

I've created a run button that launches a report.

In "Custom Code" with "Event: onclick" I typed JavaScript:

Code: Select all

nuRunPHP(save_usr_przew_o)

Procedure PHP "save_usr_przew_o":

Code: Select all

nuRunQuery("UPDATE zlecenie SET zlc_przewodnik_o = '#USER_NAME#' WHERE zlc_id = '#zlc_id#';");

but I also use it for testing:

Code: Select all

nuRunQuery("UPDATE zlecenie SET zlc_przewodnik_o = test WHERE zlc_id = '#zlc_id#';");

I'm afraid, I need help.

Posted: **Wed May 10, 2023 12:57 am**

Hi,

Try:

Code: Select all

nuRunPHPHidden('save_usr_przew_o', 0)

Posted: **Wed May 10, 2023 7:56 pm**

Thank You very much kev1n.

Your advice works after minor changes to the other entries.
In admin mode I used word "test" without apostrophe - there was a mistake.

Now works fine.

In user mode must set access level for procedure

nuBuilder Forum

Trying to run a procedure from a button

Re: Trying to run a procedure from a button

Re: Trying to run a procedure from a button

Re: Trying to run a procedure from a button