I'm about to start building a custom list to capture a number of different query types. I was intending to do this with some custom Site Content Types but I've realized that I'm going to need to filter certain choice or lookup column options based on the content type name. Is there a simple way to do this without resorting to using InfoPath?
I'm not a developer and I'm not great at JS so OOTB solutions would be lovely.
If not I could always create 6 or 7 almost identical choice columns and use each one once in each content type but that's silly.