Select to view content in your preferred language

Limit choices in select multiple list based on dynamic text values

264
1
09-26-2024 12:18 PM
ZachStern
Emerging Contributor

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!

ZachStern_0-1727378201139.png

 

0 Kudos
1 Reply
DougBrowning
MVP Esteemed Contributor

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.

0 Kudos