summary of a field that is shown via portal

[Mark Reed]

I have a table called routines that is linked to a table called effects.

The effects table has a field called TIMEINMINUTES

on the layout for routines, I have a portal where you can pick effects (basically assigning them to the routine)

I would like to get a total on the timeinminutes but when I create a summary in the effects table and put it on the routines layout, I only get the data from the first record in the portal.

For example:

Routine A has Effect 1 and Effect 2 listed via portal.

Effect 1 has a time of 10 mins and Effect 2 has a time of 15 mins.

I created a summary field in EFFECTS and put that field on the routines table, but it only shows 10 mins.

Im not sure how to get this working.

Any help or example templates would be appreicated!

[comment]

Ahm, if the field is placed outside the portal, it should show the summary value for the related set. You could also use a calculation field in the Routines table, but really, the summary field from Effects should work - so check your implementation.

[Søren Dyhr]

But there is a reluctance in refreshing when showing a summary field a relation away, we need an argument for using a summary field instead of an aggregate field looking over the relations def.?

(The hint here is usually scope... )

--sd

[comment]

But there is a reluctance in refreshing when showing a summary field a relation away

I don't think that's an issue in recent versions.

[Mark Reed]

thats exactly the issue... it is not refreshing unless I move out of the record and back again.

The lack of refresh had me thinking it was only showing the first portal timeinminutes.

Is there a way to get it to refresh in realtime?

[comment]

it is not refreshing unless I move out of the record and back again.

It should refresh when you commit the record (pres Enter or click outside of any field/portal).

As noted earlier, you can use a calculation field defined in the Routines table (result is Number) =

Sum ( Effects::TIMEINMINUTES )

instead.