Checkbox field to Multiple Fields

[dztrucktion]

Is there anyway to get a checkbox fields list values to multiple fields?

Field A:

One¶

Two¶

Three



Field A1:

One

Field A2:

Two

Field A3:

Three

[comment]

Why would you want that?

[dztrucktion]

I am building a report that requires the export of check box values to individual cells in excel.

I was thinking that I could just use a repetion, but exporting would be an issue.

[Vaughan]

Make field A1, A2, A3 calculation fields, = getValue( fieldA ; X ) where X = 1, 2 or 3. Export these fields.

[comment]

I am building a report that requires the export of check box values to individual cells in excel.

How do you want to map the values to Excel columns - considering that items in a checkbox field appear in the order they were selected?

[dztrucktion]

Vaughn,

Thank you so much, works wonders!

comment,

I don't need to re-sort the values (whew!) but if I did, I would assume that maybe I would need to use a related table with some kind of sorting property?

[comment]

Sorting alone wouldn't help if checkbox field contains "Two¶Four", for example. But you could make the calculations =

Case ( not IsEmpty ( FilterValues ( "One" ; CheckboxField ) ) ; "One" )

and so on.