Success! And a little quirk I think either of you will be able to help with.
First - I figured it out! I added a “QTY” column in the two collections/sheets (Junk Material and Junk Items) and a “Total” column. The qty can be changed in the app through each material and item card. Then created another collection (called “quote”) and had one column each dedicated to pulling the sum from the total columns of each, then it’s added together in a total column in the quote collection.
My friend will be able to go through, click on each item and brought to a screen where they can either change the quantity or edit the numbers of that particular item (the different costs that help make it’s total the quantity multiplies with). The grande total shows up at the bottom of the main screen.
The quirk is, out of the two collections (Junk Materials and Junk Items), the “Junk Items” had a “+” automatically created allowing new items to be added, but the “Junk Materials” did not. The “worst case” fix is to create a new collection for Junk Material and I’m guess the “+” will be there, and then I would rebuild all of the extra pages… I’m hoping there’s an easy fix for adding the function though?
