I have developed a system to allocate shifts to staff members, but I’ve reached a stumbling block. I am aware that I can filter fields on a form to only display users with certain information. In my case ‘Compliant’.
I’d like to be able to have all names shown, but if anyone is ‘Non-Compliant’ they’re unable to be selected and are shown in red with a prefix to the name, i.e., ‘John Doe [Non-Compliant]’.
Thank you for any help as always!