AnsweredAssumed Answered

Checkbox Calculation

Question asked by Dominic on Sep 19, 2013
Latest reply on Sep 19, 2013 by raybaudi


Checkbox Calculation


     Hey guys, struggling to figure out how to do this...

     I have two check-box fields; one is a list of names, and the other is the email for the names. What I want to be able to do is when I check-mark multiple names there corresponding emails get checked. I'm using this for sending emails out.

     Here is what Ive got so far on the email calculation field:

     Case (
     Project Mgr Designer = "Carrie" ; "" ;
     Project Mgr Designer = "Dominic"  ;  "" ;
     Project Mgr Designer = "Justin" ;  "" ;
     Project Mgr Designer = "Paz"  ; "" ;
     It works perfectly when I only have the one designer checked but it does not when you check multiple people. I've tried everything thing i can think off. I thought it would work something like this but no such luck:
     Project Mgr Designer = "Paz" & "Dominic"  ; "" & "";
     I've tried other variations as well but cant seam to figure it out. Any help would be much appreciated.