Gather the selected groups from multiple group selection fields.
Use this action to gather all selected groups from multiple Group selection fields. This action can be utilized when Group selection fields are in the table, enabling you to summarize all selected groups for each row.
When executed, it aggregates all groups designated in the fields specified by the “Group Select Field” parameter.
For example, consider the following Group selection fields:
In field A, three groups—X, Y, and Z—are selected.
In field B, two groups—X and W—are chosen.
When you consolidate fields A and B using the “Gather Chosen Groups” action, the result will be four unique groups: 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 Group selection fields.
Set Group 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 Groups” 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).”