FMP 9

I have my users setting criteria via a checkbox list, once selected I
would like to see only the checked options in a horizontal format, is
there a way to achieve this?
I have a merge field displaying the selection at the moment but can
only have them look like:

black
blue
red

I want it to appear as:

black blue red

Thanks so much for any help.

Toni

In article <1186036989.621010.259720 [at] i38g2000prf.googlegroups.com>, tm
<eshopstall [at] optusnet.com.au> wrote:

> FMP 9
>
> I have my users setting criteria via a checkbox list, once selected I
> would like to see only the checked options in a horizontal format, is
> there a way to achieve this?
> I have a merge field displaying the selection at the moment but can
> only have them look like:
>
> black
> blue
> red
>
> I want it to appear as:
>
> black blue red
>
> Thanks so much for any help.

Options chosen in Checkbox fields are stored as the values separated by
a carriage return, as in your first example.

To get them displayed as you want them in the second example you will
have to use a Calculation field that changes the carriage returns to
either spaces or tabs (whichever you prefer).
eg.
ChecboxField_Horizontal Calculation, Text Result, Unstored
= Substitute (CheckboxField, "**", " ")

where the ** is really the carriage return symbol - the "backwards 'P'"
that is on one of the buttons at the top of the Define Calculation
window.

You can then use this new Calculation field as the merge field instead
of the original Checkbox field.


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

On Aug 2, 1:34 am, Helpful Harry <helpful_ha... [at] nom.de.plume.com>
wrote:
> In article <1186036989.621010.259... [at] i38g2000prf.googlegroups.com>, tm
>
>
>
> <eshopst... [at] optusnet.com.au> wrote:
> > FMP 9
>
> > I have my users setting criteria via a checkbox list, once selected I
> > would like to see only the checked options in a horizontal format, is
> > there a way to achieve this?
> > I have a merge field displaying the selection at the moment but can
> > only have them look like:
>
> > black
> > blue
> > red
>
> > I want it to appear as:
>
> > black blue red
>
> > Thanks so much for any help.
>
> Options chosen in Checkbox fields are stored as the values separated by
> a carriage return, as in your first example.
>
> To get them displayed as you want them in the second example you will
> have to use a Calculation field that changes the carriage returns to
> either spaces or tabs (whichever you prefer).
> eg.
> ChecboxField_Horizontal Calculation, Text Result, Unstored
> = Substitute (CheckboxField, "**", " ")
>
> where the ** is really the carriage return symbol - the "backwards 'P'"
> that is on one of the buttons at the top of the Define Calculation
> window.
>
> You can then use this new Calculation field as the merge field instead
> of the original Checkbox field.
>
> Helpful Harry
> Hopefully helping harassed humans happily handle handiwork hardships ;o)

Looks good, except the calc doesn't have be Unstored.

G

On Aug 2, 5:34 pm, Helpful Harry <helpful_ha... [at] nom.de.plume.com>
wrote:
> In article <1186036989.621010.259... [at] i38g2000prf.googlegroups.com>, tm
>
>
>
>
>
> <eshopst... [at] optusnet.com.au> wrote:
> > FMP 9
>
> > I have my users setting criteria via a checkbox list, once selected I
> > would like to see only the checked options in a horizontal format, is
> > there a way to achieve this?
> > I have a merge field displaying the selection at the moment but can
> > only have them look like:
>
> > black
> > blue
> > red
>
> > I want it to appear as:
>
> > black blue red
>
> > Thanks so much for any help.
>
> Options chosen in Checkbox fields are stored as the values separated by
> a carriage return, as in your first example.
>
> To get them displayed as you want them in the second example you will
> have to use a Calculation field that changes the carriage returns to
> either spaces or tabs (whichever you prefer).
> eg.
> ChecboxField_Horizontal Calculation, Text Result, Unstored
> = Substitute (CheckboxField, "**", " ")
>
> where the ** is really the carriage return symbol - the "backwards 'P'"
> that is on one of the buttons at the top of the Define Calculation
> window.
>
> You can then use this new Calculation field as the merge field instead
> of the original Checkbox field.
>
> Helpful Harry
> Hopefully helping harassed humans happily handle handiwork hardships ;o)- Hide quoted text -
>
> - Show quoted text -

Thank you so much!

In article <1186061803.332940.38390 [at] e16g2000pri.googlegroups.com>, Grip
<grip [at] cybermesa.com> wrote:

> On Aug 2, 1:34 am, Helpful Harry <helpful_ha... [at] nom.de.plume.com>
> wrote:
> > In article <1186036989.621010.259... [at] i38g2000prf.googlegroups.com>, tm
> >
> > <eshopst... [at] optusnet.com.au> wrote:
> > >
> > > FMP 9
> > >
> > > I have my users setting criteria via a checkbox list, once selected I
> > > would like to see only the checked options in a horizontal format, is
> > > there a way to achieve this?
> > > I have a merge field displaying the selection at the moment but can
> > > only have them look like:
> > >
> > > black
> > > blue
> > > red
> > >
> > > I want it to appear as:
> > >
> > > black blue red
> > >
> > > Thanks so much for any help.
> >
> > Options chosen in Checkbox fields are stored as the values separated by
> > a carriage return, as in your first example.
> >
> > To get them displayed as you want them in the second example you will
> > have to use a Calculation field that changes the carriage returns to
> > either spaces or tabs (whichever you prefer).
> > eg.
> > CheckboxField_Horizontal Calculation, Text Result, Unstored
> > = Substitute (CheckboxField, "**", " ")
> >
> > where the ** is really the carriage return symbol - the "backwards 'P'"
> > that is on one of the buttons at the top of the Define Calculation
> > window.
> >
> > You can then use this new Calculation field as the merge field instead
> > of the original Checkbox field.
>
> Looks good, except the calc doesn't have be Unstored.

Maybe not in this case, but I tend to do that by default to make sure
the Calculation actually has the correct data in it. If you let
FileMaker store the result you can end up with Calculations that don't
update themselves.

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

On 8/2/07 1:53 PM, in article
030820070853339880%helpful_harry [at] nom.de.plume.com, "Helpful Harry"
<helpful_harry [at] nom.de.plume.com> wrote:

> In article <1186061803.332940.38390 [at] e16g2000pri.googlegroups.com>, Grip
> <grip [at] cybermesa.com> wrote:
>
>> On Aug 2, 1:34 am, Helpful Harry <helpful_ha... [at] nom.de.plume.com>
>> wrote:
>>> In article <1186036989.621010.259... [at] i38g2000prf.googlegroups.com>, tm
>>>
>>> <eshopst... [at] optusnet.com.au> wrote:
>>>>
>>>> FMP 9
>>>>
>>>> I have my users setting criteria via a checkbox list, once selected I
>>>> would like to see only the checked options in a horizontal format, is
>>>> there a way to achieve this?
>>>> I have a merge field displaying the selection at the moment but can
>>>> only have them look like:
>>>>
>>>> black
>>>> blue
>>>> red
>>>>
>>>> I want it to appear as:
>>>>
>>>> black blue red
>>>>
>>>> Thanks so much for any help.
>>>
>>> Options chosen in Checkbox fields are stored as the values separated by
>>> a carriage return, as in your first example.
>>>
>>> To get them displayed as you want them in the second example you will
>>> have to use a Calculation field that changes the carriage returns to
>>> either spaces or tabs (whichever you prefer).
>>> eg.
>>> CheckboxField_Horizontal Calculation, Text Result, Unstored
>>> = Substitute (CheckboxField, "**", " ")
>>>
>>> where the ** is really the carriage return symbol - the "backwards 'P'"
>>> that is on one of the buttons at the top of the Define Calculation
>>> window.
>>>
>>> You can then use this new Calculation field as the merge field instead
>>> of the original Checkbox field.
>>
>> Looks good, except the calc doesn't have be Unstored.
>
> Maybe not in this case, but I tend to do that by default to make sure
> the Calculation actually has the correct data in it. If you let
> FileMaker store the result you can end up with Calculations that don't
> update themselves.
>
> Helpful Harry
> Hopefully helping harassed humans happily handle handiwork hardships ;o)


I didn't know about the spaces, but I have made horizontal checkbox lines.
The format starts out vertical, but then I make the field borders the height
of the first entry, and as wide as I need. This forces the checkbox choices
into a horizontal configuration.

Is this a bad way to do it?

In article <C2D7F9BB.2129F%trashadd5 [at] bigfoot.com>, "David Robins, MD"
<trashadd5 [at] bigfoot.com> wrote:

> On 8/2/07 1:53 PM, in article
> 030820070853339880%helpful_harry [at] nom.de.plume.com, "Helpful Harry"
> <helpful_harry [at] nom.de.plume.com> wrote:
>
> > In article <1186061803.332940.38390 [at] e16g2000pri.googlegroups.com>, Grip
> > <grip [at] cybermesa.com> wrote:
> >
> >> On Aug 2, 1:34 am, Helpful Harry <helpful_ha... [at] nom.de.plume.com>
> >> wrote:
> >>> In article <1186036989.621010.259... [at] i38g2000prf.googlegroups.com>, tm
> >>>
> >>> <eshopst... [at] optusnet.com.au> wrote:
> >>>>
> >>>> FMP 9
> >>>>
> >>>> I have my users setting criteria via a checkbox list, once selected I
> >>>> would like to see only the checked options in a horizontal format, is
> >>>> there a way to achieve this?
> >>>> I have a merge field displaying the selection at the moment but can
> >>>> only have them look like:
> >>>>
> >>>> black
> >>>> blue
> >>>> red
> >>>>
> >>>> I want it to appear as:
> >>>>
> >>>> black blue red
> >>>>
> >>>> Thanks so much for any help.
> >>>
> >>> Options chosen in Checkbox fields are stored as the values separated by
> >>> a carriage return, as in your first example.
> >>>
> >>> To get them displayed as you want them in the second example you will
> >>> have to use a Calculation field that changes the carriage returns to
> >>> either spaces or tabs (whichever you prefer).
> >>> eg.
> >>> CheckboxField_Horizontal Calculation, Text Result, Unstored
> >>> = Substitute (CheckboxField, "**", " ")
> >>>
> >>> where the ** is really the carriage return symbol - the "backwards 'P'"
> >>> that is on one of the buttons at the top of the Define Calculation
> >>> window.
> >>>
> >>> You can then use this new Calculation field as the merge field instead
> >>> of the original Checkbox field.
> >>
> >> Looks good, except the calc doesn't have be Unstored.
> >
> > Maybe not in this case, but I tend to do that by default to make sure
> > the Calculation actually has the correct data in it. If you let
> > FileMaker store the result you can end up with Calculations that don't
> > update themselves.
>
> I didn't know about the spaces, but I have made horizontal checkbox lines.
> The format starts out vertical, but then I make the field borders the height
> of the first entry, and as wide as I need. This forces the checkbox choices
> into a horizontal configuration.
>
> Is this a bad way to do it?

Nope, you're 100% correct - that's exactly how you do it when using a
normal field ... but the original person wanted the data from a Merge
field (presumably within a block of other text for a printed report).

If it wasn't for the Merge field needs, you could use the normal way
and simply make the Line width 0pt or the colour white to hide the
checkboxes themselves.



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