Is there a way to create either a formula or an automation that can create a copy of a whole row in an Airtable base?
Our company has a back end that we created, customers order products and then we create stickers so items can be individually marked. If a customer orders 4-5lb carrots, the single line item reads
4-5lb carrots, Boy and Girl Farm
Then to create 4 individual stickers we have to copy the line item and manually insert a new row 4 times
1/4-5lb carrots, Boy and Girl Farm
2/4-5lb carrots, Boy and Girl Farm
3/4-5lb carrots, Boy and Girl Farm
4/4-5lb carrots, Boy and Girl Farm
This makes it so individual stickers can then be created.
Is there a way for me to create something that would multiple a whole row by the quantity?
I’m super new to data bases and am more likely than not using NOOB terminology or incorrect words for things, so let me know if I can elaborate anyway, I super appreciate it.