generate-rows
Like match rows, but requires a parameter that determines the number of data rows (rows excluding the header) to be generated on this sheet.
pebblestream:generate-rows(100)This sheet's last row will be dragged down by the runtime until there are 100 data rows in total. Note that the header row is not included in this count.
An additional feature of generate rows is the ability to reference a cell and use the numeric value in that cell as its parameter
pebblestream:generate-rows("Payment Periods!A2")This PebbleScript will generate as many rows as the numeric value in cell "Payment Periods!A2".
When passing the reference as a parameter, it is interpreted as an absolute reference. There is no need to use the $ syntax.
Updated 4 days ago