Select items from a read only source sheet but send the results to a different sheet

The source sheet has around 10,000 items - the user selects say 100 items and adds a quantity for each and needs to write the results to a new sheet. I have the tables set up but the app is writing the quantity back to the source sheet. I need to leave the source sheet unchanged.
Is there a way to do this?

1 Like

Hey @PatFF

You’ll want to make use of the action that will “create a record in another table using values from this table” - or however it’s worded.

It allows you to create a record on the child table from the parent - or from any table to any other table really.

1 Like

Thank you for that suggestion and the link to the article.
I can see how that will work