I have a csv used to dynamically auto-populate the choice lists. The same csv is used for multiple lists and hence there are duplicate values. How can the list be limited to distinct/unique values? I tried combining both DISTINCT & UNIQUE with the search() but neither worked so I either have the syntax incorrect or am using the wrong thing. The spreadsheet is attached. Is there a way to do this without breaking it into multiple csv files with unique values or creating lists in the choices tab?
Workflow:
- Select System
- Based on System, select Class: autocomplete search('groups','matches','ecgSystem',${system})
- Based on Class, select Ecological Group: autocomplete search('groups','matches','ecgClass',${class})
- Based on Ecological Group, select Community Type: autocomplete search('groups','matches','ecgName',${ecological_group})