Wow loving glide, so much more the way i work myself in my own head.
However i have a question.
I have a checkbox next to my items when displayed that allow to show whether this has been purchased or not. What i want to do to do a sum of the rows that have had that check box checked.
these are displayed on the purchased landing page using a filter
Wnat i want is a sum of these items and only these items, showing how much has been spent on purchased items, displayed on this landing page.
I used a rollup on other sections for categories etc but i cant seem to do a query with that ?
Any help would be very very appreciated.
Use a Query column to create a query of rows you want to sum. Then create a Rollup column that uses the query to sum the amounts from the query.
Ok that worked perfectly, thank you so much.
However i have a further question if i may. Doing it this way seems cumbersome and with a finance app there would be many columns to create. Is there no way of doing a code inside of a display element with say something like
SELECT FROM Items, SUM(IF(Purchased, Price, 0))
I can just see things getting complex using columns to achieve all this or is that the no code way ?
No. Logic and “code” is handled in the table.
Ah right, at least i dont have to keep looking for a component now i know that, thank you very much for the response.
