Jump to content

Displaying 'Other...' choices


Ender
 Share

This topic is 5696 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I had a request to have a print form show the value of a checkbox's 'Other...' choice, and it got me thinking about what the best way to do this actually is.

For example, if I have a list of checkbox choices for cars, most of which are available as checkbox choices, but where there may be some that are not available in the value list, so we allow an 'Other...' choice where the user can manually make an entry. Now we want to see what that Other value is when the form is printed.

The first interesting method I've though of, is using a custom function to make an Other calc field, that only shows the values not in the original value list of choices.

A second method I came up with, is using a custom function and a conditional value list, so that all the original values plus the Other values show as checkboxes in a result calc.

A third method is simply using a separate field for Other values.

Attached is a demo showing each of these techniques. I'm sure there are advantages and disadvantages to each, but I'd like to get some opinions about them, and any other ideas for how people handle this.

OtherCheckbox.fp7.zip

Link to comment
Share on other sites

Hi Mike

Great stuff...

The first interesting method I've though of, is using a custom function to make an Other calc field, that only shows the values not in the original value list of choices.

Cool that NotList - a Left Outer Join CF!!!

--sd

Link to comment
Share on other sites

Cool that NotList - a Left Outer Join CF!!!

That one was from:

http://www.briandunning.com/cf/65

There are several CFs that do an XOR kind of thing, but this one kept the exclusion one-way.

Any preference between the three methods?

Link to comment
Share on other sites

Well I'm hanging on to Moyer & Bowers book on the topic, and they try to make the desitinctions between Left- Right- and Full Outer Joins as well as Union Joins. I do usually throw Rays XOR after everything I encounter, but it's for some purposes a fat cat to swing by the tail. say here!

--sd

Link to comment
Share on other sites

This topic is 5696 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.