Repeating Field Calculation

Hi

I can't remember how can I do this.... (FM9A)

I have 8 fields set for phone numbers, fax or e-mail, with no specific
order, phone1,phone2,phone3,phone4,phone5.....

I want to create a single repeating[8] calculation field (Container) to
display a E-Mail Icon when PatternCount [at] > 0 .....

But how the calculation would look like ??

I can't see how..... since I have 8 fields and One Repeating Calculation
Field

The calculation will put the result in the first repeating field... will not
set the second repaeting if phone2 have " [at] "

Case(PatternCount ( Phone1; " [at] ") ? 1; GetRepetition ( g_Dessin; 15);
PatternCount ( Phone2; " [at] ") ? 1; GetRepetition ( g_Dessin; 15); and so for
the 8 Phones fields
*** The getRepetition #15 is the E-Mail Icon Store in a Global field ***


The result will be only display on the 1st of the repeating field.. or maybe
all of them.....

How can I only show the icon in the appropriate repeating field ??

Thank you

JF Fortier
bizouman_takethisout [ Fr, 02 November 2007 03:10 ] [ ID #1860853 ]

Re: Repeating Field Calculation

In article <hHvWi.5970$D9.15860 [at] wagner.videotron.net>, "JF"
<bizouman_takethisout [at] hotmail.com> wrote:

> Hi
>
> I can't remember how can I do this.... (FM9A)
>
> I have 8 fields set for phone numbers, fax or e-mail, with no specific
> order, phone1,phone2,phone3,phone4,phone5.....
>
> I want to create a single repeating[8] calculation field (Container) to
> display a E-Mail Icon when PatternCount [at] > 0 .....
>
> But how the calculation would look like ??
>
> I can't see how..... since I have 8 fields and One Repeating Calculation
> Field
>
> The calculation will put the result in the first repeating field... will not
> set the second repaeting if phone2 have " [at] "
>
> Case(PatternCount ( Phone1; " [at] ") ? 1; GetRepetition ( g_Dessin; 15);
> PatternCount ( Phone2; " [at] ") ? 1; GetRepetition ( g_Dessin; 15); and so for
> the 8 Phones fields
> *** The getRepetition #15 is the E-Mail Icon Store in a Global field ***
>
>
> The result will be only display on the 1st of the repeating field.. or maybe
> all of them.....
>
> How can I only show the icon in the appropriate repeating field ??
>
> Thank you
>
> JF Fortier

Don't waste your time with Repeating fields. Since you've got 8 fields
you want tot test, it's much easier to simply create 8 matching
Calculation fields.









Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
Helpful Harry [ Fr, 02 November 2007 06:09 ] [ ID #1860854 ]
Datenbanken » comp.databases.filemaker » Repeating Field Calculation

Vorheriges Thema: how do I unlock a locked header?
Nächstes Thema: getting values tied to a max and min calculation