Logical Operators on Field Setting Filter Rules in Forms
Currently when applying a Filter Rule in Field Setting in the Form designer the only option is for the value of the "Field to filter by" to be "Identical to" the value of the field that is being filtered. I would love to have other options, e.g. "Not Identical to" so that the field being filtered can exclude options that have already been chosen in the filter source field. The result would be the ability to pick each option only once on a form in the way that a multiselect widget does, while allowing the results to be stored in separate fields in the same record. It would be great for tasks like assigning staff, signing out physical resources, and creating ranking or matching survey questions where the exact order of the responses matters as much as their non-reusability.
Thank you for the feedback and explanation of the use case for this functionality. We will pass this onto our Product Team to take into consideration for further enhancements to the form filters. We appreciate the feedback.