Hello. I'm using Survey123 Connect to build a survey where i ask users to select their top 3 preferences from a group of items. Each 'preference' question is a separate question, i.e. 'Choose your top preference', then 'Choose your second preference', etc. The 'group of items' is populated using the `autocomplete search()` functionality to return data from an AGOL hosted table.
My goal is to prevent a user from selecting the same item in subsequent preference selections by removing the previously selected value(s) from the 'group of items'. For example, i don't want a user selecting, say Ice Cream as their favorite food in the 3 questions asking for their top 3 food types (although that would be my preferred selections!). So, if they chose Ice Cream in the first question, Ice Cream would not appear in the 'group of items' for the second and third questions.
Esri docs say that for a nonspatial table, i can use 'contains' or 'matches' as search types. But, Is there a way to say 'does not match' or 'does not contain'. I tried putting a '!' in front of 'matches' but that didn't work
And for the filter option its not clear how the filterText parameter should be formatted for a 'negative' filter. I have the same goal: to filter records so that rows where filterColumn does not equal a particular filterText value. Any suggestions?
