AnsweredAssumed Answered

Create a value list from a check box field using a calculation field

Question asked by ElizaBruml on Jun 1, 2012
Latest reply on Jun 1, 2012 by GuyStevens

Title

Create a value list from a check box field using a calculation field

Post

I have a field called "Tag" set up as a check box, with values from a value list to assign a tag of for example "Caterer" or "Chef" or "Supplier" to a contact.

I have a calcuation field that gets its value from "Tag"

I use this calculation field to define a value list.

I have a text field in a related table called provider, which is set as a drop down list with the values from the defined value list

I have tried various IF and CASE statements but what ever I try I cannot get the calculation correct to show for example all contacts that have the tag caterer or the tag chef assigned to them. I can show contacts that are caterers or contacts that are chefs but if they are both (ie both values checked) the contact does not show up.

Any help much appreciated.

Outcomes