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
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)