Browse screen

[johan]

Max,

I use my #browseTable# in a lookup on a subform (http://forums.nubuilder.cloud/viewtopic.p ... 931#p11931).
When I add your suggestion I always get message 'not available') and go back to the browsescreen of the form.
I think I have to add some JavaScript on my subform.

Johan

[massiws]

Johan, sorry but I made an error in my previous post: the code must be placed in Custom Code > Before Open (I correct it now).

[johan]

Max,

I've tried before open but this doesn't work. (or I do something wrong)
I don't open the form Books (go to editscreen). I only use the browsescreen of the form BOOKS to choose books in my lookup.

In that browsescreen (BOOKS) i have a column available / not available.
What I wan't is an alert when user selects a book that is not available.

Johan

[johan]

Max,

I've created a function to check if the field in column actief = 2

Code: Select all

function checkfree(pthis){
PRE       = pthis.name.substring(0,13);

    if (Number(document.getElementById(PRE+'res_actief').value )= '2'){
    alert('Dit boek is niet beschikbaar in deze periode');
    }}

I want to run it when lookup is changed. When I put checkfree(this) in the all tab - onchange of the lookup nothing happens. Any idea how I can activate it when lookup is changed.
Thanks
Johan

[massiws]

Johan, have you tried to insert that function in Javascript field in Lookup tab?

[johan]

Max,
I've tried several options but all of them giving errors.

Tried to just paste the code above (nothing happens),
refer to it with nuSreen.checkfree(this)

ScreenShot002.png

and edit the code to

Code: Select all

if (Number(nuGetRow('res_actief').value )= '2'){
  alert('Dit boek is niet beschikbaar in deze periode');
   }

With last code I get error

ScreenShot001.png

Any idea?

Johan

[massiws]

Johan, try this:

Code: Select all

var fieldID = nuGetRow() + res_actief;
if ( $('#'+fieldID).val() == '2') {
    alert('Dit boek is niet beschikbaar in deze periode');
};

[johan]

Max,

It works with this code:

Code: Select all

var fieldID = nuGetRow() + 'res_actief';
if ( $('#'+fieldID).val() == '2') {
    alert('Dit boek is niet beschikbaar in deze periode');
};

Thanks a lot for your help.
Johan

[johan]

Max,

Still have 1 question

Now I get the alert but if i click on ok of the alert the book is still selected.
How can I prevent to select that book in my lookup?

johan

[massiws]

Johan, add this after the alert():

Code: Select all

window.history.go(-1);

Max