Calculation or summary field?

[Greg Mills]

I wonder if antone would be able to give me a couple of pointers on FMP. I

[David Kachel]

Set up 3 calc fields in your Events table:

Field One= If(textField = "telephone calls", 1,0)

Field Two= If(textField = "call-outs", 1,0)

Field Three= If(textField = "emails", 1,0)

(This can be shorted to: textField = "telephone calls" instead of the full IF clause, but it makes for easier understanding later if you use the full clause.)

Be sure to set the result type to "Number".

Then add calc fields in your main table:

CalcOne= Sum(relationship::Field One), etc.

[David Kachel]

Oops, forgot this part:

>>Also, is it easy to get a field set up to display an icon for a value in a list view, rather than the text string? So I can display an image of a telephone for instance, if the field has the text

[-Queue-]

Note that "GetRepetition( containerfield, 1 )" is redundant for "containerfield" in a single repetition calculation result.