# Very very new to glide

**URL:** <https://community.glideapps.com/t/very-very-new-to-glide/72105>\
**Category:** Ask for Help\
**Created:** [March 27, 2024, 8:09pm UTC](https://community.glideapps.com/t/very-very-new-to-glide/72105 "2024-03-27T20:09:15Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![danz0l99](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/danz0l99/32/72900_2.png) [@danz0l99](https://community.glideapps.com/u/danz0l99)\
**Post date:** [March 27, 2024, 8:09pm UTC](https://community.glideapps.com/t/very-very-new-to-glide/72105/1 "2024-03-27T20:09:15Z")

</div>

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.

 ![Screenshot_3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/d/dd4b556ba32da2bbc5941812a84bbdf85834c29c.jpeg)

these are displayed on the purchased landing page using a filter

 ![Screenshot_4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/5/a5cbd7812219b69bc0edfec0065102e75a49dc62.png)

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.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [March 27, 2024, 9:08pm UTC](https://community.glideapps.com/t/very-very-new-to-glide/72105/2 "2024-03-27T21:08:52Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![danz0l99](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/danz0l99/32/72900_2.png) [@danz0l99](https://community.glideapps.com/u/danz0l99)\
**Post date:** [March 28, 2024, 8:18am UTC](https://community.glideapps.com/t/very-very-new-to-glide/72105/3 "2024-03-28T08:18:17Z")

</div>

Ok that worked perfectly, thank you so much.

 ![Screenshot_5](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/9/b9f5c9973bb27b36fc283241ed98c25b5213aa2f.jpeg)

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 ?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [March 28, 2024, 11:56am UTC](https://community.glideapps.com/t/very-very-new-to-glide/72105/4 "2024-03-28T11:56:43Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![danz0l99](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/danz0l99/32/72900_2.png) [@danz0l99](https://community.glideapps.com/u/danz0l99)\
**Post date:** [March 28, 2024, 12:36pm UTC](https://community.glideapps.com/t/very-very-new-to-glide/72105/5 "2024-03-28T12:36:03Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [April 4, 2024, 12:36pm UTC](https://community.glideapps.com/t/very-very-new-to-glide/72105/6 "2024-04-04T12:36:26Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
