In my app, I want to create a tab for generating reports for my products table to know amount spent on product purchased and also on the order table to know the amount of revenue generated from products sold.
I created my app using JSON and trebuchet, but when I checkout order, it doesn’t remove the quantity from the amount of products available, what can I do?
On my profile page also, I want to be able to view the location like the one on the screenshot.
This is the app link.
Can you show us how you’re setting up this step, plus the data structure?
Yes, I can.
I have already created the profile page for editing and also for sign up when the users sign in, so I the database can collect the information along with the location tool which at the moment, displays the coordinates.
@Bolufmi Screenshots of your app?
We would need to see some screenshots of your actual flow, or a video, to have a better context. Thank you.
@Atom @ThinhDinh
I have sent the screenshots from the app. Please, what can i do?
Why would you need so many rows in your “Order Helper” table? What function does it serve?
Can you explain the flow when the user creates a new order?
The reason as to why there are so many columns in the “order helper” table is because I used the JSON and trebuchet method and also separated the data like the ID, name of the product, quantity, and price.
When a user creates an order, the user selects the products from the product tab where they add to order, then moves to the order tab and checkout. After checking out, it is registered in the order table, and the user can view the orders linked to their signed-in email, but the admin can view all orders and who placed them.
What I want to do on the report page is to be able to see the total amount generated from the sales, the total amount from the products purchased (the inventory) and other expenses, which are on the expense tab, and then calculate for profit or loss.
In the pictures you shared, what specific computed columns are not working as expected?
Building out the reporting functionality is a whole different beast.
