Page 1 of 1

#RECORD_ID# within a subform

Unread postPosted: Sun Jul 04, 2021 7:40 pm
by nickrth
Hi brains trust,

I have a form with a subform, and I'm trying to use the subform's record id to drive a SQL statement for a select object. But #RECORD_ID# appears to return the same value for all rows in the subform.

In the screen shots below I have done a basic test to just return the record id for the given row in the select object. This is the sql code on the relevant select object:
Code: Select all
SELECT '#RECORD_ID#', '#RECORD_ID#'


And it renders the record id of the first row in the subform, for every row in the subform.

If I change it to a display object with the exact same SQL as above, it shows different IDs per record, as I'd expect.

Can anyone see what I'm doing wrong?

Thanks in advance.

Re: #RECORD_ID# within a subform

Unread postPosted: Mon Jul 05, 2021 6:29 pm
by nac
hello nickrth

The function nuSubformRowId(this) will return the PK value for a row in a subform. I use the code below with an onclick button in each row to open a modal form for the specific subform record.

Code: Select all
if (nuIsSaved()) { 
    nuPopup('606b1cefbada7f2',nuSubformRowId(this))   

} else  { 
    nuMessage(["Please save any changes before leaving this form."])
   
}


You could set a hash cookie using the value returned by nuSubformRowId(this) to feed into your SQL statement.

Neil

Re: #RECORD_ID# within a subform

Unread postPosted: Mon Jul 05, 2021 9:17 pm
by kev1n
Hi,

Try the attached nuform.js. Replace yours with the one from the attachment and then log in again into nuBuilder.

nuform.zip
(25.73 KiB) Downloaded 32 times

Re: #RECORD_ID# within a subform

Unread postPosted: Tue Jul 06, 2021 5:23 pm
by nickrth
That works perfectly kev1n! Thank you so much for your prompt help, I really appreciated it.

Legend!!