Button Object in subform

[ruiascensao]

Hi,

I have a button in a subform that would open that record in an edit screen.

open.jpg

button.jpg

I'm using the hash variable #SUBFORM_RECORD_ID# .
But when I click in the button it opens the form but with empty fields.

Could you please advise?

Thank you.

[admin]

Rui,

Has that subform record previously been saved? Because it won't have an Primary Key until it does.

Steven

[ruiascensao]

Hi Steven,

Yes, I have a record saved in the subform (goodin_subform).

Thank you.

[admin]

Rui,

Does it work with the record id hardcoded?

Steven

[ruiascensao]

Hi Steven,

Yes, it does work with the id hardcoded but does not with the hash variable #SUBFORM_RECORD_ID#.

[admin]

rui,

Come to think of it #SUBFORM_RECORD_ID# is used by Display Objects or Lookup Objects not Javascript.

To get the ID you can use this JavaScript function http://wiki.nubuilder.net/index.php/Jav ... 28pThis.29

You can use nuRowPrefix(this) or nuRowNumber(this) to find the row number.

eg.

Code: Select all

$('#' + nuRowPrefix(this) + '_nuPrimaryKey').val()

Steven

[steve foley]

This looks like it may solve the problem i posted, but I have no idea where to put this code or what to put into the 'Record ID" field on the button.

Can someone point me in the right direction?

[admin]

steve foley,

Try this.. http://wiki.nubuilder.net/index.php/Jav ... tRow.28.29

Steven

[steve foley]

Unfortunately, I still have no idea what to do with this code, or where to put it.

[admin]

steve,

You put can call a JavaScript function on a button here..

Capture2.PNG

And create the function here..

Capture3.PNG

Code: Select all

function myFunction(){

    var id = $('#' + nuRowPrefix(this) + '_nuPrimaryKey').val();
    
    nuOpenFormInFrame('55494eebbb1c5d0', id);   //**** you need to find out the Form's ID in the database

}

Steven