AnsweredAssumed Answered

CALCULATION FIELD TO SHOW CHECKBOXES SELECTED

Question asked by KAmsinger on Oct 28, 2011
Latest reply on Oct 28, 2011 by KAmsinger

Title

CALCULATION FIELD TO SHOW CHECKBOXES SELECTED

Post

HI. So what I am waiting to do is create a calculation field to put on a table view layout to show only the checkboxes of other fields that have been selected for a record. However, the current calculation I have is doing this but it is showing blank spaces for the fields that are not checked which is making it a really long list to scroll down and just see the few items that are checked. I want to know what Operators or functions between each field in my calculation to tell it to only show the fields that are checked. My current calculation looks like this. 

NYHLJ20s  & "¶" & NYHLJEr30s  & "¶" & NYHLJLt30s  & "¶" & NYHLJEr40s  & "¶" &  NYHLJOv45  & "¶" & NYHLAllJ  & "¶" & NYHLNJ20s  & "¶" & NYHLNJEr30s  & "¶" & NYHLNJLt30s  & "¶" & NYHLNJEr40s  & "¶" & NYHLNJOv45  & "¶" & NYHLAllNJ  & "¶" &  NYHLTall  & "¶" &  NYHLPetite  & "¶" &  NYHLBlonde  & "¶" &  NYHLBrunette  & "¶" &  NYHLExotic  & "¶" &  NYHLSexy  & "¶" &  NYHLNatural  & "¶" &  NYHLSmart  & "¶" &  NYHLAsian  & "¶" &  NYHLForeign  & "¶" &  NYHLBigJob  & "¶" &  NYHLSporty  & "¶" &  NYHLDivorc  & "¶" &  NYHLDivorcKids  & "¶" &  NYHLProspects  & "¶" &  NYWSDMetBar  & "¶" &  NYWSDMetParty  & "¶" &  NYWSDMetCharity  & "¶" &  NYWSDMetConsult  & "¶" &  NYWSDMetMutFriend  & "¶" &  NYWSDFB

So at each carriage return if the field is not checked for that record it will still do the carriage return and then keep doing a carriage return showing blank spaces until it shows a field that is checked. I jsut want it to only show the fields that are checked and leave out the fields that are not checked. 

Outcomes