I'm quite sure there is a calc for this

[Ugo DI LUCA]

I already seen a scripted method but I'm quite sure there is a clac for this.

I want a field to hold the values not choosen from a value list.

Say a field with checkbox with A, B,C,D,E

Field t_choice =

A

C

E

Field t_nonchoosen =

B

D

Am I dreaming ?

[slstrother]

Try this in your not chosen field

Case(PatternCount(Value List,"A")=0,"A"&"

[Ugo DI LUCA]

Thanks,

I was turning around with Value List Item - Field A with no success.

[Fitch]

I was playing around with something like this, but I'm not thinking too clearly at the moment:

(Substitute(Substitute(

ValueListItems(Status(CurrentFileName), "abc"),

Middle(t_choice, 1, Position(t_choice, "

[Ugo DI LUCA]

Thanks Tom,

Well, I was far from that but on same track. I'll try both method and I'll tell you.

I didn't mentionned it, but these calc would have to be executed from a related file.

[Vaughan]

If you can be sure that only one item is ever selected than the task is easy. However the challenge lies when the field has more than one value list item selected, say with a set of checkboxes.

I have done it, but it's a scripted process and not a calculation. It involves taking the whole vaue list then subtracting the first entered item from it, then subtracting the second entered item etc until there are no more entered items. The remaining string is the list of unentered items.

[EvaR]

Troi have great plug-in that does this automatic for many values selected on record.

Text plug-in. Is working really well!

[Ugo DI LUCA]

Hi all,

Well, I've tried both methods and as Vaughan said, I must keep my first scripted method as this is a checkbox value list. So bad I have to press an update button there....

[djgogi]

Hi Ugo,

try the example attached.

It works for list with up to 20 items (otherwise extend the calculation)

The main file is Bin.fp5 (basically it is the decimal to binary conversion) .

The List.fp5 is only the container for value list items.

Dj

ForUgo.zip

[Ugo DI LUCA]

Ciao Goran,

As usual you've been very helpful.

I slightly modified your file setting a relationship from one file to another using another indexed value with allow creation of related records.

I had to change some settings (just the value list format and relationships), but it seems to work like a charm.

----> My line item is populated by both choosen and not choosen values...

I just have to experiment some more and I'll post back a sample of what I can achieve with such a CALCULATION. You did a Great Job.

Thanks again. Ciao.