Ty for the help.
Users participate in a “Crypto Fantasy League” by creating portfolios composed of crypto tokens.
Users can view available tokens and use a buy/sell button for each token to open an edit screen.
This screen includes a number entry field where they can specify the amount of tokens to buy or sell.
Every submitted transaction creates a row in the “Orders” table (Glide Table) with details such as “User ID, Token ID, and Quantity Transacted” (as shown in the attached image).
My question is:
Is it possible, by creating a relationship between the “Orders” and “Users” tables, or in some other way, to have all the portfolio-related information in the “Users” table?
For example, if a user has made three transactions:
- Bought +10 tokens of A
- Bought +10 tokens of B
- Sold -5 tokens of A
I would like the “Users” table to reflect that the user owns 5 tokens of A and 10 tokens of B.
Thank you very much for your help!