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

Groups > comp.databases.filemaker > #1350

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

Show all headers | View raw

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.

-- 
met vriendelijke groeten,
Erik Appeldoorn

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next 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