Repeating fields display
am 10.01.2008 18:46:24 von amy_huiHow can I display all repetitions of a repeating field when using the
carrots in the layout mode?
<
How can I display all repetitions of a repeating field when using the
carrots in the layout mode?
<
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
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
> 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
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)
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"
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)
In article <47878e6d$0$82076$dbd49001@news.wanadoo.nl>, "Ursus"
> 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)
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?
<
In article <1JQij.28741$ty.2682103@phobos.telenet-ops.be>, "Robben"
>
> > 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. "<
versions.
Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
It just works in FM9, no need to "try" :)
I didn't see a clue that anyone was still in 5.5...
"Helpful Harry"
news:150120081304430401%helpful_harry@nom.de.plume.com...
> In article <1JQij.28741$ty.2682103@phobos.telenet-ops.be>, "Robben"
>
>
> That definitely doesn't work in FileMaker 5.5 (it simply displays it as
> normal text, ie. "<
> versions.
>
> Helpful Harry
> Hopefully helping harassed humans happily handle handiwork hardships ;o)
Post removed (X-No-Archive: yes)
In article
Trautmann
> 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. "<
> > 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 "<
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)
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"
news:160120080856262129%helpful_harry@nom.de.plume.com...
> In article
> Trautmann
>
but this guy is
> trying to say that typing "<
> block will give you the fifth repetition's data.
>
Helpful Harry wrote:
> In article
> Trautmann
>
>> 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. "<
>>> 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 "<
> block will give you the fifth repetition's data.
Yep: just as in calcs, <
However, you cannot specify the repetition number in the 'specify field'
dialog; you must add it manually.
In article <13oq777j31p2o9c@corp.supernews.com>, Howard Schlossberg
> Helpful Harry wrote:
> > In article
> > Trautmann
> >
> >> 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. "<
> >>> 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 "<
> > block will give you the fifth repetition's data.
>
> Yep: just as in calcs, <
> 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)