Imagine a user has ten fields of type “List(text)” which each have for their widget “Check boxes/radio buttons”. Each one is displayed to the user as a single value checkbox which asks the user to state whether they agree with something or not.
A distinct Computed Field of data type TinyInt uses custom PHP to examine the values of these List(text) fields checkboxes. If all are checked the Computed Field is set to have the value of 1. If any or all are unchecked the Computed Field is set to have the value of 0.
(Ideally I would like the Computed Field to be of Boolean type – so simple TRUE/FALSE – but this does not seem possible out of the box. Anyway, the real question is the following.)
In a View with exposed fields, how can you use the Computed Field as an exposed field that offers the user a single checkbox: “Find all users where the Computed Field value is 1: [•]”.
If this isn’t directly possible, I’m happy to have a workaround that involves creating a distinct (hidden) field in the user profile and then uses this for the Views exposed filter search. But I can’t think of a way to do this right now… Thanks.
Sponsored by SupremePR