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

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()) { 

} 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.


Re: #RECORD_ID# within a subform

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

Try the attached nuform.js. Replace yours with the one from the attachment and then log in again into nuBuilder.
(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.