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?
FileMaker Pro
Last Comment
ServalStudios
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
ASKER
Thanks so much for your help. I am working on lots of changes to existing database and this helps a great deal.