Hey agian. . .

Problem: Using checkboxes, need to display text user inputs when using "Other." Solution is simple with radio buttons, but not so much with checkboxes since more than one can be chosen.

Work with me on this example:

Field A: Checkbox: items; "A" , "B" , "C" , "D" , "Other"

Field A Other: Calc:

If(Field A = "A" or Field A = "B" or Field A = "C" or Field A = "D", "", Attachments)

This doesn't work because if item "B" and Other is selected then it would view as

"B

OTHER INPUT"

Tried calc:

If(Field A = "A" or Field A = "B" or Field A = "C" or Field A = "D", "", If(WordCount(Field A) = 1, Field A, Field A & Substitute(Field A, "A", "") & (Substitute . . . etc etc.

This would work if and only if either only One item is selected, or if One item and Other is selected. Else it shows the first option chosen.

OK, as always, i am sure that i'm going about the hard way seeing as i always make this stuff difficult. Any help would be greatly appreciated.

'/4F|234><

How about making "Other" a value on the value list (don't use the "other" field format option), then using the portal trick to unhide an entry field "OtherEntry" when the checkbox for "Other" is checked. Create a calculation fields:

Constant (calculation, number, indexed) = 1

PortalEnable (calculation, number, indexed) =

PatternCount(Field A, "Other")

Define a relationship: SelfPortal with PortalEnable <--> Constant

With this method the data in the OtherEntry field is isolated and available for use. This data can also be combined with the data in the checkbox field into another calculation field to give the same result you would have had with the "Other" field format item. -bd

well. . .

no good. The portal will hide the contents until no fields are active. Tabbing out of the field keeps the next field active. Clicking on the next field keeps the content hidden as well. Only when i click outside of the fields will it show.

Besides, i would prefer that the "Other" value would still be present in the original field. I know that i could simply make a new field that is a calculation, and i planned on doing that, but since the Portal Hiding doesn't work then i'm still looking for something else. . .

Thanks for suggestion though. Any other ideas? If i come up with something, i'll elighten all.

'/4F|234><

The approach I gave you will work (I tested it). Make sure the field in the portal is not a related field. It should be "OtherEntry" NOT "SelfPortal::OtherEntry. If you can't make it work, I'll send you the demo file. -bd

well, again, i've done all that, and used this method many times to hide things, however, the field doesn't show until i click out of an active field. As long as ANY field is active, the OtherEntry field remains hiden. I guess go ahead and send it, maybe i'll see something i didnt see before.

thanks for your help

jeremy