# Having difficulties on counting numbers of orders with status X

**URL:** <https://community.glideapps.com/t/having-difficulties-on-counting-numbers-of-orders-with-status-x/58440>\
**Category:** Ask for Help\
**Created:** [February 24, 2023, 8:08pm UTC](https://community.glideapps.com/t/having-difficulties-on-counting-numbers-of-orders-with-status-x/58440 "2023-02-24T20:08:56Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![IliTy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ility/32/53804_2.png) [@IliTy](https://community.glideapps.com/u/IliTy)\
**Post date:** [February 24, 2023, 8:08pm UTC](https://community.glideapps.com/t/having-difficulties-on-counting-numbers-of-orders-with-status-x/58440/1 "2023-02-24T20:08:56Z")

</div>

Hello glide experts 🙂

I have a problem on making a counter for the number of orders of a user that have the status “In progress”  
See in TAB1 there is all the orders with their status and i would like to match the number of orders “En attente” from user “[user@mail.com](mailto:user@mail.com)” in the user table TAB2 which will display the total. I hope i’m clear enough i’m trying my best with english 🙂

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/e/7e122f6919f0fd927046b153e0e77d03b0eba5b5.png)

Thank you in advance for your help !

---

<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:** [February 24, 2023, 8:21pm UTC](https://community.glideapps.com/t/having-difficulties-on-counting-numbers-of-orders-with-status-x/58440/2 "2023-02-24T20:21:31Z")

</div>

You will need to create a Template column in each table. In the User table, create a Template column that joins the word ‘En attente’ and the email column. In the Orders table, create a Template column that joins the Status and Utilisateur columns together. Then create a Relation in the user table that links the template column to the template column in the Orders table. Finally create a Rollup column that uses the relation to count the number of matches. That rollup column will be your counter.

---

<div class="post-metadata">

**Author:** ![IliTy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ility/32/53804_2.png) [@IliTy](https://community.glideapps.com/u/IliTy)\
**Post date:** [February 24, 2023, 8:47pm UTC](https://community.glideapps.com/t/having-difficulties-on-counting-numbers-of-orders-with-status-x/58440/3 "2023-02-24T20:47:20Z")

</div>

> [@Jeff\_Hager](#):
>
> he User table, create a Template column that joins the w

Thank you Jeff, as always perfect ❤

---

<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:** [February 25, 2023, 8:48pm UTC](https://community.glideapps.com/t/having-difficulties-on-counting-numbers-of-orders-with-status-x/58440/4 "2023-02-25T20:48:16Z")

</div>

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