I have a multiple select question that asks applicants to select which Grants they want to apply for. I only want them to be able to see the grants that they are eligible for. There are earlier calculated questions that determine eligibility for each grant based on a pulldata function from the geopoint question I have. Each pulldata question queries a separate layer of data corresponding to that grant and says where the point is MID or N/A. For my multi-select question I only want to show choices where the applicant is NOT N/A.
I tried creating a new field in the choices called "filter" and passing in the results from those pulldata queries and then in the choice_filter cell I used the statement filter!='N/A but that didn't work. Any help would be much appreciated!
You can only do direct matches you cannot use !=. Also it has to be text matches you cannot have a field in the lists page. I tend to make multiple rows for each option and line them up that way. I think for yours you could have MID in that list filter column and match that up with the choice filter.