# Count stuff, but not via the Data Editor

**URL:** <https://community.glideapps.com/t/count-stuff-but-not-via-the-data-editor/14127>\
**Category:** Ask for Help\
**Created:** [August 18, 2020, 7:38am UTC](https://community.glideapps.com/t/count-stuff-but-not-via-the-data-editor/14127 "2020-08-18T07:38:42Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![caffinho](https://avatars.discourse-cdn.com/v4/letter/c/ac8455/32.png) [@caffinho](https://community.glideapps.com/u/caffinho)\
**Post date:** [August 18, 2020, 7:38am UTC](https://community.glideapps.com/t/count-stuff-but-not-via-the-data-editor/14127/1 "2020-08-18T07:38:42Z")

</div>

Hello,

let’s say I have 100 orders in my data base, some are “processing”, some or “finished”.

Is there a way to count the number of “processing” order… without doing complicated work in the data editor?

I am thinking about a counter Component on which I could select my orders table, set up some filters on some columns (more than 1 would be awesome) and it would count how many orders respect the filters.

Thanks  
Antoine

---

<div class="post-metadata">

**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\
**Post date:** [August 18, 2020, 9:06am UTC](https://community.glideapps.com/t/count-stuff-but-not-via-the-data-editor/14127/2 "2020-08-18T09:06:42Z")

</div>

Something like this, but for orders?

[https://benchmarking.glideapp.io/](https://benchmarking.glideapp.io/)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b38f54fda8968e649902f687f4124a772d70098d.png)

In my Orders Management [template](https://www.glideapps.com/templates/1B625nbHOTMx07CCHGF2-template), I show # Units by Order Status.

---

<div class="post-metadata">

**Author:** ![caffinho](https://avatars.discourse-cdn.com/v4/letter/c/ac8455/32.png) [@caffinho](https://community.glideapps.com/u/caffinho)\
**Post date:** [August 18, 2020, 9:23am UTC](https://community.glideapps.com/t/count-stuff-but-not-via-the-data-editor/14127/3 "2020-08-18T09:23:07Z")

</div>

Thanks for you answer @sardamit 🙂 no, not like your salary template.

Maybe like your ordre management template but I can’t see anything when I try to preview it.

Let’s say I want to count the number of orders “processing”, how would you count this without counts it via a rollup in the data editor ?

I wish there cas a component allowing to

1. select a table
2. apply filters on the table (for exemple, status = processing)
3. and return the number of items respecting the filters.

does this exist in any way ?

---

<div class="post-metadata">

**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\
**Post date:** [August 18, 2020, 9:39am UTC](https://community.glideapps.com/t/count-stuff-but-not-via-the-data-editor/14127/4 "2020-08-18T09:39:28Z")

</div>

The video on the template page contains preview emails.

The video will give you enough idea about how this information is displayed.

> [@caffinho](#):
>
> I wish there cas a component allowing to
> 
> 1. select a table
> 2. apply filters on the table (for exemple, status = processing)
> 3. and return the number of items respecting the filters.

The Salary Benchmarking app does exactly that. Except, it has a predefined table in the form of a sheet these filters apply to.

---

<div class="post-metadata">

**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\
**Post date:** [August 18, 2020, 9:40am UTC](https://community.glideapps.com/t/count-stuff-but-not-via-the-data-editor/14127/5 "2020-08-18T09:40:09Z")

</div>

The preview emails are:  
[manager1@demo.com](mailto:manager1@demo.com)  
[manager2@demo.com](mailto:manager2@demo.com)

---

<div class="post-metadata">

**Author:** ![caffinho](https://avatars.discourse-cdn.com/v4/letter/c/ac8455/32.png) [@caffinho](https://community.glideapps.com/u/caffinho)\
**Post date:** [August 18, 2020, 10:26am UTC](https://community.glideapps.com/t/count-stuff-but-not-via-the-data-editor/14127/6 "2020-08-18T10:26:03Z")

</div>

I don’t get it @sardamit , where in your app do you display for exemple le number of order packed ? (apart from your graph).

When i click on Packed, I see 3 orders.  
If on the top of this screen I want to write “There are 3 orders packed”, how should I do it without changing anything in the data editor ?

---

<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:** [August 18, 2020, 12:29pm UTC](https://community.glideapps.com/t/count-stuff-but-not-via-the-data-editor/14127/7 "2020-08-18T12:29:55Z")

</div>

In the sheet used for the tab where you want to display the value, you will need template column with the value of ‘Processed’. Use the template to create a multiple relation to the Orders sheet. Then create a rollup column to count count the number or rows with that status.

---

<div class="post-metadata">

**Author:** ![caffinho](https://avatars.discourse-cdn.com/v4/letter/c/ac8455/32.png) [@caffinho](https://community.glideapps.com/u/caffinho)\
**Post date:** [August 18, 2020, 2:37pm UTC](https://community.glideapps.com/t/count-stuff-but-not-via-the-data-editor/14127/8 "2020-08-18T14:37:37Z")

</div>

Thanks @Jeff_Hager,

what I usually do when I have several conditions to test is

1. create a IF =\> THEN =\> ELSE column for each condition I need to test (one condition could be “processing”, another could be “\<100$”)
2. create a TEMPLATE column combining all these columns
3. create a last IF =\> THEN =\> ELSE column to check what is in my TEMPLATE column  
(for exemple if there is exactly “Processing \<100$” in the TEMPLATE column, then I rewrite “Processing \<100$”. If not, I write nothin.)
4. create a ROLL UP count on my final IF =\> THEN =\> ELSE column how many “Processing \<100$” I have.

It’s not exactly what you are advising but kind of the same data editor nightmare.  
I will try your method.

But maybe one day the Count component I am talking about will exist.

Thanks  
Antoine