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

[PatFF]

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?

[MultiTech]

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.

help.appsheet.com

Actions: The Essentials

Learn how to use actions to modify data and navigation in your app.

[PatFF · Accepted solution]

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