Counting Items in a Portal

[support]

Im a bit stuck on this one

See attached File... I have a portal that show "Alexandria" "Alpine White" etc I want a calculation that returns "Alexandria" = 2 "Alpine White" = 1 "Champagne Pearl" = 2 etc

These name "Alexandria" are dynamic

Any ideas

Thanks

Tim

Canberra

Australia

PotalScreenDump.tiff

[comment]

One way to do this is to create a self-join of the child table, matching on name and parent ID. Then count the related records (still in the child table) and show the result in the portal.

[support]

Hi Comment?

What count do I use...

and also

I may not have explained this correctly

in the attached sample Using Alexandria as the example .. Line 1 Alexandria = 1..... Line 2 Alexandria =2 and so on as more entries are made on Alexandria the count will continue so the 8th entry of Alexandria will show 8

The same is needed for each of the Colour groups (Alpine White, Champagne etc)

Sorry Hope this makes sense

Tim

[support]

Hey Thanks

IVE CRACKED IT

You've got to love Filemaker

Tim

[comment]

Line 1 Alexandria = 1..... Line 2 Alexandria =2 and so on as more entries are made on Alexandria the count will continue so the 8th entry of Alexandria will show 8

That's going to be more difficult - but still, if you define the self-join as:

Child::ParentID = Child 2::ParentID

AND

Child::Category = Child 2::Category

AND

Child::ChildID ≥ Child 2::ChildID

you can then count the Child 2::ChildID field (or any other field that cannot be empty) from the context of Child. Note that this assumes the portal shows the records in order of creation.