Dynamic portal record count calculation

[gerg nnud]

Hello fellow Filemakers

 

I have been trying to come up with a dynamic count calculation for a number of portals all relating to the one table in vs 11.

 

These portals are navigated to via tabs so I do have a reference for the count relationship by way of the tab's unique object name.

 

Now this is very easy if I create a count calculation field for each portal but not so easy if I try to create the one count calculation using Case.

 

It all works if I have one level of tabs but I have nested tabs and I can't figure out how to solve this one.

 

So this is an example calculation for the field "Count".

 

Case (

GetLayoutObjectAttribute ( "Tab A1" ; "IsFrontTabPanel"  ); //nested in Tab A

Count(portalrelationshipA1::fieldnameA1) ;

GetLayoutObjectAttribute ( "Tab A2" ; "IsFrontTabPanel"  ); //nested in Tab A

Count(portalrelationshipA2::fieldnameA2) ;

GetLayoutObjectAttribute ( "Tab B1" ; "IsFrontTabPanel"  ); //nested in Tab B

Count(portalrelationshipB1::fieldnameB1) ;

GetLayoutObjectAttribute ( "Tab B2" ; "IsFrontTabPanel"  ); //nested in Tab B

Count(portalrelationshipB2::fieldnameB2) ;

GetLayoutObjectAttribute ( "Tab C1" ; "IsFrontTabPanel"  ); //nested in Tab C

Count(portalrelationshipC1::fieldnameC1) ;

GetLayoutObjectAttribute ( "Tab C2" ; "IsFrontTabPanel"  ); //nested in Tab C

Count(portalrelationshipC2::fieldnameC2) ;

"" )

 

The reasons behind wanting to approach the problem this way is that;

a. I have many tables requiring this functionality so I want to keep the number of fields down in each table.

b. The case calculation is easily expandable as I continue developing the overall solution.

 

At the moment the calculation only returns the Tab A - Tab A1 or A2 counts after navigating to Tab B - Tab B1 or B2, Tab C - Tab C1 or C2 (depending on which Tab A - nested tab is front). If I navigate to say Tab A3 with no reference in the calculation then Tab B1 and B2 start to work and so on.

 

Anyone know how I can more precisely identify the nested tab object so that the calculation works? Script trigger maybe?

 

Attached is an example file that helps to clarify what I am referring to. Hope someone can help.

example_portalcount.fp7.zip

[Lee Smith]

Hi Gerg, and welcome to the FMForums,

 

I moved your topic from "FileMaker Pro 11" to "Calculation Engine (Define Fields)”.Because, the General Topic areas are reserved for the discussion of the Tools, Functions and Features that were new with that Release of FileMaker, and not for asking how to questions.

 

 

If you have any questions about this action, please feel free to contact me via Private Message.

 

Lee

[bruceR]

No need for that complexity.

 

Just add a summary field to the table and display it.

example_portalcountBFR.fp7.zip

[gerg nnud]

I am feeling pretty dumb right now. Such a simple solution.

 

Thanks for this Bruce and thanks for the quick response.