Detect lookup onchange Topic is solved

[Giu]

Hi, based on the selection done on a lookup, I have to retrieve data from database related to the lookup selection, show it on screen, and use it on my form save. I guess I can use the Display object, but the query depends on the selection of the lookup and starts empty and can change and display must be refreshed.

There are some nuWay to do this? or just capture with javascript the lookup onchange, and fire a procedure with nuRunHiddenPhp+nuAddJavascript combo?

[kev1n]

If the data is part of the lookup form, you can use nuSetFormValue().

Alternatively, you can use a Display object. After the lookup value is changed, call nuRefreshDisplayObject() to update the Display object accordingly.

[Giu]

If the data is part of the lookup form, you can use nuSetFormValue().

Interesting, but is not shown in the lookup browse if this detail is important.

Alternatively, you can use a Display object. After the lookup value is changed, call nuRefreshDisplayObject() to update the Display object accordingly.

Yes, I noticed about this JS function 2 minutes ago, but is not working at all to me.
I have this SQL on my 'prm_negras' display object

Code: Select all

SELECT
 fichas_prm.prm

FROM
    fichas_prm

WHERE
    ((fichas_prm.usuario = '#oponente#'))

and my 'oponente' lookup object CC looks like this

uOrZ2lTVIZ.png

No errors in web console at all. I'm doing correctly?

[kev1n]

Add the JS code in the LUJS (Lookup JS) event of the lookup object.

[Giu]

Perfect!! Thanks.

(I just discovered the thanks and Accept answer buttons )