nuBuilder Forum

How to limit the number of lines in an iframe for a user ?

With the LIMIT clause?

https://www.w3schools.com/php/php_mysql ... _limit.asp

kev1n wrote:With the LIMIT clause?

https://www.w3schools.com/php/php_mysql ... _limit.asp

No, no ... There are 4 subforms-iframes on the main form.
 In the first subform, the readings of 6 sensors are entered in one line. On the other subforms, the difference of readings is 2-1,4-2,6-4 from the first subform, which are used for other calculations of your subform. I need to enter a single line on the first subform and prohibit further input on This subform.

kkm,

Can you show a screenshot?


Steven

I wasn't aware that you were talking about a subform...

To limit the number of rows in a subform, use this code in the beforeinsertrow event.
Replace sfObjID with your Subform Object ID.

https://wiki.nubuilder.cloud/ ... ustom_Code

kev1n wrote:I wasn't aware that you were talking about a subform...

To limit the number of rows in a subform, use this code in the beforeinsertrow event.

Code: Select all

if(nuSubformObject('sfObjID').rows.length = 1){nuCancel = true;}

Replace sfObjID with your Subform Object ID.

https://wiki.nubuilder.cloud/ ... ustom_Code

Where to find the event - beforeinsertrow?

Double-click the label of your subform. Then switch to the tab "Custom Code"

kev1n wrote:Double-click the label of your subform. Then switch to the tab "Custom Code"

Thanks !