AnsweredAssumed Answered

Calculation field to display values of checkboxes

Question asked by marksealey on Jan 14, 2015
Latest reply on Jan 14, 2015 by marksealey

Simple, I know; but…

 

how do I build a calculation field (I assume that's what I want) which outputs/displays a composite string with the values from other tables' fields, please?

 

This kind of thing does not work:

 

outputString=""

&

If (other_table::checkbox1 = "Y"; outputString ="green"; outputString ="blue")

&

If (other_table::checkbox2 = "Y"; outputString ="circular"; outputString ="square")

&

// etc

outputString

 

Am I on the wrong track altogether?

 

TIA!

Outcomes