Jump to content

Condense a values selected


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

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

This topic is 6084 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
×
×
  • Create New...

Important Information

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