agtjazz Posted October 10, 2007 Share Posted October 10, 2007 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 More sharing options...
comment Posted October 10, 2007 Share Posted October 10, 2007 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. Link to comment Share on other sites More sharing options...
Raybaudi Posted October 10, 2007 Share Posted October 10, 2007 Substitute ( Filter ( yourCheckBoxField ; "12345¶" ) ; ¶ ; "," ) Link to comment Share on other sites More sharing options...
Raybaudi Posted October 10, 2007 Share Posted October 10, 2007 For order purpose, this is better: Let( values = Substitute ( FilterValues ("1¶2¶3¶4¶5"; Filter ( yourCheckBoxField ; "12345¶" ) ) ; ¶ ; "," ); Left ( values ; Lenght ( values ) - 1 ) ) Link to comment Share on other sites More sharing options...
agtjazz Posted October 10, 2007 Author Share Posted October 10, 2007 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 More sharing options...
comment Posted October 10, 2007 Share Posted October 10, 2007 (edited) 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 Link to comment Share on other sites More sharing options...
agtjazz Posted October 17, 2007 Author Share Posted October 17, 2007 Thanks the first calculation worked like a charm Thanks bunches Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6170 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 accountSign in
Already have an account? Sign in here.
Sign In Now