I understand I need a calculated field each of these fields to return the single value from each field. There will also be a 6th calculated field required to concatenate elements from the field data selected.
Say I filled the form fields with the following data
80mm Round | 110 | 450 | 90 Brick| 2700 |
Then the concatenated data will look like
DP 80 110 450 90 2700 or strung together DP80110450902700
I can see I need to use the Custom Calculation scripts; but I am not sure of how to write the script to return the 70/90/ other value for Cladding type into a result field; and in particular the form of the calculation to concatenate string text fields to numeric value fields.