Repeating fields display

Repeating fields display

am 10.01.2008 18:46:24 von amy_hui

How can I display all repetitions of a repeating field when using the
carrots in the layout mode?
<>

Re: Repeating fields display

am 10.01.2008 19:47:22 von Lynn Allen

On 2008-01-10 09:46:24 -0800, amy_hui@sccoe.org said:

> How can I display all repetitions of a repeating field when using the
> carrots in the layout mode?
> <>

Wow, I had a vision there of long orange root vegetables...

Merge fields contained in carats won't display repeating fields, as you
can see when you Insert Merge field on the layout. There is no place to
specify a repetition in the dialog box.

If you want a non-enterable repeating field on the layout, go to
Field/Control>Behavior and set it not to be enterable in the Browse
mode. Or make a calc field that shows all the repeat data and put that
on the layout. If you want empty repeats to slide up, the calc is the
way to go.
--
Lynn Allen
--
www.semiotics.com
Member Filemaker Business Alliance
Long Beach, CA

Re: Repeating fields display

am 10.01.2008 21:35:51 von amy_hui

Thanks for the input. I'm aware of the other two options but
specifically wanted it in the "carats" so it can align with other text
in a paragraph. I am basically a user of a poorly designed database
that needs fixes once in a while, not a designer. Was hoping there was
a quick fix.

On Jan 10, 10:47=A0am, Lynn Allen wrote:
> On 2008-01-10 09:46:24 -0800, amy_...@sccoe.org said:
>
> > How can I display all repetitions of a repeating field when using the
> > carrots in the layout mode?
> > <>
>
> Wow, I had a vision there of long orange root vegetables...
>
> Merge fields contained in carats won't display repeating fields, as you
> can see when you Insert Merge field on the layout. There is no place to
> specify a repetition in the dialog box.
>
> If you want a non-enterable repeating field on the layout, go to
> Field/Control>Behavior and set it not to be enterable in the Browse
> mode. =A0Or make a calc field that shows all the repeat data and put that
> on the layout. If you want empty repeats to slide up, the calc is the
> way to go.
> --
> Lynn Allen
> --www.semiotics.com
> Member Filemaker Business Alliance
> Long Beach, CA

Re: Repeating fields display

am 11.01.2008 06:09:54 von Helpful Harry

In article
<3c42f100-983d-4268-9d19-24891083309c@d21g2000prf.googlegroups.com>,
amy_hui@sccoe.org wrote:

> Thanks for the input. I'm aware of the other two options but
> specifically wanted it in the "carats" so it can align with other text
> in a paragraph. I am basically a user of a poorly designed database
> that needs fixes once in a while, not a designer. Was hoping there was
> a quick fix.

It is a fairly quick fix. :o)

As Lynn said, the best way is to create a new Calculation field that
pulls all the repeating values into one row (separated by commas,
spaces or tabs) or one column (separated by returns).
ie.
ExRepeatField Calculation, Text Result, Unstored
= GetRepetition(RepeatField, 1)

& If (IsEmpty(GetRepetition(RepeatField, 2); "";
", " & GetRepetition(RepeatingField, 2))

& If (IsEmpty(GetRepetition(RepeatField, 3); "";
", " & GetRepetition(RepeatingField, 3))

& If (IsEmpty(GetRepetition(RepeatField, 4); "";
", " & GetRepetition(RepeatingField, 4))

& If (IsEmpty(GetRepetition(RepeatField, 5); "";
", " & GetRepetition(RepeatingField, 5))

etc. for as many repeats as the field has.

Then use this new field as the Merge field instead of the original
Repeating one.


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

Re: Repeating fields display

am 11.01.2008 16:42:38 von ursus.kirk

Harry,

For our newer versions we have the function LIST. List(MyField) would return
all repeating-values for the field in the currend record.

Keep well, Ursus

"Helpful Harry" schreef in bericht
news:110120081809544318%helpful_harry@nom.de.plume.com...
> In article
> <3c42f100-983d-4268-9d19-24891083309c@d21g2000prf.googlegroups.com>,
> amy_hui@sccoe.org wrote:
>
>> Thanks for the input. I'm aware of the other two options but
>> specifically wanted it in the "carats" so it can align with other text
>> in a paragraph. I am basically a user of a poorly designed database
>> that needs fixes once in a while, not a designer. Was hoping there was
>> a quick fix.
>
> It is a fairly quick fix. :o)
>
> As Lynn said, the best way is to create a new Calculation field that
> pulls all the repeating values into one row (separated by commas,
> spaces or tabs) or one column (separated by returns).
> ie.
> ExRepeatField Calculation, Text Result, Unstored
> = GetRepetition(RepeatField, 1)
>
> & If (IsEmpty(GetRepetition(RepeatField, 2); "";
> ", " & GetRepetition(RepeatingField, 2))
>
> & If (IsEmpty(GetRepetition(RepeatField, 3); "";
> ", " & GetRepetition(RepeatingField, 3))
>
> & If (IsEmpty(GetRepetition(RepeatField, 4); "";
> ", " & GetRepetition(RepeatingField, 4))
>
> & If (IsEmpty(GetRepetition(RepeatField, 5); "";
> ", " & GetRepetition(RepeatingField, 5))
>
> etc. for as many repeats as the field has.
>
> Then use this new field as the Merge field instead of the original
> Repeating one.
>
>
> Helpful Harry
> Hopefully helping harassed humans happily handle handiwork hardships ;o)

Re: Repeating fields display

am 11.01.2008 21:07:19 von Helpful Harry

In article <47878e6d$0$82076$dbd49001@news.wanadoo.nl>, "Ursus"
wrote:

> Harry,
>
> For our newer versions we have the function LIST. List(MyField) would return
> all repeating-values for the field in the currend record.

Thanks. I don't remember if the original person said which version of
FileMaker they have, but that is definitely a much simpler calculation
if they do have a version with that function.

I haven't tried it, but in older versions you MIGHT be able to achieve
the same effect by creating a Relationship that links each record to
only itself, creating a Value List based on the Repeating field, and
then use the ValueListItems function in the Calculation field to
retrieve the data.


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

Re: Repeating fields display

am 14.01.2008 22:44:29 von Robert Chapman

They *will* display if you add the brackets yourself, like
<>
<>
etc
----- Original Message -----
From: amy_hui@sccoe.org
Newsgroups: comp.databases.filemaker
Sent: Thursday, January 10, 2008 6:46 PM
Subject: Repeating fields display


How can I display all repetitions of a repeating field when using the
carrots in the layout mode?
<>

Re: Repeating fields display

am 15.01.2008 01:04:43 von Helpful Harry

In article <1JQij.28741$ty.2682103@phobos.telenet-ops.be>, "Robben"
wrote:
>
> > How can I display all repetitions of a repeating field when using the
> > carrots in the layout mode?
> > <>
>
> They *will* display if you add the brackets yourself, like
> <>
> <>
> etc

That definitely doesn't work in FileMaker 5.5 (it simply displays it as
normal text, ie. "<>"), but might be worth a try in newer
versions.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

Re: Repeating fields display

am 15.01.2008 01:30:53 von Robert Chapman

It just works in FM9, no need to "try" :)
I didn't see a clue that anyone was still in 5.5...

"Helpful Harry" schreef in bericht
news:150120081304430401%helpful_harry@nom.de.plume.com...
> In article <1JQij.28741$ty.2682103@phobos.telenet-ops.be>, "Robben"
> wrote:
>
> That definitely doesn't work in FileMaker 5.5 (it simply displays it as
> normal text, ie. "<>"), but might be worth a try in newer
> versions.
>
> Helpful Harry
> Hopefully helping harassed humans happily handle handiwork hardships ;o)

Re: Repeating fields display

am 15.01.2008 10:44:50 von unknown

Post removed (X-No-Archive: yes)

Re: Repeating fields display

am 15.01.2008 20:56:26 von Helpful Harry

In article , Martin
Trautmann wrote:

> On Tue, 15 Jan 2008 13:04:43 +1300, Helpful Harry wrote:
> > That definitely doesn't work in FileMaker 5.5 (it simply displays it as
> > normal text, ie. "<>"), but might be worth a try in newer
> > versions.
>
> former ones had e.g. GetRepetion(fieldname,2). fieldname[1] works as
> fieldname, since 1 is the default.

Within a Calculation, the GetRepetition function works, but this guy is
trying to say that typing "<> as a Merge Field in a Text
block will give you the fifth repetition's data.

I don't know about newer versions of FileMaker, but in FileMaker 5.5
that simply doesn't work - it sees "fieldname[5]" as the entire name of
the field and since no field exists with that name it displays it as
normal text.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

Re: Repeating fields display

am 15.01.2008 21:19:03 von Robert Chapman

I'm not "trying" like you, here and elsewhere, pretending to know what I'm
talking about, but "stating as fact" with good reason and most easy to
prove...

You're sure good at making a terrible display of yourself...


"Helpful Harry" schreef in bericht
news:160120080856262129%helpful_harry@nom.de.plume.com...
> In article , Martin
> Trautmann wrote:
>
but this guy is
> trying to say that typing "<> as a Merge Field in a Text
> block will give you the fifth repetition's data.
>

Re: Repeating fields display

am 15.01.2008 21:51:47 von Howard Schlossberg

Helpful Harry wrote:
> In article , Martin
> Trautmann wrote:
>
>> On Tue, 15 Jan 2008 13:04:43 +1300, Helpful Harry wrote:
>>> That definitely doesn't work in FileMaker 5.5 (it simply displays it as
>>> normal text, ie. "<>"), but might be worth a try in newer
>>> versions.
>> former ones had e.g. GetRepetion(fieldname,2). fieldname[1] works as
>> fieldname, since 1 is the default.
>
> Within a Calculation, the GetRepetition function works, but this guy is
> trying to say that typing "<> as a Merge Field in a Text
> block will give you the fifth repetition's data.

Yep: just as in calcs, <> also works as a merge field.
However, you cannot specify the repetition number in the 'specify field'
dialog; you must add it manually.

Re: Repeating fields display

am 16.01.2008 00:52:00 von Helpful Harry

In article <13oq777j31p2o9c@corp.supernews.com>, Howard Schlossberg
wrote:

> Helpful Harry wrote:
> > In article , Martin
> > Trautmann wrote:
> >
> >> On Tue, 15 Jan 2008 13:04:43 +1300, Helpful Harry wrote:
> >>> That definitely doesn't work in FileMaker 5.5 (it simply displays it as
> >>> normal text, ie. "<>"), but might be worth a try in newer
> >>> versions.
> >> former ones had e.g. GetRepetion(fieldname,2). fieldname[1] works as
> >> fieldname, since 1 is the default.
> >
> > Within a Calculation, the GetRepetition function works, but this guy is
> > trying to say that typing "<> as a Merge Field in a Text
> > block will give you the fifth repetition's data.
>
> Yep: just as in calcs, <> also works as a merge field.
> However, you cannot specify the repetition number in the 'specify field'
> dialog; you must add it manually.

I guess that's good news for those still stuck with databases made by
someone silly enough to use Repeating fields ... but you still probably
better off in the long run changing the design to avoid the Repeating
field. :o)

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)