Condense a values selected

[agtjazz]

In a database I am currently developing, I have a value list that is:

1-presentation of a paper or a creative activity

2-organize a conference or other official duties at a conference

3-service as a panel chair, referee or other activity listed in the program

4-conducting research

5-workshop or conference attendance

It’s a checkbox set, allowing the user to select more than 1 value.

On another layout, I am trying to display only the number(s) that were selected. For example, 1,4 or just 1

I was trying to make a calculated field with the list and trim function, but just can’t seem to get it going… any assistance would greatly be appreciated.

[comment]

Put your values in a table with two fields: ValueID and Description. Change your value list to use values from field ValueID, also showing the Description field.

To show the selected values in a condensed form, substitute ¶ with a comma.

[Raybaudi]

Substitute ( Filter ( yourCheckBoxField ; "12345¶" ) ; ¶ ; "," )

[Raybaudi]

For order purpose, this is better:

Let(

values = Substitute ( FilterValues ("1¶2¶3¶4¶5"; Filter ( yourCheckBoxField ; "12345¶" ) ) ; ¶ ; "," );

Left ( values ; Lenght ( values ) - 1 )

)

[agtjazz]

Thank you both Comment and Daniele

I tried both methods and found Comment's recommendation simpler

So I have a value list based on a table. Fields are code and description. I have a calculated field clist_priority... and it lists all the selection.

My question now is how do I make it so the clist_priority to show 1,4,5 instead of

1

4

5

?

Thanks bunches

[comment]

Substitute ( SelectedValues ; ¶ ; "," )

Or, if you want them sorted (instead of listed in the order they were selected)

Substitute (

FilterValues ( ValueListItems ( Get (FileName) ; "YourValueListNameHere" ) ; SelectedValues ) & ¶ ;

[ "¶¶" ; "" ] ;

[ ¶ ; ", " ]

)

Edited October 10, 2007 by Guest

[agtjazz]

Thanks

the first calculation worked like a charm

Thanks bunches