First thought is do you really need a new spreadsheet row for each row/bed combo? Could you perhaps have all the beds for each row, be in one spreadsheet row? If there’s not much data specific to each bed, perhaps you could do bed data as repeated columns. Such as your spread sheet columns being such as:
Row | Bed 1 plant type | Bed 1 seeded date | Bed 1 other info | Bed 2 plant type | Bed 2 seeded date | Bed 2 other info | Bed 3…
This would be a better way to handle the data with fewer rows and update cost, if it’s possible for you.
To do directly what you’re asking, adding a bunch of spreadsheet rows from inputting number of beds for that row… I think you have a few options, none of which super simple. Could use Make (formerly Intergromat), or a custom action that adds each row. Your action as far as I know how to build it, would be a little tedious to build if it’s to allow a large number of beds.
Here’s a screen to add… just put row letter, and number of beds.
You’d have this create data, where the user specific columns take the input, and create template columns for each row-bed index (I only went up to 4… you’d need to go up to however many is allowed.)
The basic action would look like this… but, you need some control over how many rows are added.
The nicer for user setup would be to create a bunch of conditions, to know how many rows to add.
Alternatively you could put wait conditions with very short wait periods, to break the action when you get to the right number added. This would result in a red notification presented to the user… but you can make it say “complete” rather than error, so it looks alright.
I think that gives you a few options to do what you want… though I’d really push for the first option of just added all the data for multiple beds into the same row of data, if that’s possible. It’ll reduce the cost of the app significantly in terms of updates and row usage.
Hope that helps!