I have a custom record with two fields: 1. Field Allowed Departments of type Multiselect. A list of departments. Lets say there are 3 specific departments there. 2. Field Target Department. A Single Select list of departments. Is it possible to filter the options on Field

Target Department

to only show the departments in the Field

Allowed Departments

? Take into account that the fields are not of the same type, one is multiselect, the other is select.

AI generated answer (using internal Slack threads):

Based on the conversations, it is possible to filter the options on Field

Target Department

to only show the departments in the Field

Allowed Departments

. This can be achieved through the use of sourcing and filtering on the custom field. Here are the steps to do this: 1. On the custom field that you want to control the choices on (in this case,

Target Department

), go to the sourcing and filtering subtab. 2. Set a filter to limit the result options in the new field. The filter should be set to compare to the

Allowed Departments

field. Please note that this method works if both fields are custom fields on a custom record. If the fields are native fields, a workflow might be more suitable for your needs. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******