Can I check a LIST to see if anything in another LIST is in it.
I’m checking in a volunteer rota to see if someone is already working at the times in the session they are being added to.
I have a LIST of times they are working in other sessions and a list of times in this session.
I’ve compared them by counting and seeing if they match, but that doesn’t work in a form, so doesn’t warn until synced.
Also I need to take 1 off one count as there is always a blank in one list, which is a pain.
If I can remove the blank I think I can remove the session times from the volunteer times and check if the LISTS match.
I’d really like to remove the volunteer from the REF dropdown if they are already working at the times in the session, but this is frying my brain, so I’m leaving that for next, but if that’s actually easier please suggest something.