How To Create A Calculated Field Combining Fields

Description: 

For ease of use or presentation, one may wish to combine multiple fields into a single field, and it can be done relatively quickly with a calculated field. 

Steps:

1. Open Thunder, and navigate to Administration:
   
2. Navigate to fields and locate the fields you wish to combine, and note their Field Key, which may be different than their display name. Shown here, the display name is First Combination while the field key is Play.Offense.Combo1.  The Field Name, or the last part of the Field Key is Combo1.  We will use the Field Name, Combo1, in our example.
   
3. Select "New Calculation" at the bottom and enter the information as if it were a regular field, then press "Add Calculation" to display the calculation lines
   
4. Field Names are entered in brackets, with + signs combining sections, and all non-field text is contained in a single quote. So, to combine Combo1 and Combo2 in a single field separated by a dash, we have "[combo1] + ' - ' + [combo2]"
5. Then add a calculation, for this case, picking something that will always exist is best, or a condition matching the desired requirements. Select the 3 dots and then click "Click here to add new condition", which then defaults to use the first alphabetical field
   
6. Click the field name to expand all options for a field, and select that field. This example will select First Combination (note it uses Display Name and not FieldKeys/Field Names)
   
7. Click the condition (Contains) and change it to "Is not Equal To"
   
8. Leaving the value of "Is not Equal To" blank, press OK to see the populated calculation
   
9. Press OK and return to Thunder and Publish Calculated fields to update the calculated field from existing data
   
10. Opening something that should populate data will now have executed that calculation, and will be reflected in the field