I have a collection of “employees”, related to another collection called “types of employees” (Cast, Production, Creatives). In a summary page I want to display how many Cast Memebers, how many Production, etc.
Is it possible to do a “count if” kind of magic text?
Why not create a seperate colleciton for each and then just link them in the employees collection? That way you can get active counts for all plus can add custom conditions to each employee type
Your question is “Is it possible”. Yes you can do this. If it is a number field then you apply filters on it. That answers your question. You can add filters based on the collection field.