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
Hi
Thank you for that suggestion and the link to the article.
I can see how that will work
Pat
2 Likes