Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #1352

Re: Extract Text from a Checkbox and add text between values

Show all headers | View raw

In article <l02umu$uee$1@dont-email.me>, Erik Appeldoorn
<ursus.kirk@gmail.com> wrote:

> Op 2-9-2013 20:18, Diego B schreef:
> > Hi all,
> >
> > FM 11Adv for widnows here :)
> >
> > I have a checkbox list such as:
> > Apple, Banana, Orange, Lemon
> >
> > Now, I would like to add another text value to each selected value of the
> > checkbox, in real time. So that when the user select "Orange" in the list,
> > there will be a Custom dialog box that will let her to insert an adjective
> > (i.e. "Good", "Bad, "tasty" or whatever she likes).
> > Finally, I would like to report in a second field the combination of
> > checked value (from the checkbox) and the free adjective I have let the
> > user add, to have:
> >
> > "Orange good", "apple Bad", "lemon tasty" etc...
> >
> > I am trying to play with triggers so that the custom dialog box pops up as
> > far as a value in the checkbox is checked (this works).
> > Unfortunately, the free text is added to the END of the checked values, and
> > I end up with something like:
> >
> > Orange, Apple, Lemon good (or bad or tasty, actually the new added free
> > text erases the preceding choices instead of adding up)
> >
> > Might you please help ? It would be nice to define a solution that does not
> > use script triggers as well, if at all possible...
> >
> > Thanks a lot !
> >
> > Diego
> >
> 
> There isn't an easy solution with checkboxes
> Using four fields each using the same valuelist could work
> but a user could then select oranges twice
> I would not present the user with an extra choice
> I would probably just type the fruits in a textbox
> then present four fields next to the textbox to record the choices
> But this would stumble when a lot of items are needed for the textbox
> And since the textbox is hardcoded it would be easy to calculate the 
> result from this.
> Then use calculated fields that return text.
> first sentence is apples, if the field next to it is empty leave result 
> empty otherwise the calc returns "Apples are" & MyAdjective
> 
> There are other, more complex ways to resolve this, but for a small 
> amount of choices this would be my way to go.

It depends on how many choices there are and where those choice options
are coming from. If they are only relatively a"few" and they are hard
coded in a Value List (rather than retrieved from another file /
table), then you could create separate Value Lists (a single value for
each item) and use a separate checkbox fields and the separate
adjective fields you already need anyway. It does mean that the user
can't use the arrow keys to move down the various options though.

Using invisible buttons and a script to turn on / off the Checkboxes,
you could create a system that knows and can extract which option is
being checked and having an adjective added, but I think it's easier to
simply separate them.

Helpful Harry  :o)

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Extract Text from a Checkbox and add text between values Diego B <messadua@yahoo.it> - 2013-09-02 11:18 -0700
  Re: Extract Text from a Checkbox and add text between values Erik Appeldoorn <ursus.kirk@gmail.com> - 2013-09-02 23:07 +0200
    Re: Extract Text from a Checkbox and add text between values Helpful Harry <HelpfulHarry@BusyWorking.com> - 2013-09-03 09:28 +1200

csiph-web