Having difficulties on counting numbers of orders with status X

Hello glide experts :slight_smile:

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” in the user table TAB2 which will display the total. I hope i’m clear enough i’m trying my best with english :slight_smile:

Thank you in advance for your help !

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.

Thank you Jeff, as always perfect :heart:

1 Like

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