If you mean, can you do so by formula – something like
IF(OrderConfirmed = TRUE,[Add 150 rows],[Do nothing])
– the answer is no, as Airtable has no scripting ability. However, you could probably accomplish this by way of a third-party middleware package, such as Zappier. Alternatively, you could also handle this procedurally – as in, write an employee procedure that instructs the user to take certain steps when the order is confirmed. The step you would likely have him or her perform would be this:
When the order is confirmed, mark and copy 150 [whatevers: blank lines, partial records, complete records] from an existing document or spreadsheet. Return to the Airtable base, place your cursor in the appropriate field, and press Ctrl-V to paste the blank/partial/whatever records into the base. You will be prompted as to whether you wish to expand the base. Say ‘yes.’
When you paste records beyond the end of a table, Airtable will expand the base, adding records as needed. However, in my limited exposure to this feature, it also seems to add them some times when they aren’t needed. I haven’t figured out what I was doing that caused things to turn out so strangely – admittedly, I was pasting 250 random dates into a linked record field keyed to a datestring, so I was creating new records in multiple tables. Still, I kept finding myself with 470+ records instead of the 250 I had intended…
