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