Very very new to glide

[danz0l99]

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.

[Jeff_Hager]

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.

[danz0l99]

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 ?

[Jeff_Hager]

No. Logic and “code” is handled in the table.

[danz0l99]

Ah right, at least i dont have to keep looking for a component now i know that, thank you very much for the response.