I have a setup where one main record (like a purchase order) is linked to multiple related rows (like order items), each stored in a separate table.
I’m trying to create a “Duplicate” button that would:
Duplicate the main order (this part works — a new row is added).
Then duplicate all related items and link them to the new order.
The challenge is that currently, I can only duplicate the related rows one at a time, using a button in a list. But I’d like to avoid having users click 10+ times to copy each item manually.
Is there a way to duplicate multiple related rows with a single button click (without using the Glide API)?
I’m on the Maker plan, so API access is not available for me.