Limit choices in select multiple list based on dynamic text values
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!
