Trigger

[DikkeHenk]

Hi,

Can an unstored calculationfield with an aggregate function in it (count) be used as a trigger for an auto-enter (calc.) field. The fields are in the same table.

So far I did not get it to work.

Henk

[Søren Dyhr]

Yes...

http://www.filemaker.com/help/FunctionsRef-34.html

...but keep in mind that unstored calc's only holds any value when a layout rendering have forced all its dependencies thru.

I'm guessing here, the problem is most likely a need to index a field for foreign key use ...this won't work, and especially not if you try to use a global field as trigger.

If this superficial diagnostics have any bearing, should you know that moving the "variable" keyvalue to the other side of the relation makes it work.

Take a look at my latest template, to see how it could be done - this is what we usually here calls Ugo's method for live summaries (named after our fellow developer )

http://fmforums.com/forum/attachment.php?attid/11227/

--sd

[comment]

IMHO the answer is no.

[Søren Dyhr]

Ah yes that correct, the argument needs to be a field (or a series of) But this seems to work:

Case(1;Get ( CurrentHostTimeStamp );Count ( aRepeat ))

...but I seems to remember that some kind of cautions were made when we turned to fm7

--sd

[comment]

I think that would work only because it is triggered by the field aRepeat itself - not by the count.