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.
- Open Thunder, and navigate to Administration:
- 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 by double-clicking the field or right-clicking and picking "Properties". The Field Name is combo1. We will use the Field Name, combo1, in our example.
- 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
- 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]"
- 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
- 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)
- Click the condition (Contains) and change it to "Is not Equal To"
- Leaving the value of "Is not Equal To" blank, press OK to see the populated calculation
- Press OK and return to Thunder and Publish Calculated fields to update the calculated field from existing data
- Opening something that should populate data will now have executed that calculation, and will be reflected in the field