Hey, I am trying to build a project regarding tracking of expenses, thus far I've done it using google sheets but I'm trying now using Xano and Retool.
my three tables are: Categories: id name Locations: id name category_id Transactions: id amount date location_id
my main flow will look this:
open the app -> input amount -> input location from a list -> input date of transaction -> submit
I will have a page to input a new location and a new category if they are not already there.
and I want to be able to have a few views for the data:
- table view of all transactions (exists - get api call for transactions table)
- table view of amount spent per location (exists - get api call for transactions table joined with location and using eval to add the locations.name to the returned values)
- table view of amount spent per category (doesn't exist - need help here)
I'm sure I'm not doing it correctly but what my thought was to somehow join the transactions and locations tables and include the location.category_id and to join on that with the categories id.
not sure if I even made myself clear so let me know!
Thanks :)