How can I make a dynamic list based on transactions?

[Jonas_Volny]

Hello!
What would be the most effective (resources-wise) to make a stock list like image attached?
I am thinking of making it based on transactions, that are referring to users and items.

Is there any naming to a scheme like this by which I could find more related posts?

Thank you for any tips.

[Kirk_Masden]

To be honest, this is a pretty difficult issue for me but I do have one thought about something that you might want to consider.

You have several tables and, if I understand correctly, making a dynamic list would involve combining them. In my own app building, I have found that there are situations where I prefer to keep everything in one table, then make that table function as separate tables using slices. I’ve written about that here:

App Design: Multiple tables vs. Single table + multiple slices Tips & Tricks 💡

One spreadsheet table per “entity” (a set of things in the real world) is the norm in AppSheet: Every entity that you define (Job, Employee, Building) should have its own table (or sheet) within the document that you are connecting to AppSheet. Put more simply, it is often the case that a “view” (UX) will have it’s own table. I think this is good standard practice for beginners but there are potential drawbacks. When, for example, I built a flashcard app with a separate table for each “s…

If one uses that strategy, it’s no longer necessary to “combine” separate tables – but just a matter of creating an additional slice. Please forgive me if my idea proves to be irrelevant in your case.

[Suvrutt_Gurjar]

Your query is somewhat broad based. The below response is just as a reference and I would request you to infer / evaluate further from the below reference / sample shared to see if it matches your exact requirement. This is so because you will definitely need to tweak the below sample to make it match your exact requirement.

Please take a look at the “Order Capture” sample app below.

The equivalents of your tables and tables in the sample app with some additional points to consider are given below

https://www.appsheet.com/templates/An-app-for-managing-customers-products-and-orders?appGuidString=8...