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
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.