Link to home
Create AccountLog in
Avatar of ServalStudios
ServalStudios

asked on

Can you create a Filemaker calculation field that lists the values checked by commas?

I have a value list for a record that has check boxes for A B C D.  I want create a calculation field that I can place in other area, say a letter, that only lists what is selected.  So say the record only has A C and D checked, I would like to create a calculated field that says "you have selected a,c,d" .  Is this possible?
Avatar of jvaldes
jvaldes
Flag of United States of America image

That type of field is called a check box field. If you create one and add a list of values to it... ABCD then there will be a filed with four small boxes one next to each letter and you can select one or many of the choices. The field will contain a value "ABD" if you selected that combination and "B" if you only select B. Then you can create a relationship to each of the letters so that it can be used as a filter.
ASKER CERTIFIED SOLUTION
Avatar of challengeday
challengeday
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Avatar of Will Loving
Will Loving
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Wow, so cool that you got the paragraph mark ¶  to show in Expert's Exchange, mine always showed up as a question mark. Thanks willmcn!
Must be because I'm working from a Mac   ;-D
Avatar of ServalStudios
ServalStudios

ASKER

Thanks so much for your help.  I am working on lots of changes to existing database and this helps a great deal.