Gather the selected departments from multiple department selection fields.
Use this action to gather all selected departments from multiple Department selection fields. This action can be utilized when department selection fields are in the table, enabling you to summarize all selected departments for each row.
When executed, it aggregates all departments designated in the fields specified by the “Department Selection Field” parameter.
For example, consider the following department selection fields:
In field A, three departments—X, Y, and Z—are selected.
In field B, two departments—X and W—are chosen.
When you consolidate fields A and B using the “Gather Chosen Departments” action, the result will be four unique departments: X, Y, Z, and W.
This summarized result will be set as the output of the action. You can reference the result by using expressions in actions like “Set Field Value,” which allows you to assign it to the Department selection fields.
Set Organization Select Field and Target Field (Optional).
Select all the fields you want to summarize.
You can mix and select fields inside and outside the table. It is also possible to select fields from multiple different tables.
When you select a field in the table, it consolidates the selection across all rows of that table.
This parameter accepts the following field types:
Use this parameter to set the results to another field. You can omit this parameter if you do not set the results directly in the field but use it in another action.
When you set a destination for initially selected content, that content will be cleared, and the result will overwrite the existing value. If you want to add a selection without clearing the current content, omit this parameter and use the “Add Selection to Field” option instead. You can set the action result of “Gather Chosen Departments” to “= $1” or a similar expression to add the result to the “Value” parameter of “Add Selection to Field.”
This parameter accepts the following field types:
It can be used in situations where a record can be identified in a single line, such as when “When Fields Value Changed.”
Unlike the standard record list view, krewSheet allows you to save multiple rows at once, so this action cannot be used “Before Record Saved Excluding Deleted.”
The results cannot be set in the following fields, even if specified in the “Target Field (Optional).”